Forum Discussion
Excel.Workbook failure
Hi
I have a query that contacts few excel files. The first step is Excel.Workbook(File.Contant(file path))
the secont step is to navigate to the column "Data" where Item = "Financial " and Kind = "Table". (the name of the table is Financial) .
it worked petfect and works for most of the files.
But for one file, the File.content returns only two columns with Name and Data. as a result, the next step failed.
What causes it and how to fix it?
Thank you.
4 Replies
Reuven83 Are there perhaps some hidden columns in that one file that might be messing things up? Would really have to share the files in question to see what the difference might be.
And what is the content of the two columns? What is the structure of the errant workbook?
can you share the file or the steps on your query?
