Export to Excel looks like image

[Toya]

I am trying to use the export to Excel function of the report server and it opens the Excel file and all the cell borders are gone and the report looks like it does in HTML. Here is image of what it looks like in Excel. We are on 2024 4th Qtr version of the report server. How can I make it look like real Excel file? 

[Petar]

Hello Toya,

Thank you for providing the screenshot with the observed behavior.

When you mentioned the absence of table cell borders, were you referring to the gridlines of Excel or to actual borders that you added using styles?

If you are asking about the gridlines, please note that these are disabled by default. You can, however, enable them by setting the ShowGridlines device information setting to True. In the report file, you can set it through the RuntimeSettings property of the report item, as outlined in the following article:

If you are asking about missing cell borders that you added manually with styles, I would expect them to be rendered in the final output. If this is not the case, however, it would be very helpful if you could provide a sample report file that reproduces the issue so that I can investigate it further.

Also, please note that the dimensions in the Excel export are preserved. If you would like to remove the padding on the left and right sides of the table, or apply additional styles that should only affect the XLSX rendering format, you can use Conditional Formatting rules or Bindings. There, you can utilize the RenderingFormat global object to check if the rendering format is "XLSX" and then apply the desired changes.

For example, with Bindings, you can adjust the table's Location property to position it in the top-left corner:

I hope this helps. Please let me know if you need any further assistance with this matter.

Regards,
Petar
Progress Telerik