Hello,
Thanks for your feedback.
Sorry for the late reply as weekend. For your requirement, you can refer to the following code sinppet. The first parameter specifies the range of table in excel file, the second parameter determines whether to export the first row of the table as column name, and the third parameter determines whether to evaluate the formula value.
If you have any issue, just feel free to contact us.
- Code: Select all
//Specifies the scope of the table
CellRange table1 = sheet.getRange().get("B1:C7");
//Export the data to datatable
DataTable dataTable = sheet.exportDataTable(table1,false,false);
Sincerely
Abel
E-iceblue support team