Reading Cell value contains 'FALSE' is converted to '0'

[sankar228]

Hi,

i was trying to use github.com/xuri/excelize/v2 for reading xlsx and convert them to csv. it is working fine for most of my cases.
except for the cell values contain 'FALSE' converted to '0' by excelize instead of treating it as a string value. would you suggest me on this.
below is the code snippet.

//i have tried with out excelize Options, but the behavior did not change
efile, err := excelize.OpenFile(excelFile, excelize.Options{
RawCellValue: true,
})
rows, err := efile.GetRows(sheetName)

for _, row := range rows {
// logic to read field values and write them to csv file
}

Thanks,
Sankar

[xuri]

Thanks for your feedback, could you provide more details and spreadsheet attachments without confidential info?

[sankar228]

Thank you for the quick response!!

please find the attached spreadsheet with some sample data.
column "c5" is considered as string, other column values are treated as bool by default.

test.xlsx
.

[xuri]

I have fixed this issue on commit 56aa6b8, please try to upgrade master branch code, and this patch will be released on the next version.

[sankar228]

Thank you !!

fix is working !!