Logging

From XLCubed v10.0.150 it has become possible to capture logs from XLCubed activity.

The logs for Excel and Web are configured using a JSON file called appsettings.json.

• For the web this is deployed by default and will log to a file in the Logs sub-directory.
• For Excel this file should be created in the %appsettings%\XLCubed Ltd\XLCubed Excel Edition folder (you can type this address into Explorer to go to the correct folder)

The log configuration can have different output targets which you can configure as shown below. You will have to restart Excel if you change the configuration.

Sample configurations

This will log to the debug output, which you can capture using DebugView a free tool from Microsoft.

{
 "Serilog": {
   "MinimumLevel": "Debug",
   "WriteTo": [
     { "Name": "Debug" }
   ]
 }
}

This will Verbose messages to the debug window and log Error to a file. Note that backslashes in the file path must be doubled.

{
 "Serilog": {
   "MinimumLevel": "Verbose",
   "WriteTo": [
     { "Name": "Debug" } ,
     {
       "Name": "File",
       "Args": {
         "path": "C:\\Path\\To\\Logs\\error.log",
         "rollingInterval": "Day",
         "retainedFileCountLimit": 10,
         "restrictedToMinimumLevel": "Error"
       }
     }
   ]
 }
}