Show / Hide Table of Contents

Worksheet View Settings

Output: WorksheetView.xlsx

public void Run()
{
    var workbook = new Workbook();
    var worksheet = workbook.Worksheets[0];
    worksheet.Name = "View1";

    worksheet.Columns["A"].WidthPixels = 250;

    worksheet["A1"].Value = "Show formulas";
    worksheet["B2"].Formula = "=SUM(1)";
    worksheet["A2"].Value = "Do not show row and column headers";
    worksheet["A3"].Value = "Zoom 125%";
    worksheet["A4"].Value = "Tab color: Red";
    worksheet["A5"].Value = "Gridline color: Green";

    worksheet.View.ShowFormulas = true;
    worksheet.View.ShowRowColumnHeaders = false;
    worksheet.View.ZoomScale = 125;
    worksheet.Properties.TabColor = SpreadsheetColor.Red;
    worksheet.View.GridlineColor = SpreadsheetColor.Green;

    var worksheet2 = workbook.AddWorksheet("View2");
    worksheet2.Columns["A"].WidthPixels = 250;
    worksheet2["A1"].Value = "Do not show zeros";
    worksheet2["B1"].Value = 0;
    worksheet2["A2"].Value = "Do not show gridlines";
    worksheet2["A3"].Value = "Page Layout View Zoom 75%";
    worksheet2["A4"].Value = "Page Layout View";

    worksheet2.View.ShowZeros = false;
    worksheet2.View.ShowGridLines = false;
    worksheet2.View.ZoomScalePageLayoutView = 75;
    worksheet2.View.ViewType = SheetViewType.PageLayout;

    var worksheet3 = workbook.AddWorksheet("Right to Left");
    worksheet3.View.RightToLeft = true;

    workbook.SaveAs("WorksheetView.xlsx");
}
Back to top Generated by DocFX