readExcel: stringColumns argument fails to match columns that are automatically renamed due to duplication.

[chimission]

Library Version: 1.0.0-Beta4

When reading an Excel file (.xlsx) that contains duplicate column names (e.g., two columns named "label"), the readExcel function automatically renames the duplicates (e.g., label and label1) to ensure uniqueness.

I found that stringColumns is ineffective for renamed duplicates.

Inputting the original name (label) only affects the first instance.

Inputting the inferred renamed name (label_1) is ignored by the loader.

This leaves no declarative way to handle duplicate columns as strings during the initial load phase.

[koperagen]

Hi! Thank you for the report. Could you please try with Excel column indexes, like StringColumns("A,B,C:E")?

Inputting the original name (label) only affects the first instance.

For now this argument is not supposed to work with column names as seen by dataframe (table header, first row of values). But looks like it makes sense to accept both indexes and labels in this argument

[chimission]

Hi! Thank you for the report. Could you please try with Excel column indexes, like StringColumns("A,B,C:E")?您好！感谢您的报告。请问您能否尝试使用 Excel 列索引，例如 StringColumns("A,B,C:E") ？

> Inputting the original name (label) only affects the first instance.

For now this argument is not supposed to work with column names as seen by dataframe (table header, first row of values). But looks like it makes sense to accept both indexes and labels in this argument

This method also solves my problem. Thanks.

[zaleslaw]

Probably could be converted to a feature request, if we collect more feedback and user pains