- Code: Select all
cell.Style.Color = (Color.FromArgb(51, 155, 204))
The wrong color is being applied to the cell inside the document. The cell fill color in the excel document is RGB (51, 155, 155)
Any help on this issue would be appreciated
Thanks,
cell.Style.Color = (Color.FromArgb(51, 155, 204))
Workbook workbook = new Workbook();
workbook.Version = ExcelVersion.Version2007;//or above Version
Worksheet sheet = workbook.Worksheets[0];
CellRange cell = sheet.Range["A1"];
cell.Style.Color = (Color.FromArgb(51, 155, 204));
workbook.SaveToFile("result.xlsx");
amy.zhao wrote:Hi,
Have you tried above solution? Did it resolve your issue?
Thanks for your feedback.
Best Regards,
Amy
E-iceblue support team
worksheet.SaveToStream("filename.xlsx", ExcelVersion.Version2013);
Workbook workbook = new Workbook();
Worksheet sheet = workbook.getWorksheets().get(0);
String[][] twoDimensionalArra = new String[][]{
{"Name","Age","Sex","Dept."},
{"John","25","Male","Development"},
{"Albert","24","Transgender","Support"},
{"Amy","26","Female","Sales"}
};
sheet.insertArray(twoDimensionalArra,1,3);
for (int i = sheet.getFirstRow(); i <= sheet.getLastRow(); i ++){
for (int j = sheet.getFirstColumn(); j <= sheet.getLastColumn(); j ++){
CellRange range = sheet.getRange().get(i,j);
if (range.getValue().equals("John")){
range.getStyle().setColor(Color.BLUE);
}
if (range.getValue().equals("Support")){
range.getStyle().setColor(Color.YELLOW);
}
}
}
workbook.saveToFile("insertArrays.xlsx", ExcelVersion.Version2016);