sqlite3.OperationalError: duplicate column name about sqlitebiter HOT 4 CLOSED

@chaffinched
Thank you for your report.
I had fix the problem at the sqlitebiter 0.15.1.
Could you try with this version?

The problem is non-alphanumeric characters are removed while the SQLite conversion.
So, ABCD>8.5 and ABCD<8.5 are considered a duplicate column as ABCD85.
Now, sqlitebiter accepts non-alphanumeric characters.

from sqlitebiter.

Thanks, @thombashi that works perfectly for the 0.15.1 .deb file.

Unfortunately, the problem still exists in the Windows version, now that #52 is fixed.

sqlitebiter.exe file Book1.xlsx
[INFO] sqlitebiter file: convert 'Book1.xlsx' to 'Sheet1' table
Traceback (most recent call last):
File "site-packages\simplesqlite\core.py", line 259, in execute_query
sqlite3.OperationalError: duplicate column name: ABCD85
During handling of the above exception, another exception occurred:
Traceback (most recent call last):
File "cli.py", line 15, in
File "site-packages\click\core.py", line 722, in call
File "site-packages\click\core.py", line 697, in main
File "site-packages\click\core.py", line 1066, in invoke
File "site-packages\click\core.py", line 895, in invoke
File "site-packages\click\core.py", line 535, in invoke
File "site-packages\click\decorators.py", line 17, in new_func
File "sqlitebiter\sqlitebiter.py", line 230, in file
File "sqlitebiter_table_creator.py", line 22, in create
File "site-packages\simplesqlite\core.py", line 1185, in create_table_from_tabledata
File "site-packages\simplesqlite\core.py", line 1487, in __create_table_from_tabledata
File "site-packages\simplesqlite\core.py", line 1093, in create_table
File "site-packages\simplesqlite\core.py", line 270, in execute_query
simplesqlite.error.OperationalError
[13116] Failed to execute script cli

from sqlitebiter.

@chaffinched
Sorry to bother you.
I had rebuild the Windows executable binary.
I believe this binary fixed the issue.

sha256 hash: cd1e05148360c7f357e5c8be5dec01f6ad2fc34ab4fa639a2541c6494866ea69

from sqlitebiter.

@thombashi
Great, this works perfectly now! Thanks for all of your help.

from sqlitebiter.