When reading a spreadsheet into a query you can specify the columns you want to use either by designating a headerRow (usually the first), or providing them separately via columnNames.
But if the number of columns in the data exceeds the number of columns provided, or contained in the header row, then Lucee will ignore the excess data columns, while ACF will throw an error.
To avoid this, excess data columns should be given a default name e.g. column6 so that the data is included without error.
When reading a spreadsheet into a query you can specify the columns you want to use either by designating a
headerRow(usually the first), or providing them separately viacolumnNames.But if the number of columns in the data exceeds the number of columns provided, or contained in the header row, then Lucee will ignore the excess data columns, while ACF will throw an error.
To avoid this, excess data columns should be given a default name e.g.
column6so that the data is included without error.