DisplayGridlines and zoom

Aspose.Cells Product Family
1

Hi

Does aspose support DisplayGridlines and zoom?

Here is the code in MS-EXCEL

excel.ActiveWindow.DisplayGridlines = False

Excel.ActiveWindow.Zoom = 65



Thank you
2

please discard this post. I found the solution. Big Smile

3

@me2005,
Aspose.Excel is no more available now and is replaced by another advanced product Aspose.Cells that contains all the latest features available in different versions of MS Excel. Aspose.Cells provides complete control over the worksheet views like page break preview, setting zoom factor, freezing panes and splitting panes. Similarly, you can show/hide gridlines and row/column headers. Here is an example that demonstrates the feature of hiding the grid line and setting the zoom level to a specific value.

// Instantiating a Workbook object
// Opening the Excel file through the file stream
Workbook workbook = new Workbook();

// Accessing the first worksheet in the Excel file
Worksheet worksheet = workbook.Worksheets[0];

// Hiding the grid lines of the first worksheet of the Excel file and setting zoom to 70
worksheet.IsGridlinesVisible = false;
worksheet.Zoom = 70;

// Saving the modified Excel file
workbook.Save("output.xls");

Here is the program output:

Here are the articles those can be referred to show/hide grid lines and set zoom level:
Show and Hide Gridlines and Row Column Headers
Worksheet Views

Download the latest version for testing this product:
Aspose.Cells for .NET (Latest Version)

A ready to run solution is available here that can be used to test the variety of features of this new product.