how to fix blank Row and Column issue in export SSRS report to excel file

after we completed the report and deployed it to the sharepoint report library. it looks good when the user view the report in the browser.

however there is not annoying empty row and column found in the excel when user exported the report to excel file.




the fix is extreme easy. we only need to modify the location coordinate of the Tablix object in the report.



Set the Left and Top position in Location Property to be 0in