Gembox Spreadsheet - Remove blank pages

Question

I dont know how achieve this, I have to create an informative report with images. For this, I use an excell template (It helps me with the format and with the position of the text where to place the respective information). The images are generated perfectly. I convert this XLS to PDF with the property

DocumentToMemoryStream (excelTemplate, XlsxSaveOptions.XlsxDefault);

This report generate blank pages in the PDF. How can I remove these blank pages, before the excel is generated?

score 2 · Answer 1 · answered Dec 09 '19 at 07:04

2

Without checking your spreadsheet it's impossible to tell from where do those empty pages come from, so can you upload your XLS?

Anyway, do you perhaps have some explicitly defined horizontal or vertical page breaks?
If yes, can you remove the ones you don't need?

Or, do you perhaps have empty columns at the end which have some kind of styling or formatting?
If yes, then you could try using something like this to remove those empty columns from exporting to PDF:

var workbook = ExcelFile.Load("input.xls");
var worksheet = workbook.Worksheets.ActiveWorksheet;

worksheet.NamedRanges.SetPrintArea(
    worksheet.GetUsedCellRange(true));

var options = new PdfSaveOptions();
options.SelectionType = SelectionType.ActiveSheet;
workbook.Save("output.pdf", options);

answered Dec 09 '19 at 07:04

Mario Z

4,328
2
24
38

Is there a way to detect if a page is blank? (Without text or images) – Oscar Moncayo Dec 09 '19 at 15:54
@OscarMoncayo that's not a simple task to do. It's much easier to avoid creating an empty page. – Mario Z Dec 10 '19 at 02:59
Your answer guided me to my solution, thank you very much!!!!! :DDD – Oscar Moncayo Dec 16 '19 at 23:07

score 0 · Accepted Answer · answered Dec 16 '19 at 23:13

I had a counter of the rows of the document I was writing on, thanks to the help of @Mario Z, I use this function, before the save and solve my problem of blank pages

wsimgs.NamedRanges.SetPrintArea(wsimgs.Cells.GetSubrange("A1",CellRange.RowColumnToPosition (countRow, 10)));

Gembox Spreadsheet - Remove blank pages

2 Answers2