Write booleans to cells
14 views
Skip to first unread message
S. B.
Jan 9, 2016, 5:07:08 AM1/9/16
to Spreadsheet::WriteExcel
I did not find, in the documentation of the source code, a way to write booleans to cells.
Booleans show up as "TRUE" or "FALSE" in Excel -- depending on the language, it is "VRAI" or "FAUX" in French for example -- but are stored as a 0/1 value in the <c> XML element on the worksheet.xml
If I believe the source code of the Python XLSX library and the observation of existing Excel files, this is accomplished with the t="b" XML attribute in the <c> XML element: <c t="b">0</c> <c t="b">1</c>
Booleans show up as "TRUE" or "FALSE" in Excel -- depending on the language, it is "VRAI" or "FAUX" in French for example -- but are stored as a 0/1 value in the <c> XML element on the worksheet.xml
If I believe the source code of the Python XLSX library and the observation of existing Excel files, this is accomplished with the t="b" XML attribute in the <c> XML element: <c t="b">0</c> <c t="b">1</c>
jmcnamara
Jan 9, 2016, 5:52:14 AM1/9/16
to Spreadsheet::WriteExcel
On Saturday, 9 January 2016 10:07:08 UTC, S. B. wrote:
I did not find, in the documentation of the source code, a way to write booleans to cells.
It isn't currently supported, mainly because no-one asked for it.
If you open a feature request/issue on GitHub I'll add it soon.
John.
--
Reply all
Reply to author
Forward
0 new messages