Bug With Cell Fill Color

[jkerb135]

Im trying to format the color of a cell to the following RGB.

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,

[amy.zhao]

Hi,

Thanks for your posting and using our Spire.Xls.
Please set version of workbook to Version2007 and above version.

Code: Select all

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");


Best Regards,
Amy
E-iceblue support team

[amy.zhao]

Hi,

Have you tried above solution? Did it resolve your issue?
Thanks for your feedback.

Best Regards,
Amy
E-iceblue support team

[jkerb135]

Hi,

Have you tried above solution? Did it resolve your issue?
Thanks for your feedback.

Best Regards,
Amy
E-iceblue support team

Yes this has resolved my issue.
I had the enum value in the

Code: Select all

worksheet.SaveToStream("filename.xlsx", ExcelVersion.Version2013);

when I added it to the worksheet as an initialization parameter it gave me the correct results.

Thank you,

[amy.zhao]

Hi,

Thanks for your feedback.
Welcome to write to us again if you have further problems.

Best Regards,
Amy
E-iceblue support team

[ipproo111]

hi i am using xls i am trying to change specific cell's color . But i dont know how i am sending my code .
sheet.insertArray(oneDimensionalArray, 1, 1, true);



//Define a two-dimensional array

String[][] twoDimensionalArra = new String[][]{

{"Name", "Age", "Sex", "Dept."},

{"John", "25", "Male", "Development"},

{"Albert", "24", "Transgender", "Support"},

{"Amy", "26", "Female", "Sales"}

};



//Write the array to the worksheet from the specified cell

sheet.insertArray(sonuc, 1, 3);


sheet.getAllocatedRange().getStyle().setColor(Color.green);


//sheet.getCellRange("A1:E1").getStyle().setColor(Color.yellow);




//Save the file

wb.saveToFile("InsertArrays.xlsx", ExcelVersion.Version2016);

how can i change cell color of transgender to yellow for example . am i allowed to do that ?

[ipproo111]

String[][] twoDimensionalArra = new String[][]{

{"Name", "Age", "Sex", "Dept."},

{"John", "25", "Male", "Development"},

{"Albert", "24", "Male", "Support"},

{"Amy", "26", "Female", "Sales"}

};
i made this multidimensional array and i can send to excel this array . but i cannot color cells . i mean i want to color john as blue and support as a yellow am i allowed to do that ?

[Annika.Zhou]

Hello,

Thank you for your inquiry. Of course, our Spire.XLS could fulfill your requirement. Please refer to the following code. If there is any question, please feel free to write back.

Code: Select all

        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);

Sincerely,
Annika
E-iceblue support team

[Annika.Zhou]

Hello,

Greetings from e-iceblue.
How is your issue going? Does the code we provide help you? Can you give us some feedback at your convenience? Thanks in advance.

Sincerely,
Annika
E-iceblue support team