Current Page: Example Center >Assign the table with defined name in Excel template
1.This demo shows how to use openTableByDefinedName method to assign a table with defined name and how to get the data from each cell in this Table.

openTableByDefinedName
2.This demo shows without modifying the code, filling data into two Excel template customized by user will have two different results. Note: openTable method is not applicable in this case.

Excel template I

Excel template II
3.This demo shows two results by using openTable and openTableByDefineName methods to fill data into the same Excel template with rows dynamically increasing. Note: openTable method is not applicable in this case.

Open the template (test4.xlsx)

Use openTable method-----Tables are overlapped.

Use openTableByDefineName method-----Tables are separated.