Hi,
I am unable to remove/hide the grid lines. Can you advise please?
UPDATE: I have noticed that saving to Excel format removes the grid lines but saving to PDF does not. I have even read the Excel file (without gridlines) back in and saved it to PDF and the grid lines are added back so it appears that the SaveToPDF method is actually adding grid lines.
My Code:
Workbook workBook = new Workbook();
workBook.LoadFromFile(excelFileName);
foreach (Worksheet workSheet in workBook.Worksheets)
{
workSheet.GridLinesVisible = false;
workSheet.GridLineColor = ExcelColors.White;
workSheet.SaveToPdf(newFileName);
}