• Using the CSD Python API with Excel

    Love it or hate it, Excel is extensively used in industrial settings. Often folk like to use Excel to analyse the results of their work generated from some script or workflow.  The usual workflow is to dump out a CSV file and load this into Excel, but sometimes this is somewhat inefficient. (How many times have you dumped a CSV file, loaded it, re-filtered it etc. etc. only then to discover that maybe the output needs one extra field you should have added, so you end up repeating the analysis run with a small script change and then going through all the steps on loading the Excel file again. If you end up doing this a lot, it gets inefficient!).

    Continue reading…