Frozen row/column

[Manar]

Hello,


1-Can we froze some columns/rows in table in telerik report while we exporting it to Excel sheet?
2-also how we can have more than one sheet with different params in the same Excel file?
3-How can I set the "fitsheet in one page" option? or the print area??

I need your help ASAP please.


Thanks,
Manar

[IvanY]

Hello Manar,

Up to your questions:

1. Yes, you can freeze some cells in Excel upon exporting your report. To do so you have to use the Page Header of the report - the cells will be rendered in Excel as frozen rows.
2. You can use a ReportBook as a container for you reports. You can add it it multiple instances of the same report class with different parameters. In this way each report will be exported to a single sheet in the workbook.
3. Currently it is not possible to control this Excel option from Telerik Reporting.

All the best,
IvanY
the Telerik team

[Manar]

Hello,

Thanks a lot for your reply.


1- Just page header? what if I want to freeze some columns in the table in the details area?

2- Got it, thanks.

3- There is no any work around?


I appreciate your help
Thanks,
Manar

[IvanY]

Hi Manar,

1. Only the page header can generate frozen rows. Since Telerik Reporting is not designed to work specifically with Excel the frozen rows are just representation of our page header. Because in other formats there is no such notion as frozen rows they are not configurable.
2. Again since Telerik Reporting is not designed to work specifically with Excel and Excel has a lot of options we do not provide a way to configure them. That is why you will have to adopt your own way of additionally configuring the exported excel files.

Kind regards,
IvanY
the Telerik team

[Manar]

Thanks for your reply.

I tried to use another component just to open the generated Excel file and set the page setup as I need.
the component is "Aspose" but I faced the following error while trying just to open the Telerik generated file, but didn't face the error with any other excel files ( Created by hand) 

Index was out of range. Must be non-negative and less than the size of the collection.
Parameter name: index

So it seems to me an issue in the generated Excel file.


Any suggestion please?

I appreciate your help

Thanks,
Manar

[IvanY]

Hi Manar,

We will need some more information about the report you tried to open. It will also be good if you can test when the exception is thrown. First try exporting and opening an empty report and then if that does not fail start building your report step by step until you reach the point with the exception. The steps to reproduce the issue will help us identify the culprit faster.

Please also note that if the report can be opened in Excel but cannot be processed by Aspose it is actually their problem since the produced xlsx file is valid. If that is the case we will be able to only confirm that we are producing valid xlsx files and you should contact Aspose.

Greetings,
IvanY
the Telerik team