we are doing a POC to see if we can use this component in our application.
We have an excel file with three sheets: a data sheet, which contains all the data; and two other sheets with graphs that use the data of the data sheet.
Currently we export this excel with the SaveToStream method, as explained in the tutorial "NET-Excel-New-method-of-Convert-Excel-to-PDF":
- Code: Select all
wb.SaveToStream(pdfStream, Spire.Xls.FileFormat.PDF);
This exports all three sheets.
However, we want to export only one sheet with the graph to PDF.
We cannot create a new workbook and copy the sheet to it, because then the data is absent and so the graph is empty.
So basically we need a way to specify which sheet(s) we want to export to pdf.
Is there a way to do that?