private void CreateFormat(COBieAllowedType type, string formatString, string colourName)
        {
            HSSFCellStyle cellStyle;

            cellStyle = XlsWorkbook.CreateCellStyle() as HSSFCellStyle;

            HSSFDataFormat dataFormat = XlsWorkbook.CreateDataFormat() as HSSFDataFormat;

            cellStyle.DataFormat = dataFormat.GetFormat(formatString);

            cellStyle.FillForegroundColor = _colours[colourName].Indexed;
            cellStyle.FillPattern         = FillPattern.SolidForeground;

            cellStyle.BorderBottom = BorderStyle.Thin;
            cellStyle.BorderLeft   = BorderStyle.Thin;
            cellStyle.BorderRight  = BorderStyle.Thin;
            cellStyle.BorderTop    = BorderStyle.Thin;

            // TODO:maybe clone from the template?
            _cellStyles.Add(type, cellStyle);
        }
        private void CreateFormat(COBieAllowedType type, string formatString, string colourName)
        {
            var cellStyle  = XlsWorkbook.CreateCellStyle() as HSSFCellStyle;
            var dataFormat = XlsWorkbook.CreateDataFormat() as HSSFDataFormat;

            if (cellStyle == null || dataFormat == null)
            {
                Log.LogWarning("Error producing Excel cell style or format in workbook.");
                return;
            }

            cellStyle.DataFormat = dataFormat.GetFormat(formatString);

            cellStyle.FillForegroundColor = _colours[colourName].Indexed;
            cellStyle.FillPattern         = FillPattern.SolidForeground;

            cellStyle.BorderBottom = BorderStyle.Thin;
            cellStyle.BorderLeft   = BorderStyle.Thin;
            cellStyle.BorderRight  = BorderStyle.Thin;
            cellStyle.BorderTop    = BorderStyle.Thin;

            // TODO:maybe clone from the template?
            _cellStyles.Add(type, cellStyle);
        }