nodys / spreadstream Goto Github PK

Add an option to determine the format of the columns while writing the google sheet from json file.

An example:

  {
    "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

Currently, if the source sheet does not exist, spreadstream gracefully degrade to an empty stream. This may be confusing.

If the source sheet (either the document or the sheet) does not exists, spreadstream should throw an error (and the graceful behaviour may be provided by a --graceful option)

Hi, thanks for this great package!

I stumbled over this issue while deploying an app on Heroku (pify was pruned from the dependencies, causing require('spreadstream') to throw an error).

What do you think about updating the googleapis and google-auth-library dependencies to their current versions? I can submit a PR if that makes sense. The unit tests run fine after updating them, for what it's worth.

googleapis is quite a few major releases ahead by now though, so you may want to examine the changelog to see if there are breaking changes that might affect spreadstream.