Spire.PDF is a professional PDF library applied to creating, writing, editing, handling and reading PDF files without any external dependencies. Get free and professional technical support for Spire.PDF for .NET, Java, Android, C++, Python.

Wed Feb 23, 2022 9:04 am

Hi, I am using Spire.PDF to convert PDF documents into excel. However, I wish to have all the PDF pages appear in the same sheet (ie they appear as one continuous column in the same sheet). Is there any way to achieve this?

Attached is an example of what I am trying to achieve.

yangiiyu
 
Posts: 12
Joined: Mon Feb 07, 2022 7:00 am

Wed Feb 23, 2022 9:29 am

Hello,

Thanks for your inquiry!

Please refer to the following code to put all pages into a same sheet when convert the PDF to Excel. If the issue still exists, please provide us with your input file for further investigate. Thanks in advance!
Code: Select all
            PdfDocument pdf = new PdfDocument();
            pdf.LoadFromFile("E:\\testdoc\\samplePages.pdf");
            //XlsxTextLayoutOptions(bool convertToMultipleSheet, bool showRotatedText);
            XlsxTextLayoutOptions options = new XlsxTextLayoutOptions(false, true);
            pdf.ConvertOptions.SetPdfToXlsxOptions(options);
            pdf.SaveToFile("res.xlsx",FileFormat.XLSX);


Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Thu Mar 03, 2022 9:54 am

Hello,

Hope you are doing well!

Has the issue been solved now? Could you please give us some feedback at your convenience?

Thanks in advance.

Sincerely,
Marcia
E-iceblue support team
User avatar

Marcia.Zhou
 
Posts: 858
Joined: Wed Nov 04, 2020 2:29 am

Return to Spire.PDF