I have an excel file that I'm trying to process, but the data I need starts in cell A4. Using the FTP/CSV combinaton, I'd be able to skip those lines but I don't have the same ability using an Excel workbook.
I tried using the Pre-Parse to remove those lines, but that's not available for XLSX (will it be any time soon?).
What are some other options that I could use short of modifying the file? I've attached a sanitized sample for assistance.
PRE-ADVICE - Sanitized Example.xlsx (3.9 KB)
@jackharris We don't have plans to support pre-parse for XLSX. Pre-parse operates on the raw string data of a file, and since XLSX is a binary format rather than plain text, there's no meaningful string for the pre-parse hook to work on.
The most reliable path is to convert the XLSX to CSV first, upstream even before the file lands on the FTP server, and then use a pre-parse script to drop the leading rows the way you already do with your FTP/CSV setup.
When we downloaded the attached sample, we weren't able to parse it into a CSV. Our XLSX parsing relies on the <workbook> and <sheet> tags in the file's underlying XML, and those weren't in the expected form, so the parser couldn't read the sheet.
If the file has the correct tags, you can set up a flow to convert the incoming XLSX to CSV, and then another flow to read the CSV file and use a pre-parse script to strip the extra rows before processing.