Analyzing your prompt, please hold on...
An error occurred while retrieving the results. Please refresh the page and try again.
Get Max Range In A Worksheet
Contents
[
Hide
]
When reading data from the worksheet, we need to know the maximum area.
When copying all data from a worksheet, we need to know the maximum area.
When exporting the specified area to HTML and PDF, we need to know the maximum area.
Aspose.Cells for Python via .NET contains different ways to find the max range in a worksheet.
How to Get Max Range
In Aspose.Cells for Python via .NET, if the row and column objects are initialized, these rows and columns will be counted toward the maximum area, even if there is no data in empty rows or columns.
How to Get Max Data Range
In most cases, we only need to obtain the range containing all the data, even if the empty cells outside the range are formatted, and settings for shapes, tables, and pivot tables are ignored.
How to Get 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 code shows how to render the max display range to HTML:
Here is the source Excel file: Book1.xlsx.