Ignore styles to get better performance in GridWeb

Possible Usage Scenarios

Please use the GridWeb.IgnoreStyleWithNoData property to load fewer rows and columns from the workbook.

Get Better Performance While Loading Workbook

Please check the sample Excel file

When IgnoreStyleWithNoData is set to true:

As you can see, it shows rows up to 15 and columns up to L. It will not display the last continuous rows and columns without data in cells. Thus, the load time will be reduced.

workbook with ignore style

When IgnoreStyleWithNoData is set to false (the default value is false):

As you can see, it shows many more rows (up to 500) and columns (up to CZ).

From row 16 to row 500, some of the cells have the border style set, however the cells contain no data.

From column M to column CZ, some of the cells have the border style set, however the cells contain no data.

workbook without ignore style