Hello,
I'm trying to read an .xlsx stored in a shared network drive (not on OneDrive, SharePoint, local folder, etc.).
I am able to read it if the file is stored in OneDrive by using the Excel Online (Business) connection and the 'List rows present in a table' step. This allows me to read the columns and rows without a problem:
However, the file needs to be stored in a network drive and the 'Location' and 'Document Library' parameters above don't seem like they can navigate to the network drive. What values should I put there?
Alternatively, I am able to read the excel file from a network drive using the a File System connection and a 'Get file content using path' step:
However, this returns the following:
Can I convert the content to usable rows, columns, values?
In summary, how do you read an excel file stored in a network drive?
Thanks
