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)

If you configure logs to be sent to the debug output you can capture them using DebugView a free tool from Microsoft.

You should use the version of the tool that matches the bit-ness of Excel and enable "Capture Win32" from the Capture menu.

The log configuration can have different output targets which you can configure as shown below

Sample configurations

This will log to the debug output, which you can capture using DebugView.

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