Get Max Range In A Worksheet

Getting max range

In Aspose.Cells ,if the row and column objects are initialized, these rows and columns will be counted to the maximum area, even if there is no data in empty rows or columns.

Getting max data range

In most cases, we only need to obtain all the ranges containing all the data, even if the empty cells outside the range are formatted. And the settings about shapes, tables and pivottables will be ignored.

Getting max display range

When we export all data from the worksheet to HTML, PDF, or images, we need to obtain an area containing all visible objects, including data, styles, graphics, tables, and pivot tables. The following codes show how to render the max diplay range to html:

Here is source excel file.