Hello:
I am using DB Extractor v 3.4.3 to read columns from an Excel file but it gives me the following error:
2024-08-20 18:53:06.550 UTC [ERROR ] QueryExecutor_0 - Unexpected error in query1: Could not read file C:\Cognite\SAT-SX4 - 2023-03-21.xls: required package 'xlsx2csv' not found.
Please install using the command `pip install xlsx2csv`.
The following is my config file:
databases:
- type: spreadsheet
name: "DSN_FT"
path: "C:\\Cognite\\SAT-SX4 - 2023-03-21.xls"
queries:
-
name: query1
database: "DSN_FT"
sheet: "P_VSD"
query:
#"SELECT STS PreCOM FROM SAT-SX4 - 2023-03-21.xls"
"SELECT * FROM P_VSD"
destination:
type: raw
database: FTV
table: AE_MOLYNOR
primary-key: "{EventID}"
What am I doing wrong? Can you help me?