Add an option to determine the format of the columns while writing the google sheet from json file.
{
"pName": "param1",
"pDesc": "",
"pref": "",
"pVal": 0.00001,
"pMinValue": 0.0000903,
"pMaxValue": "",
"pIsDeprecated": "False"
},
{
"pName": "param2",
"pDesc": "",
"pref": "",
"pVal": 1e-15,
"pMinValue": 1e-15,
"pMaxValue": "",
"pIsDeprecated": "False"
}
]
gives us:
pName | pDesc | pref | pVal | pMinValue | pMaxValue | pIsDeprecated
-- | -- | -- | -- | -- | -- | --
param1 | | | 0.00001 | 0.0000903 | | FALSE
param2 | | | 0 | 0 | | FALSE
and we want to determine the format of the table (or for pVal, pMinValue and pMaxValue column) to be "Scientific format" instead of "Automatic format":
pName | pDesc | pref | pVal | pMinValue | pMaxValue | pIsDeprecated
-- | -- | -- | -- | -- | -- | --
param1 | | | 1.00E-05 | 9.03E-05 | | FALSE
param2 | | | 1.00E-15 | 1.00E-15 | | FALSE
Add an option to determine the format of the columns while writing the google sheet from json file.
An example: