How to use PageSetup in SpreadStreamProcessing

[John]

Hi,

I like to use the PageSetup in RadSpreadstreamProcessing. I have an generated Excel File and I would like to set Papersize and other configurations. When I integrate it in my Code the IPageSetupExporter is not known.

using (IWorkbookExporter workbookExporter = SpreadExporter.CreateWorkbookExporter(format, documentStream))
            {
                using (IWorksheetExporter worksheetExporter = workbookExporter.CreateWorksheetExporter(nameWorksheet))
                {

                 ..........

               using (IPageSetupExporter pageSetupExporter = worksheetExporter.CreatePageSetupExporter())
                        {

                        ..................

                        }

               }

           }

I get also the message that the IWorksheetExporter doesn't include a definition "CreatePageSetupExporter"?

Has anyone an example how to use this?

Regards

John

[Svilen]

Hi, John,

Svilen here, I will be glad to help out with this question.

On my end, your code structure works as expected. I have attached a small sample project using it, where I've populated both the cell export area (within the IWorksheetExporter using and before the IPageSetupExporter one). Do you mind sharing your example project so we can take a closer look? If you are using the library to append content to any existing .xlsx/.csv files, please also include them in your attachment.

I will stand by for your response. Thank you in advance.

Regards,
Svilen
Progress Telerik