Is there a way to show grid lines when saving Excel file to PDF?

Is there a way to show grid lines when saving Excel file to PDF?

Posted by: jerrad.elmore on 24 October 2025, 8:15 am EST

• 

  jerrad.elmore

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 October 2025, 8:16 am EST

  When I save a workbook using SaveFileFormat.Pdf, the resulting file does not show grid lines around the cells. Is there a way to include the grid lines? There is a ShowGridLines option when saving to an image file, but I don’t see any such option when saving to PDF.

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 27 October 2025, 12:13 am EST

  Hi Jerrad,

  To display gridlines when exporting to PDF, it is required to enable the PrintGridlines property on the worksheet’s PageSetup object before saving:

  foreach (IWorksheet sheet in workbook.Worksheets) {
      sheet.PageSetup.PrintGridlines = true;
  }
  workbook.Save("output.pdf", SaveFileFormat.Pdf);

  You can further refer to the attached sample that uses the above code snippet and prints the gridline in the exported PDF without any issues (see below).

  Please let us know if you encounter any further issues or require additional assistance.

  Best Regards,
  
  Chirag Gupta

  References:

  1. Style and Formatting Settings: https://developer.mescius.com/document-solutions/dot-net-excel-api/docs/online/ManageFileOperations/ImportandExportSpreadJSFiles/style-and-formatting-settings
  2. PrintGridlines API: https://developer.mescius.com/document-solutions/dot-net-excel-api/api/online/DS.Documents.Excel/GrapeCity.Documents.Excel.IPageSetup.PrintGridlines.html#GrapeCity_Documents_Excel_IPageSetup_PrintGridlines_
  3. Configure Sheet Print Settings: https://developer.mescius.com/document-solutions/dot-net-excel-api/docs/online/Features/print/ConfigurePrintSettingsviaPageSetup/ConfigureSheetPrintSettings#site_main_content-doc-content_title

  Attachment: PDFGridLines.zip