Change excel text font style

[nkeung]

Hi Support,

I am trying to change all text to italic but it is not working.
Please help

Here is my code:

Code: Select all

excel.LoadFromStream(stream, Spire.Xls.ExcelVersion.Version2007);

                            foreach (Worksheet ws in excel.Worksheets)
                            {
                                foreach (CellRange cr in ws.Cells)
                                {
                                    cr.Style.Font.IsItalic = true;
                                }
                            }

[Jane.Bai]

Hi,

Thank you for your inquiry.
After an initial test with the latest hotfix Spire.Office (DLL Only) Version:3.12.4, I could get the correct result.
Below is my testing code and attache is the result file.

Code: Select all

 string input = @"D:\test\excel.xls";
 MemoryStream inputMs = new MemoryStream(File.ReadAllBytes(input));
 Workbook excel = new Workbook();
 excel.LoadFromStream(inputMs, Spire.Xls.ExcelVersion.Version97to2003);

 foreach (Worksheet ws in excel.Worksheets)
 {
     foreach (CellRange cr in ws.Cells)
     {
         cr.Style.Font.IsItalic = true;
     }
 }
 excel.SaveToFile("italic.xls",ExcelVersion.Version97to2003);

If the issue still exists after using the latest hotfix, please write back and share the result file on your end.
Sincerely,
Jane
E-iceblue support team

[nkeung]

Jane.

Thanks. It works now.

Regards,
Kevin

[Jane.Bai]

Hi Kevin,

Glad to hear that!
Feel free to contact us if you need any assistance in the future!

Sincerely,
Jane
E-iceblue support team