LAE

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

Originally posted by: sgiasemi

Dear All,

How can brain read specific columns and rows from an Excel?
I am using the experimental node but I want to read only a specific part of the excel file.

Thank you.
Sonia

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

Originally posted by: rboccuzzi

There is a WorkbookSpec parameter that configures what you would read in, which row to start gathering data (dataStartRow), which workbook tab to read. You really can't configure an end of data row. Additionally, you can specify the fields using the header row tag (headerRow), or the field specifiers.

I would suggest however, that the best general way to handle this is to pull all the data into the LAE, and then use a filter node after to drop records and fields that are not desired, using BRAINscript.

Cheers
Rich

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

Originally posted by: Tim Meagher

Update:

In 4.5.2 the Excel File node has become an officially supported node and is no longer experimental.

One of the enhancements for the 4.5.2 release was to add the dataEndRow attribute in the WorkbookSpec parameter on the Excel File node.

This means that you are able to use the dataStartRow & dataEndRow to limit the rows that are retrieved by the node.

As Rich stated, you can't specifically chose the columns, however you can use the headerRow attribute or field specifiers to guide the restrictions on the columns that are retrieved.

I have added an enhancement request such that you can also explicitly specify the start and end columns in a similar manner to the row specifications.

Tim.