I realize that the ColorIndex is no longer needed in Excel 2007 and later. However it is still available in Excel (can be set in VBA, or through Interops). We have old macros and add-ins which rely on specific ColorIndex attributes in cells. The macros/add-ins can not be modified at this point so we don't have the option of moving away from their use.
var xls = new XlsFile(1, true); var fmt = xls.GetCellVisibleFormatDef(1, 1); fmt.FillPattern.Pattern = TFlxPatternStyle.Solid; fmt.FillPattern.FgColor = TExcelColor.FromIndex(27); xls.SetCellFormat(1, 1, xls.AddFormat(fmt));
Sent you an email on Friday. I was wondering if there was any information on my question?
Just a quick follow up. I was able to do what I needed with the ColorIndex. This allowed me to replace the code using Excel as an Automation server to create the spreadsheets we need.