ie. i have "sales", "order", "returns".. i'd like a PDF like
- Code: Select all
Sales
[A1]
[A2]
[A3]
Returns
[A1]
[A2]
[A3]
etc.
Thanks
Sales
[A1]
[A2]
[A3]
Returns
[A1]
[A2]
[A3]
Workbook workbook = new Workbook();
workbook.LoadFromFile(inputfile);
foreach(Worksheet sheet in workbook.Worksheets)
{
sheet.PageSetup.CenterHeader = "&A";
}
string output = "result.pdf";
workbook.SaveToFile(output,FileFormat.PDF);
using (var fsi = System.IO.File.OpenRead(@"aa.xls"))
{
using (var wb = new Spire.Xls.Workbook())
{
wb.LoadFromStream(fsi);
// wb.ConverterSetting.SheetFitToPage = true;
using (var fs = File.Create(@"res.pdf"))
{
foreach (Worksheet ws in wb.Worksheets)
{
//ws.ViewMode = ViewMode.Layout;
ws.PageSetup.CenterHeader = "&A";
ws.PageSetup.PaperSize = PaperSizeType.PaperA4;
// ws.PageSetup.IsFitToPage = true;
ws.PageSetup.FitToPagesWide = 1;
ws.PageSetup.FitToPagesTall = 1;
ws.PageSetup.PrintArea = null;
ws.GridLinesVisible = true;
ws.PageSetup.IsPrintGridlines = true;
ws.PageSetup.IsPrintHeadings = true;
ws.PageSetup.Orientation = PageOrientationType.Landscape;
ws.AllocatedRange.AutoFitColumns();
ws.AllocatedRange.AutoFitRows();
}
wb.SaveToStream(fs, Spire.Xls.FileFormat.PDF);
Console.WriteLine($"Saved workbook");
}
}
}
using (var fsi = System.IO.File.OpenRead(@"..\\..\\Sample - Superstore.xls"))
{
using (var wb = new Spire.Xls.Workbook())
{
wb.LoadFromStream(fsi);
using (var fs = File.Create(@"res3.pdf"))
{
foreach (Worksheet ws in wb.Worksheets)
{
ws.AllocatedRange.AutoFitColumns();
ws.AllocatedRange.AutoFitRows();
ws.PageSetup.CenterHeader = "&A";
ws.PageSetup.PaperSize = PaperSizeType.PaperA4;
ws.PageSetup.FitToPagesWide = 1;
ws.PageSetup.FitToPagesTall = 0;
ws.GridLinesVisible = true;
ws.PageSetup.IsPrintGridlines = true;
ws.PageSetup.IsPrintHeadings = true;
ws.PageSetup.Orientation = PageOrientationType.Landscape;
}
wb.SaveToStream(fs, Spire.Xls.FileFormat.PDF);
}
}
}