No one has heard of this?
Here is a section of code you can use to get the same results:
using Syncfusion.XlsIO;
//...
public void WriteToExcel()
{
//Instantiate the spreadsheet creation engine.
ExcelEngine excelEngine = new ExcelEngine();
//Instantiate the excel application object.
IApplication application = excelEngine.Excel;
//A new workbook is created.[Equivalent to creating a new workbook in MS Excel]
//The creation of a new workbook in the excel file
IWorkbook workbook = application.Workbooks.Create(1);
//The first worksheet object in the worksheets collection is accessed.
IWorksheet sheet = workbook.Worksheets[0];
//Select a range and would expect to make the back color LightGreen
IRange range = sheet["A1:A6"];
range.CellStyle.Color = Color.LightGreen;
//Saving the workbook to disk.
workbook.SaveAs(@"C:\test.xls");
//Close the workbook.
workbook.Close();
//No exception will be thrown if there are unsaved workbooks.
excelEngine.ThrowNotSavedOnDestroy = false;
excelEngine.Dispose();
}
This will create the attached file. Which you'll notice does not have light green as the fill color for A1 to A6.
test_79e1ad09.zip
