I want to use flexscript to import the Data.xlsx file into GlobalTable1 according to the settings in the figure below, but it has not been successful.
Where is the problem?
Thanks for the help.
In the command "excelimporttable()" you have to actually specify the start row/column and number of rows/columns to import. The target table also must already have these dimensions as it will not automaically resize to fit the data and the data types of its columns must also match the data in the excel file.
You can also run the import defined in the interface with "excelmultitableimport()".
There are my excel sheets:
I made the following modifications:
but it shows error:
Are you trying to read a value from the tables after importing? Because you are not setting their size. Newly created tables will have one row and one column. As I mentioned already, the excelimporttable() command will not adjust their size by itself. Use "Table().setSize()" before you import.
Thanks, it works successfully. But I have a question. If the data in Sheet1 is a different array size every time I inport it, what should I do? Is there any other way besides directly setting a super large size?
18 People are following this question.
