I have thousand of Excel files I need to read but all of them have different starting attributes line. Sometimes line 15 or 16 or 17.
(not me who developed that method of working….)
The attributes are all the same for all the files.
Any idea how I could have the Excel Reader to detect the starting line?
Thanks !
Best answer by redgeographics
Are the attribute names always the same? If that’s the case you can read the file once with the regular reader and check lines 15, 16 and 17 with a TestFilter to see if any of them hold the attribute names, then pass them to different FeatureReaders where you’ve set the correct line number for the attribute names.
Are the attribute names always the same? If that’s the case you can read the file once with the regular reader and check lines 15, 16 and 17 with a TestFilter to see if any of them hold the attribute names, then pass them to different FeatureReaders where you’ve set the correct line number for the attribute names.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.