Hi, I met a problem that I want the process to fetch the data from excel and write into another new file with “Auto Fill Range” without a particular number of columns and rows, I want it to be dynamical. Hence, I use “Get Table Range” to know the range of the table. However, due to my source excel file was converted from pdf, after I check the info. it seems doesn’t have any table name even default name.
Is there any way can I use except input the table name?
Or other ways to solve my problem.
More clearly, I need to “get table range” so that after I retrieve the old data for formatting and I can write it into a brand new file by using “Auto Fill Range” Activity.