Change Font Size and Style by using ExcelPackage

Topics: Developer Forum, Project Management Forum, User Forum
Oct 13, 2010 at 8: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 6:32 AM

Anyone answer this question??..

Apr 13, 2012 at 4:29 PM
Edited Apr 13, 2012 at 4: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 4:42 PM

Hi

 

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

 

Benbak

Jul 2, 2012 at 8:52 AM

Hi

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

Can someone help ?

 

Thanks