Spaces lost in PDF to xls

[abhijit.deshpande]

While converting some PDF files to xls format, the spacing between words is lost for a given cell .
This happens for selected PDFs from some vendors. For other files, such issue is not observed. But for such PDFs the spacing is lost in all the words in that file, no exceptions.
e.g.
AMOUNTDUE
StatementDate:
MinimumService

If the same PDF is extracted to text file format, this issue is not observed.
Due to confidentiality we cannot share the document, but has this issue been reported ever and is there a solution.

[Amin.Gan]

Hello,

Thank you for your inquiry.You can use the following code to test problematic PDF documents. If the problem still exists. To help us solve your problem faster and more accurately, please provide us with your original input PDF document.You can upload here or send it to us via email（ support@e-iceblue.com ). Thank you in advance.

Code: Select all

 PdfDocument pdf = new PdfDocument();
             pdf.LoadFromFile(@"input.pdf ");
            XlsxLineLayoutOptions xlsxLineLayoutOptions = new XlsxLineLayoutOptions(true, true, true);
            pdf.ConvertOptions.SetPdfToXlsxOptions(xlsxLineLayoutOptions);
            pdf.SaveToFile(@"output.xlsx", Spire.Pdf.FileFormat.XLSX);

Sincerely,
Amin
E-iceblue support team