Excel Cell Styles


A few people have asked for style in Excel Cells and nobody have really come up with a solution so I have done some work to get it done. I have unfortunately not been able to complete it because of a lack of time, but I have decided to post it here for the people interested.
Thusfar, Fills, borders and fonts can be added to some extent. At this stage I only make use of arg colours because of the complexity involved to add support for the other options available.
Have a look at what I have done and see if you can use it and/or help me complete it.
Feel free to contact me should you have questions/suggestions...

file attachments


phyoe2004 wrote Oct 13, 2010 at 11:16 AM

Hello Marais,

Thanks for your sample files. But I still cannot manage to run your application. Because when I tried to generate a file I face this error "Method not found: 'OfficeOpenXml.ExcelStyles OfficeOpenXml.ExcelWorkbook.get_Styles()'.". Can you please complete it and upload it or let me know it? Cause I also would like to use yours.

Thanks & Regards,

wrote Oct 13, 2010 at 11:28 AM

phyoe2004 wrote Oct 13, 2010 at 11:28 AM

Hello Marais,

When I tried to debug on more deep, I face this error "Object reference not set to an instance of an object." When he tried to save the ExcelWorkBook. Please give me an idea to continue. I attached error page.

wrote Nov 5, 2010 at 3:16 PM

wrote Apr 8, 2011 at 11:26 PM

wrote Feb 22, 2013 at 12:31 AM

sola_mhb wrote Dec 4, 2013 at 10:13 PM

Hello Marais,

Are you still working on this?