How to Control Workbook View

Possible Usage Scenarios

When you need to adjust the display of Excel pages, you need to know how to control each module, such as horizontal and vertical scrollbars, whether to hide open Excel files, and so on. Aspose.Cells offers this feature. Aspose.Cells provides the following properties and methods to help you to achieve your goals.

• WorkbookSettings.IsHScrollBarVisible
• WorkbookSettings.IsVScrollBarVisible
• WorkbookSettings.IsHidden
• WorkbookSettings.IsMinimized
• WorkbookSettings.WindowHeight
• WorkbookSettings.WindowWidth
• WorkbookSettings.WindowLeft
• WorkbookSettings.WindowTop

How to Control Workbook View using Aspose.Cells for .NET

This example shows how to:

1. Create a workbook.
2. Add data to cells in the first worksheet.
3. Hide horizontal and vertical scrollbars of Workbook View.

//Instantiating an Workbook object
Workbook workbook = new Workbook();
//Obtaining the reference of the newly added worksheet
Worksheet ws = workbook.Worksheets[0];
Aspose.Cells.Cells cells = ws.Cells;

//Setting the value to the cells
Aspose.Cells.Cell cell = cells["A1"];
cell.PutValue("Fruit");
cell = cells["B1"];
cell.PutValue("Count");
cell = cells["C1"];
cell.PutValue("Price");

cell = cells["A2"];
cell.PutValue("Apple");
cell = cells["A3"];
cell.PutValue("Mango");
cell = cells["A4"];
cell.PutValue("Blackberry");
cell = cells["A5"];
cell.PutValue("Cherry");

cell = cells["B2"];
cell.PutValue(5);
cell = cells["B3"];
cell.PutValue(3);
cell = cells["B4"];
cell.PutValue(6);
cell = cells["B5"];
cell.PutValue(4);

cell = cells["C2"];
cell.PutValue(5);
cell = cells["C3"];
cell.PutValue(20);
cell = cells["C4"];
cell.PutValue(30);
cell = cells["C5"];
cell.PutValue(60);

cell = cells["E10"];
Style temp = workbook.CreateStyle();
temp.Font.Color = Color.Red;
cell.SetStyle(temp);

//Hide horizontal and vertical scrollbars
workbook.Settings.IsHScrollBarVisible = false;
workbook.Settings.IsVScrollBarVisible = false;

workbook.Save("out.xlsx");

Result file preview: