ST_READ() fetches random column headers instead of actual headers for an EXCEL(XLSX) file

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

Start by running the supplied ST_READ() query against an XLSX file with multiple sheets, selecting the last sheet and using HEADERS=FORCE; compare its column names with the other sheets and with a single-sheet file. The related read_xlsx() behavior is also noted. Done means the last sheet returns its actual headers while existing sheet behavior remains unchanged.

Written by the indexing model from the issue text.