Export to excel with formatting but no page breaks

English Forum
1

I have a problem with exporting to excel. I haven’t found a way to import my report with formatting (cell coloring) but without page divisions. I always have a blank row between the table.
I used the following parameters:
cfg.ExportOptions.Add(LlExportOption.XlsAllPagesOneSheet, “1”);
cfg.ExportOptions.Add(LlExportOption.XlsIgnoreHeaderFooterLines, “0”);
cfg.ExportOptions.Add(LlExportOption.XlsAutoFit, “1”);

2

There exists the export option Export.InfinitePage for that - this should do the trick I think:

...
cfg.ExportOptions.Add(LlExportOption.ExportInfinitePage, “1”);
...

In the API documentation you will find it here: Export.InfinitePage.

1 Like