Empty value format
Value exported for empty cells.
Null will export empty cells with a standard JSON null value while Empty String will export an empty string "".
Example:
Sheet name: Directors
| Name | Skill |
|---|---|
| George | Creation |
| JJ |
Null Output:
{
"Directors" : {
"George" : {
"Name" : "George",
"Skill" : "Creation"
},
"JJ" : {
"Name" : "JJ",
"Skill" : null
}
}
}
Empty String Output:
{
"Directors" : {
"George" : {
"Name" : "George",
"Skill" : "Creation"
},
"JJ" : {
"Name" : "JJ",
"Skill" : ""
}
}
}