LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Ryanjdeller

Hi there,

I'm attempting to import rows from a specific worksheet from an excel workbook, starting from row 6, and ending when there is no longer any data to read.

I tried to insert the following into the optional tab of the node editor to achieve this but recieved an error:

<workbook>

<sheet index="5" />
<sheet headerRow="6" />
<sheet dataStartRow="7" />

</workbook>

The error reads "2014-04-23 05:50:46.240; ERROR: Sheet (4): "1.Design" in file /data/lavastorm/CALTEX/Raw data/MASTER COST ESTMATE TEMPLATE_For CIA_Padget NTI Mackay Rev 3.xlsx contains a null header row at row index (0)".

"1.Design" is the correct spreadsheet in the workbook, but it seems to be reading the header row at index 0, not 6 as entered in the code above.

Can anyone please assist?


Kind regards,

Ryan.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Hi,

Each <sheet> tag tells the node to process another Excel worksheet from the file.
If you want the index, headerRow and dataStartRow to apply to the one sheet, these should all be attributes on the single sheet tag as shown below:

<sheet index="5" headerRow="6" dataStartRow="7" />

Hope this helps,
Tim.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Ryanjdeller

That did the trick.

Thanks Tim!