Viktor.convert_excel_to_pdf() changes column width in pdf

🚀 Support (Q&A)
1

I have an excel sheet which I export to pdf with the viktor.convert_excel_to_pdf() function. Within Excel I have selected the page setup to fit the sheet according to the picture:

image
image203×121 2.42 KB

This works well within excel and also seems to make sure the pdf is fitted to one page.

However, when I export the sheet to pdf with the viktor function, the column widths seem to change and become wider, causing the layout to change.

This also happens when I is use the scaling option for page setup (also if it is set to 100%) as:

image
image195×122 2.04 KB

Is there a way to prevent this change in column width? I would preferrably not use openpyxl as some data seems to get lost.

2

Hi @AnneOffermans ,

Thank you for this question. The service we provide to convert Excel to PDF uses the opensource variant of Excel in the background (LibreOffice). Therefore, if you want to ensure that your format is as expected, I would recommend setting it up in LibreOffice, and check how that converts.