CODEWITHSUNDEEP
gembox-spreadsheet
Jonas Olesen
Jonas Olesen

Reputation: 568

Gembox spreadsheet. is there a way to make it fit to one page when saving to pdf

Im trying to find a way to convert xls files to pdf, and gembox spreadsheet is great for this. But i need to be able to make it fit to one page as you can when printing to pdf via excel.

Upvotes: 0

Views: 1993

Answers (1)

Mario Z
Mario Z

Reputation: 4381

Try specifying FitWorksheetWidthToPages and FitWorksheetHeightToPages properties.
For example like the following:

ExcelFile workbook = ExcelFile.Load("Sample.xls");
ExcelWorksheet worksheet = workbook.Worksheets.ActiveWorksheet;

worksheet.PrintOptions.FitWorksheetWidthToPages = 1;
worksheet.PrintOptions.FitWorksheetHeightToPages = 1;

workbook.Save("Sample.pdf");

I hope this helps.

Upvotes: 2

Related Questions