This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email email@example.com for assistance.
It would be really helpful to have the ability to read in a Header from an Excel file as part of the Excel file. I am not referring to column names but the actual Header on the file as this can contain important info to be appended to the data. This could be an additional checkbox in the Input tool for excel files to read in the header and append to the data as a field.
Currently, a workaround process to do this is to make a copy of the xlsx file and rename as file.zip. Then unzip the xlsx file and open the sheets as xml files where the headerFooter child element is read in. Then the header info is appended to the Excel data file which is read in separately in another input tool.
Would be much more efficient if this was simply a checkbox in the Input Data interface and the Header read in with the data.