This code sort of works:
try {workbook.save(XLSfile);} catch (IOException ex) {}
String XMLfile = "F://rpt_statement1.xml";
String PDFfile = "F://rpt_statement1.pdf";
try{ workbook.save(XMLfile,FileFormatType.ASPOSE_PDF);}catch (IOException ex) {}
try {
Pdf pdf = new Pdf();
pdf=Pdf.bindXML(new FileInputStream(XMLfile));
AT THIS POINT THE THE SYSTEM FAILS ... THE XML file created is 5000+kb and has a lot of white space where the empty excel row are.
error; java.lang.OutOfMemoryError: Java heap space
pdf.save(new FileOutputStream(PDFfile));
}catch(Exception ee)
{System.out.println(ee);}
How can I limit the size of the XML file created?