5 Answers, 1 is accepted
0
Hello Anu,
Setting the grid lines as described in the Show or hide gridlines on a worksheet is a feature specific to MS Excel and is not available in Telerik Reporting.
Depending on your report layout and structure some report items may have borders, but the default Excel grid lines will not be visible.
Regards,
Nasko
Telerik
Setting the grid lines as described in the Show or hide gridlines on a worksheet is a feature specific to MS Excel and is not available in Telerik Reporting.
Depending on your report layout and structure some report items may have borders, but the default Excel grid lines will not be visible.
Regards,
Nasko
Telerik
Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
0
Werner
Top achievements
Rank 1
answered on 13 Aug 2020, 08:00 PM
Is this still the case? Is there a way to default the excel grid lines to always show after export is completed?
0
Hi Werner,
The visibility of the grid lines in Excel is set to false by default, but can be changed through the device information settings. The name of the key is ShowGridlines. To make the grid lines visible during export fro, for example, the Standalone Report Designer, the following section needs to be added to its configuration file: <Telerik.Reporting>
<extensions>
<render>
<extension name="XLSX">
<parameters>
<parameter name="ShowGridlines" value="true"/>
</parameters>
</extension>
</render>
</extensions>
</Telerik.Reporting>
The reports produced with Standalone Report Designer will be probably rendered in an application. If you need to have the gridlines visible when exporting from this application to Excel, the same section needs to be added to the application configuration file as well.
Best Regards,
Silviya
Progress Telerik
0
Werner
Top achievements
Rank 1
answered on 18 Aug 2020, 01:31 PM
Thank you, It worked! However, for me the Telerik Report control only allows exports of Excel 97 -2003, so I had to change the extension name from "XLSX to XLS.
0