I keep getting an error when the Excel Query component tries to read in an xlsx file. The xlsx file I downloaded has one sheet with sheet name "Summary", which I have set as the value in the Data Source field. When the I try to read in the file, though, I get this error:
Has anyone run into this problem? I’m wondering if Excel’s Protected View could be a factor.
Thanks!
Hunter
Hi Hunter, the first thing that comes to mind that may help understand the issue would be to turn on Auto Debug and set the level at 5. This might give you more detail in understanding what it things the issue is.
What suspect is happening though is that your Data Selection consists of some cells that are not null but rather empty strings. These could perhaps be present at the beginning of the data selection. Using Excel as a data source has always had these type of challenges because it allows people to put bad data into the Excel workbook without really knowing they are doing it. I always lean towards exporting to CSV as it will usually take care of most of these type of issues.
I hope this helps in some way!
