Hi, <?xml:namespace prefix = o />
We currently use ASPOSE CELLS 8.3.1 to generate xlsx/pdf final files based on a model.
The process is :
- Open the model
- - Select data to populate the model
- Modify spreadsheet by deleting columns and/or lines depending of the data
- Save as final file
I have an issue with “Printed Area” management when I’m deleting columns.
i.e., my model is a spreadsheet with 100 columns which printed area is whole 100 columns, 20 columns per page, so 5 pages.
If I delete 95 columns using Cells().deleteColumns(x,y,true), in the final file I still have 5 pages with 1 column by page.
Is there a way to manage the printed area and to reformat the output of the spreadsheet ?
for your help!