Free Support Forum - aspose.com

Workbook edit(ver aspose-2.5.3.2006)

Hi,
I’ve transferred my gridweb content to excel sheet. Now i’ve to turnoff defaultgridline property and row and column header display property of the workbook(Excel file). can you please suggest any solution for this .

Many Thanks,
Assal

Hi,


For Aspose.Cells.GridWeb control, you may try to set the properties to “False”:
ShowDefaultGridLine and ShowHeaderBar attributes of GridWeb control.

For Excel file manipulation regarding on/off Gridlines and column/row headers using Aspose.Cells library/component, see the documents:
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/display-or-hide-gridlines.html
http://www.aspose.com/documentation/.net-components/aspose.cells-for-.net/display-or-hide-rowcolumn-headers.html

Thank you.

Hi,

Please refer to this document to hide the gridlines on a wokbook: Display or Hide Gridlines

For the above article, you will have to use Aspose.Cells for .NET.

You can also turn of Aspose.Cells.GridWeb gridlines property: ShowDefaultGridLine Property

You can set it to false and then export your file and for this you do not need Aspose.Cells for .NET. Only Aspose.Cells.GridWeb should suffice.