var workbook = ExcelFile.Load("officeDials.xlsx");
var worksheet = workbook.Worksheets[0];
worksheet.PrintOptions.PrintHeadings = true;
worksheet.PrintOptions.PrintGridlines = true;
worksheet.NamedRanges.SetPrintArea(worksheet.Cells.GetSubrange("A2", "C33"));
var options = new HtmlSaveOptions()
{
HtmlType = HtmlType.Html,
SelectionType = SelectionType.EntireFile
};
workbook.Save("officeDials.html", options);
Leave a comment