I have many number of excel files i have to add a field i. fieldlist in all of these files dynamically in loop.how can i do that??.
I have tried this by the following code in script.And i want to capture field not found error in the other table how can i achieve this.please help me anybody. Here i am attaching my code which i have written for this please have a look on it.
FOR Each File in FileList('C:\Users\vasudha\Documents\TestExce\*.xlsx')
' ' as FieldList
(ooxml, embedded labels, table is Sheet$(i));
* Inline [
if ScriptError = 11 then
fName& '|' &SheetNumber& '|' &FieldList as FieldKey;
FileName() as fName,
$(i) as SheetNumber,
'$(File)' as FilePath
(ooxml, embedded labels, table is Sheet$(i), filters(Transpose()));
I have tried your above solution.But its not giving me all numbers of fields in the table let say i have 5 fields in my table it is skiping first field in the MyFieldName column.How can i have all the column names.Please let me know.
CrossTable (MyFieldName, MyFieldValue)
(ooxml, embedded labels, header is 5 lines, table is [Output Tracker]);
in the above example it is skiping first field i.e Field1 in MyFieldName column.