Add COLNAMES option to give names to the columns

x2bool / xlite

Query Excel spredsheets (.xlsx, .xls, .ods) using SQLite

MIT License

1.25k stars 47 forks source link

Add COLNAMES option to give names to the columns #11

Closed roblabla closed 1 year ago

roblabla commented 1 year ago

The COLNAMES option should contain the row number giving the name to the columns. This name will be used in place of the lettered column name used by excel in the SQL Table.

roblabla commented 1 year ago

While adding the tests, I fixed COLNAMES using 0-based indexing instead of 1-indexing, which made its usage next to the RANGE keyword very weird. See https://github.com/x2bool/xlite/pull/11/files#diff-6fad74dbaa3be1cb394546cf648fb13695503f28e12e6f06fb3406b922e5a246R106

x2bool commented 1 year ago

Good feature! Thank you for your work 😊