Excel to PDF Page size issue #3103

New Issue

Sarsewar · 2024-04-03T18:29:21Z

Sarsewar commented

2024-04-03 18:29:21 +00:00

Please find attached Demo_Excel.xlsx, which we are currently using to convert to PDF. The conversion process is being conducted directly on DocuSign. However, we've encountered issues regarding page size and scaling, as illustrated in the screenshots below. Despite attempting conversion through other online free platforms specializing in direct XLSX to PDF conversion, we've encountered the same issues. Notably, the same Excel file converts correctly using Microsoft's "Save As" or "Print" functionality.

We have explored various combinations in the worksheet's XML, including adjustments to pageSize, scale, fitToWidth, and fitToHeight, yet none have proven successful. We seek your insights into the possible reasons for these challenges.

fitToPage	fitToWidth	fitToHeight	Scale
0	0	0	0
0	0	0	1
0	0	1	0
0	0	1	1
0	1	1	1
0	1	0	1
0	1	1	0
0	1	0	0
1	0	0	0
1	0	0	1
1	0	1	0

Your guidance in resolving this matter is greatly appreciated.

Please find attached [Demo_Excel.xlsx](https://github.com/exceljs/exceljs/files/14717537/Demo_Excel.xlsx), which we are currently using to convert to PDF. The conversion process is being conducted directly on DocuSign. However, we've encountered issues regarding page size and scaling, as illustrated in the screenshots below. Despite attempting conversion through other online free platforms specializing in direct XLSX to PDF conversion, we've encountered the same issues. Notably, the same Excel file converts correctly using Microsoft's "Save As" or "Print" functionality. We have explored various combinations in the worksheet's XML, including adjustments to pageSize, scale, fitToWidth, and fitToHeight, yet none have proven successful. We seek your insights into the possible reasons for these challenges. fitToPage | fitToWidth | fitToHeight | Scale -- | -- | -- | -- 0 | 0 | 0 | 0 0 | 0 | 0 | 1 0 | 0 | 1 | 0 0 | 0 | 1 | 1 0 | 1 | 1 | 1 0 | 1 | 0 | 1 0 | 1 | 1 | 0 0 | 1 | 0 | 0 1 | 0 | 0 | 0 1 | 0 | 0 | 1 1 | 0 | 1 | 0 ![image](https://github.com/exceljs/exceljs/assets/26505197/1a890475-5121-4752-92a8-fabed22168b0) Your guidance in resolving this matter is greatly appreciated.

sheetjs commented

2024-04-03 19:29:57 +00:00

XLSX -> PDF conversion is offered in our Pro compendium

To your specific question, it's unclear what the issue is. If you open the spreadsheet in Excel and look at Sheet2, Cell A1 has the text "Header". It has a custom row height and left/middle alignment. There is no header or footer content.

If you are running into issues with DocuSign, it is strongly recommended to reach out to their technical support. If you would like further assistance from the SheetJS team, please join our chat

XLSX -> PDF conversion is offered in our [Pro compendium](https://sheetjs.com/pro) To your specific question, it's unclear what the issue is. If you open the spreadsheet in Excel and look at Sheet2, Cell A1 has the text "Header". It has a custom row height and left/middle alignment. There is no header or footer content. If you are running into issues with DocuSign, it is strongly recommended to reach out to their technical support. If you would like further assistance from the SheetJS team, please join our [chat](https://sheetjs.com/chat)

sheetjs closed this issue

2024-04-03 19:29:58 +00:00

Sign in to join this conversation.