Hi,
I am trying to use the Aspose.Cells component to convert a XLS to a PDF. The dataset contains 350 records. After converting to PDF, the 350 rows of data got
condensed into two pages in the PDF which is not readable unless zooming it to 800% in the PDF viewer.
I'm using Aspose.Cells v4.5.0.17 and PDF version 3.7.0.0
Below is the code for coverting to PDF:
Workbook workbook = new Workbook();
Worksheet sheet = workbook.Worksheets[0];
sheet.Name = "expenses";
Aspose.Cells.Cells cells = workbook.Worksheets[0].Cells;
sheet.Cells.ImportDataTable(dtData, false, "A8");
sheet.AutoFitColumns();
string _SaveAsFileName = "expenses.pdf";
string fileXML = "~/tempdata/xls2PDF.xml";
// Saving an XLS file in Aspose.Pdf xml format
workbook.Worksheets[0].PageSetup.FitToPagesWide = 1; //keeps all columns on same page
workbook.Save(Server.MapPath(fileXML), FileFormatType.AsposePdf);
// Converting XLS file to PDF through Aspose.Pdf using Aspose.Pdf xml file as a medium
Aspose.Pdf.Pdf pdf = new Aspose.Pdf.Pdf();
pdf.BindXML(Server.MapPath(fileXML), null);
pdf.IsLandscape = true;
pdf.IsTruetypeFontMapCached = true;
pdf.TruetypeFontMapPath = Path.GetTempPath();
pdf.Save(memStream);
Response.Clear();
Response.ClearHeaders();
Response.ClearContent();
Response.Charset = "UTF-8";
Response.AddHeader("Content-Length", memStream.Length.ToString());
Response.AddHeader("content-disposition", String.Format("attachment;filename={0}", saveAsFileName));
Response.ContentType = "Application/pdf";
Response.BinaryWrite(memStream.ToArray());
Response.Flush();
Response.End();