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

 

[Toya]

I have the gridlines working, what I am having an issue with now is when the table is exported to Excel it adds blank columns in between the columns. How can I address this issue? I tried to attach the Excel file but it won't let me, here is image 

[Petar]

Hi Toya,

Thank you for providing the screenshot.

It is difficult to identify the cause of this issue without reviewing the report file. I recommend checking the following documentation article, which outlines some common reasons for merged cells in the Excel rendering format:

• Excel Rendering - Merging Cells

If you followed the guidelines from the above article, but the issue persists, it would be very helpful if you could attach the report file in question along with some test data we could use during our investigation.

Please note that forum threads are public. If you prefer, I can create a support ticket for you, allowing you to attach your report file. Alternatively, you can open one yourself through our Support Center. When doing so, make sure to select "Reporting" as the product, since your DevCraft Complete license includes this option, rather than "Report Server".

Regards,
Petar
Progress Telerik

[Toya]

I tried to create a ticket but it won't let me upload files. It may be my company security policy blocking them. Is there another way to send you files? I tried the things in the article and they did not help. I did figure out that it's one blank column after each column of data. So they cells aren't merged like the image implies.  

[Petar]

Hello Toya,

You can try to send the report and the required data via our SFTP server, and we will take a look at it. I will create a ticket for you and follow up with the details shortly.

Regards,
Petar
Progress Telerik