Skip to content

Excel

An Excel file is a type of spreadsheet document that's created using Microsoft Excel, a popular computer program for working with data and numbers. It's kind of like a digital version of those old-school paper spreadsheets, but way more powerful and flexible.

Excel parameters

Required parameters are in red and Optional parameters are in blue.

  • filepath, the file location to write the Excel file to
  • date_time_format, the string representation of date times
    default: %Y-%m-%dT%H:%M:%S.%f ( use the strftime.org cheatsheet as a guide )
  • save_strategy, how to save new data into an existing directory
    default: OVERWRITE ( allowed: APPEND, OVERWRITE )
How do I use the Excel syncer in commands?

cs_tools tools searchable bi-server --syncer excel://filepath=data.xlsx&save_strategy=APPEND

- or -

cs_tools tools searchable bi-server --syncer excel://definition.toml

Definition TOML Example

definition.toml 

[configuration]
filepath = '...'
save_strategy = APPEND