I need to open an existing Excel file that contains many worksheets and save only one of them as a PDF file. I found in another thread that I can set the IsVisible property to False for all worksheets I don't want to see. So far so good.
But (see the attached project and files) ...
- Some values in the Excel file are replaced with ##### (check the AUM and VaR Used) columns
- Some labels are incorrectly position (check the "Position Of:" label at the top of the sheet)
- Some color formatting are lost (check Q48 - background is red)
I use the following versions:
- Aspose.Cells.dll - 22.214.171.124
- Aspose.Pdf.dll - 126.96.36.199