XLR8 Toolkit - Can you read sheets by column header vs Row / Column or by Address, i.e. A1:C1

[TeraTech]

I am considering purchasing the XLR8 Toolkit.  Your feature description says address cells via row / column or by address, i.e. A1:C1. I am concerned about "future proofing" the reading of an XLS file and so I don't want to rely on column positions.   Is there a way to locate a column by its header rather than by row/column or cell number?

[JensG69]

I am not exactly sure what you want to achieve: You could:

• Read in the first row of your excel sheet, parse the string headers for your desired header string and hence determine the column that you are interested in. OR
• Use Named Ranges within you excel sheet.

Both options can be achieved by using XLR8.

Regards,

DATA AHEAD

[TeraTech]

Thanks for the reply. I should have been more explicit. In case someone alters the spreadsheet and inserts a column, searching by the header would not "break" the existing LV code as searching by specific column number.  Yes, the algorithm to do this is simple. I was wondering though if there was a built in function to do so. Evidently not.  Perhaps a future version then :