Convert CSV to Excel

Compatibility: BaseSpace Clarity LIMS v3.1.0 or later; NGS Extensions Package v5.4.0 or later

Included as part of the NGS Extensions package, the convertToExcel script is designed to convert separated-value files (eg CSV) to Microsoft Excel spreadsheets of type XLS and XLSX.

The script can be run on comma- and tab-separated files with any file extension. The original file is not edited, unless its name matches the name given for the output file.
The script can update an existing Excel spreadsheet or produce an entirely new one.
When updating an existing Excel spreadsheet, if this spreadsheet does not have a file extension XLSX will be used by default.
A single worksheet is updated with the input file contents. When producing a new Excel spreadsheet, this worksheet name may optionally be specified. Otherwise, The default name will be used.
The worksheet name must be provided when updating an existing Excel spreadsheet. If the worksheet exists, its contents will be overwritten with the contents from the input file. Otherwise, a new worksheet will be added.
Each line in the input file becomes a row in the output file, and its values are placed into the cells of that row. The first value in the input file becomes the value of cell A:1, and so forth.
When updating an existing worksheet, cells that are not overwritten by values from the input file are left untouched. For example, there may be a footer section that is not updated.
The Excel file produced may be written to a location accessible from the LIMS server (a location on the server, a mounted drive, or a shared file store for example) and also attached in the LIMS via quick Attach. If both options are specified, the script will warn if the file cannot be written and report an error if the file cannot be uploaded.
The cell types currently supported are Numeric, Boolean, Blank, and String.
Supported number formats include period (.) as the decimal point and numbers that include an exponential (eg, 1e-8 or 4E2).
Boolean values are case-insensitive.

Macros and equations are not supported when updating an existing Excel file. Other cells in the file that depend on the new values will not be updated when the worksheet is.