HI,
I have generated excel from pdf using aspose pdf.excel generated successfully.but when tried to parse the excel get the data by some Java API(POI and JEXCEL) it is giving me invalid header signature exception.this is because the excel Is not a pure form of excel.it is sphreadsheet ML which is saved as an excel by aspose pdf.
is there are any way I can get the pure excel from aspose pdf.please find the code I have used below.
com.aspose.pdf.Document pdfDocumentW = new com.aspose.pdf.Document("/PDF/Test Report.pdf");
com.aspose.pdf.ExcelSaveOptions svopt=new com.aspose.pdf.ExcelSaveOptions();
pdfDocumentW.save("/PDFS/Test Report.xls",svopt);
please find the source pdf file and generated xls also as attachment.
iam getting the below exception while parsing the generated excel(Test Report.xls).
Invalid header signature; read 0x6576206C6D783F3C, expected 0xE11AB1A1E011CFD0 - Your file appears not to be a valid OLE2 document
Hi Surya,
Thanks for using our API’s.
Yes you are correct. The Worksheet saved from PDF file using Aspose.Pdf for Java is an XML based Spreadsheet. However in order to resolve your problem, you may consider opening the resultant worksheet with Aspose.Cells for Java and save the output in required XLS format. For further details, please visit