Hi ,
I wish to know if we can make charts using aspose.pdf or we will have to use aspose.cell to create worksheet and then convert it to pdf. Also I am facing size issues when I am converting excel to pdf.
Please help.
Abhi
Hi ,
Hi,
Thanks for your reply.
I have found for .net something like below
sheet.PageSetup.Zoom = 67;
sheet.PageSetup.LeftMarginInch = .5;
sheet.PageSetup.RightMarginInch = .5;
sheet.PageSetup.TopMargin = .5;
sheet.PageSetup.BottomMargin = .5;
sheet.PageSetup.PaperSize = PaperSizeType.PaperLegal;
sheet.PageSetup.Orientation = PageOrientationType.Landscape;
do we have same for Java? Please reply.
Hi,
“also I am finding some issues with size fixing in pdf. It is all fine in excel but some issues on fitting the charts in pdf. can you please suggest some of the tips on this.”
The PDF generated by Aspose.Cells for .NET is based on what is seen in Print Preview in MS Excel.
Please download and try this fix: Aspose.Cells for .NET v7.3.0.6
If you still find the issue, kindly save the excel file and give us your output PDF file here, we will check it soon.
And, please see the parallel JAVA code (using Aspose.Cells for JAVA, e.g v7.3.0.0 (you may download from the site’s “Download” module)):
sheet.getPageSetup().setLeftMarginInch(.5);
sheet.getPageSetup().setRightMarginInch(.5);
sheet.getPageSetup().setTopMargin(.5);
sheet.getPageSetup().setBottomMargin(.5);
sheet.getPageSetup().setPaperSize(PaperSizeType.PAPER_LEGAL);
sheet.getPageSetup().setOrientation(PageOrientationType.LANDSCAPE);