We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Graphs in excel

i am having excel generate a graph for me based on the data in a worksheet in my template, i change the data for different reports so the excel changes the graph for me, when i convert the excel to pdf using the below code, the graphs dont get carried forward in my pdf report, may i know how can i do this? thanks.

dim licpdf as aspose.pdf.license

dim pdf1 as aspose.pdf.pdf = new aspose.pdf.pdf

dim mstreamxml as system.io.memorystream, i as int16

licpdf = new aspose.pdf.licenselicpdf.setlicense(server.mappath(

"bin\aspose.custom (excel, excel web, chart, pdf).lic"))

pdf1.istruetypefontmapcached = false

mstreamxml = new system.io.memorystream

'save the document in aspose.pdf.xml format.

lexcreport.save(mstreamxml, aspose.excel.fileformattype.asposepdf)

pdf1.bindxml(mstreamxml, nothing) for i = 0 to pdf1.sections.count - 1

pdf1.sections(i).islandscape = true


pdf1.save("debraadams.pdf", aspose.pdf.savetype.openinacrobat, response)

This message was posted using Aspose.Live 2 Forum


I think since you are using some older version of Aspose.Excel, the feature might not be supported. But using the newer Aspose.Cells (Aspose.Excel has been renamed to Aspose.Cells now which has a lot of advanced features), you can achieve your task. Kindly use Aspose.Cells (4.4.1) and Aspose.Pdf (3.6.2) for better results for your requirements.

Thank you.