Query:
SELECT * FROM ST_READ("filePath", layer="sheet_no",
open_options=["HEADERS=FORCE"],
allowed_drivers=["XLSX"]
);
The above query fetches random headers like Field 1, Field 2 .... Field n, instead of actual headers but this happens only while choosing the last sheet in the excel file but work for rest sheets in the file this issue happens when a excel file having more than 1 sheet, but works fine for single sheet excel file
Kindly provide fix for this
Note: while trying read_xlsx() number column becomes float/decimal column