I want to find all data in an excel sheet but I do not know how many rows/columns actually have data. So is there a method for doing so in apose.cells. I have found
DataTable dataTable = worksheet.Cells.ExportDataTable(0, 0, 10, 7, true); and that works great except that I would like aspose to automatically detect what the values instead of 10 and 7 should be when processing a new sheet.
Or maybe I should use a completly different approach to extract data from a sheet?
Please use the Cells.MaxDataRow & Cells.MaxDataColumn properties to dynamically find out the max row & column numbers of the data range on a worksheet. Try the following code and feel free to get back in case you have further questions.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.
Sets consent for personalized advertising.
Cookie Notice
To provide you with the best experience, we use cookies for personalization, analytics, and ads. By using our site, you agree to our cookie policy.
More info
Enables storage, such as cookies, related to analytics.
Enables storage, such as cookies, related to advertising.
Sets consent for sending user data to Google for online advertising purposes.