Every month I have a file that is automatically generated by another department and saved to a shared drive as an .xlsx file. The problem is the top few lines of the file are loginfo such as file title, ID, run time etc., but causes an issue with importing into IDEA since the first row is not the data header row. More specifically, the header starts on row 4, with information on rows 5+
I thought of writing a script to delete the top lines but our goal is to not alter the original data. I could copy info over to a new workbook and modify/import but thought I would put this out there to see if anyone has had any similar challenges or best solutions? I could have the other department modify their output file, but would rather work with what I have first.
Thanks!Mark
mponter
Offline
Last seen: 3 years 11 months ago
Joined: 07/14/2015 - 10:53
Hi Mark,
Could you bring it in and then do an extract of everything but the first four rows such as @Recno() > 4? This way all the original data is in.
Brian
Another option is to save the Excel file as a csv. Then use the text import feature to import the delimited file. Let's say your field names start on row five. You would input 4 in the header lines to ignore and check the first visible row is field names box to pickup the field names from row five.