Create a formatted Excel file

Create a formatted Excel file

  
Hi there!

I need to export a big amount of data to an Excel file, but I need to format the cells color and width. Maybe merge cells as well. The simple export from a record list to Excel does not give that possibility, am I right?
How can I do that?

Thanks.
Hugo Laibaças
Direcção-Geral do Orçamento.
Hi Hugo,

You need to create an extension to accomplish this.
Take a look at the following library for excel 2003 format
 

http://npoi.codeplex.com/

 

http://www.leniel.net/2009/07/creating-excel-spreadsheets-xls-xlsx-c.html (sample)

For excel 2007 format take a look at 

 

http://epplus.codeplex.com/

http://excelpackage.codeplex.com/

Don't use the Excel interop because Microsoft doesn't support this
http://support.microsoft.com/kb/257757

regards

stephan schevers

 


 


Hi Stephan,

I think you're right. Create an extension might be the solution for me.
I'll take a look.
Thanks.

Regards,
Hugo Laibaças
Hugo, 

do a quick search in the community and you'll find the solution around here.

Cheers, 
RNA
Hi Hugo,

Check if this topic helps.

Regards,

Paulo Tavares