I have some issue with table created manually vs table created with UiPath.Excel.Activities.ExcelCreateTable (link: https://activities.uipath.com/docs/excel-create-table)
I tried to use the example from this page, however, I can’t use excel function on this table, as if it’s not a real table for Excel :
“=SUBTOTAL(109;[Age])” isn’t working for the table generated by UiPath, while I can use it when I am manually creating a table, we can see it on this file:
Example_2_tables.xlsx (11.8 KB)
Does anyone know if I am doing something wrong when creating the table with the example please ?
(Create Table.zip (14.7 KB)
I can make it work with workaround like using the range of the column as the input and not the name of the column (“B2:B21” in place of “[Age]”), but it doesn’t seems right to me if the user is playing with the rows afterwards.
Thanks in advance and have a nice day