1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 |
using Spire.Xls; using System.Diagnostics; namespace ConvertExcelToPdfWithDefaultPageSettings { class Program { static void Main(string[] args) { // Create a Workbook object Workbook workbook = new Workbook(); // Load an Excel document workbook.LoadFromFile("file.xlsx"); // Get a specific worksheet Worksheet sheet = workbook.Worksheets[0]; PageSetup pageSetup = sheet.PageSetup; pageSetup.PaperSize = PaperSizeType.PaperA4; pageSetup.IsPrintGridlines = true; // Convert it to a PDF file sheet.SaveToPdf("WorksheetToPdf.pdf"); Process.Start("explorer.exe", $"/select,\"WorksheetToPdf.pdf\""); Console.WriteLine(sheet.Name + " is converted to PDF successfully."); // Dispose resources workbook.Dispose(); } } } |