Ignore styles to get better performance in GridWeb
Contents
[
Hide
]
Possible Usage Scenarios
Please use GridWeb.IgnoreStyleWithNoData property to load less required rows/columns from the workbook.
Get Better Performance While Loading Workbook
Please check the sample excel file
When set IgnoreStyleWithNoData = true;
As you can see ,It shows rows (to 15) and columns (to L),It will not display the last continus rows and columns without data in cells.Thus the load time will be less.
When set IgnoreStyleWithNoData = false;(the default value is false)
As you can see ,It shows much more rows (to 500) and columns (to CZ)
From row 16 to row 500,some of the cells has set the boder style,however the cells contains no data.
From column M to column CZ,some of the cells has set the boder style,however the cells contains no data.