Excel Configuration

Sample Configuration

The sample configuration below is also available in the [GHOSTS GitHub repository](https://github.com/cmu-sei/GHOSTS/blob/master/src/Ghosts.Client/Sample%20Timelines/clicks

{
    "TimeLineHandlers": [
      {
        "HandlerType": "Excel",
        "Initial": "",
        "UtcTimeOn": "00:00:00",
        "UtcTimeOff": "24:00:00",
        "HandlerArgs": {
          "workingset": {
            "max": 20,
            "max-age-in-hours": 72
          }
        },
        "Loop": true,
        "TimeLineEvents": [
          {
            "Command": "create",
            "CommandArgs": [ "%homedrive%%homepath%\\Documents", "pdf", "pdf-vary-filenames", "save-array:['c:\\tmp','c:\\tmp\\path2','c:\\tmp\\path3']" ],
            "DelayAfter": 900000,
            "DelayBefore": 0
          }
        ]
      }
    ]
}

Some of the key-value pairs are self-explanatory, but let's review a few important ones:

Key	Value
workingset	For the documents Excel creates, how many should we create (max) and how old can they be before we start creating new ones (max-age-in-hours).
Command	(create) Create new documents. This is currently the only setting, but there is space for new commands to be built in the future
CommandArgs	See below

For CommandArgs, we began with positional arguments, but this quickly became unwieldy. We are now using named arguments, which are easier to read and maintain, but the mix remains for now. The following arguments are available:

• [0] The path to the folder where the documents should be created. (old style)
• [1] Also periodically export documents as PDFs as well as saving them natively. (middle style)
• [2] if creating PDFs, vary their name from the original document. (new style)
• [3] Randomly save documents in an array of locations. (new style)