Free Support Forum -

Retrieve data from Cells

While exporting data from a worksheet:

1. Can I define a validation routine for each cell while retreiving data using either ExportDataTable() or ExportDataTableAsString() methods.

2. How to find the last row in a sheet that has data in a given column, starting from an arbitrary row.

3. How do I retrieve the calculated value of a cell which contains a formula.

This message was posted using Aspose.Live 2 Forum


1) Well, you may apply validation to the cells (using Aspose.Cells API) but when you export data to fill a data table, the validation attributes/options cannot be applied.

2) You can use Cells.MaxDataRow attribute.

3) Well, first you need to call Workbook.CalculateFormula() method then you may use Cell.Value or Cell.StringValue etc. API.

Thank you.