The Table Extraction wizard is not behaving as expected compared to the documentation. The option for a header row is not presented so I have to edit the column names using Edit Extract Data. When I preview the data some of the header row appears as the first row of data, as expected, but for some columns this row is blank. Also, the Next Button is always greyed -out so I am not capturing all the rows.
is the excel file online? if not use the readrange activity this will read your excel into a datatable where you can get all the data from it.
You don’t use table extraction to get data from Excel. You use the various Excel activities to read the data.
What Next button? Excel doesn’t have Next buttons.
What are you trying to do? Give us details on your goals so we can help you.
Akash_Javalekar1
Yoichi
ashokkarale
arun.v7
Jon_Smith
rashmisingh2695
ppr
jast1631
pere
Dheerendra_vishwakarma