Change Font Size and Style by using ExcelPackage

Topics: Developer Forum, Project Management Forum, User Forum
Oct 13, 2010 at 9:22 AM

Hi Everybody,

I can successfully generate the excel 2007 file by using OfficeOpenXML.ExcelPackage.ExcelWorkSheet. But When I check the properties, I don't see to change font size and style (bold/Italic). Please let me know how to change it by using about object.


Thanks & Regards,

Jun 1, 2011 at 7:32 AM

Anyone answer this question??..

Apr 13, 2012 at 5:29 PM
Edited Apr 13, 2012 at 5:30 PM

You can set  the cell style as follows:


worksheet.Cells["A1"].Style.Fill.PatternType= OfficeOpenXml.Style.ExcelFillStyle.Solid;

worksheet.Cells"A1"].Style.Font.Bold = true;
worksheet.Cells["A1"].Style.Font.Italic = true;
worksheet.Cells["A1"].Style.Font.Size = 11;

Jun 26, 2012 at 5:42 PM



would you please tell me how do you get Cells property on your worksheet. I only have Worksheet.Cell and not Worksheet.Cells


Please let me know as soon as you can


Thank you



Jul 2, 2012 at 9:52 AM


Even I'm not able to get Cells Property on worksheet. I only have Worksheet.Cell and not Worksheet.Cells.

Can someone help ?