So where are your headers, if A1 contains a timestamp? Can you configure the Excel source to skip the column/row?

Hi Steve
I am using batch append (else I could do that) as we get a new file each week and we want to read them all in.
Regards
Neil

You should be able to change the Batch Append file type filter to XLS/XLSX files, thereby revealing the Excel specific options for skipping rows/columns - does this work?

Hi Steve
You don't have the "select table data" option in batch append when xlsx or xls is slected in batch append - only row options - I need row 1 as the headers are in row 1.
Regards
Neil

If A1 contains a timestamp, not headers, then your headers aren't in row 1, they're in row 2. Unless you're counting from zero (which Omniscope doesn't)?
Assuming your timestamp is in row 1, your headers are in row 2, and your data is in rows 3 onwards, you should be able to enter:
Has header: [tick]
Header rows: [2] to [2]
Data rows: [3] to [blank]
These options should be available for batch append, instead of the "Select table data" option you're used to for individual files.

If I've misunderstood, post a sample file here which shows your rows/headers structure.

Hi Steve
Please see attached.
The headers are in row 1, but A is all useless data so we need to drop it.
N

Since column A isn't blank apart from the timestamp header, you can't use "Delete empty data" to exclude blank columns.

Your best bet then is probably to exclude the headers altogether using the "has header" and "data rows" options, and to use Field Organiser to manually set all headers.

This will only work if all batch-appended files have the same structure.

Here's my next problem... there are 330 columns of data... I can't remap them all!

You could try importing without headers and without parsing numbers/dates, where the first (header) row is treated as a data row, then using search/replace or formulas to nuke the timestamp, then writing back out as a temporary CSV file using the same "no headers" option. Then read THAT using a separate file block.