Spara varje kalkylblad i en separat PDF fil

Spara varje arbetsblad i en separat PDF-fil

Om du behöver spara varje kalkylblad i din mall-Excel-fil för att generera olika PDF-filer kan du enkelt uppnå detta. Du kan försöka ställa in ett kalkylbladsindex till PdfSaveOptions.SheetSet-alternativet i taget för att rendera till PDF.

// For complete examples and data files, please go to https://github.com/aspose-cells/Aspose.Cells-for-.NET
// The path to the documents directory.
string dataDir = RunExamples.GetDataDir(System.Reflection.MethodBase.GetCurrentMethod().DeclaringType);
// Get the Excel file path
string filePath = dataDir + "input.xlsx";
// Instantiage a new workbook and open the Excel, File from its location
Workbook workbook = new Workbook(filePath);
// Get the count of the worksheets in the workbook
int sheetCount = workbook.Worksheets.Count;
// Define PdfSaveOptions
PdfSaveOptions pdfSaveOptions = new PdfSaveOptions();
// Take Pdfs of each sheet
for (int j = 0; j < sheetCount; j++)
{
Worksheet ws = workbook.Worksheets[j];
//set worksheet to output
SheetSet sheetSet = new SheetSet(new int[] { ws.Index });
pdfSaveOptions.SheetSet = sheetSet;
workbook.Save(dataDir + "worksheet-" + ws.Name + ".out.pdf", pdfSaveOptions);
}