Get Max Range In A Worksheet with Golang via C++

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 a specified area to HTML and PDF, we need to know the maximum area.

Aspose.Cells for C++ contains different ways to find the 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 towards the maximum area, even if they are empty.

Getting max data range

In most cases, we only need to obtain the range that contains all the data, even if empty cells outside the range are formatted. Settings related to shapes, tables, and pivot tables are 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 code shows how to render the max display range to HTML:

Here is the source Excel file.