This is a migrated thread and some comments may be shown as answers.

Exporting report to Excel 2007: Scale to Fit, shrink width in 1 page

4 Answers 284 Views

General Discussions

This is a migrated thread and some comments may be shown as answers.

Epep asked on 14 Aug 2018, 07:27 PM

Hi,

I have created several reports using Telerik reporting. But when the user exports a report, at least to Excel, I have to be able to set the Width to 1 page by default. I have tried several options but I don't seem to be able to set this property using the configuration sections. I am currently using reports in an MVC project. In the device information settings for Excel 2007, I cannot find any configuration to control this property. Is there some how to achieve this?

This requirements is a must from the client, since they don't want to go to the Page Setup -> Scale to Fit menu on Excel to do this change. Currently they have a completely custom solution to generate reports in Excel and this option is already set on this solution, so they consider this missing functionality as a downgrade to their current solution which is unacceptable for them.

I would appreciate a lot to have the same functionality also on PDF, since their reports are quite large and they want to fit them inside one page when exporting to PDF (I know I can play with the font sizes and textbox/table columns sizes but since I have already done the reports, doing these changes will require a lot of time which I unfortunately don't have at this moment).

Thanks

4 Answers, 1 is accepted

answered on 17 Aug 2018, 09:39 PM

Hello Nasko,

I have also opened a support ticket. Actually I need to find a way how to update the Excel file through the OnGetDocument method. I am able to get the byte array but whenever I try to convert it by using any components (in my case I tried with EPPlus), the Excel file does not load the data. I think there might be some encoding issue, but I don't know what's the encoding on the args.Bytes property.

I think, if I am able to correctly get and update the args.Bytes property, it will be much easier to not just set the Fit Sheet on One Page, but also to make more changes to the export result.

Kind Regards

answered on 22 Aug 2018, 10:35 AM

Hello Epep,

I answered your queries in the support ticket you opened on the same topic. I will summarize my answers also here.

EPPlus is a third part library that we do not claim to support.
For Excel and other Microsoft Office formats Telerik Reporting internally uses Open XML SDK for Microsoft Office. You can test using the same package for post-processing the already rendered Excel report.

An alternative is to use Telerik Document Processing Libraries.

The XLSX rendered report is encoded with UTF-8.

Note that the response time for your support plan is 72 hours (check Support Plans).

Regards,
Todor
Progress 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