ASP.NET

Write excel using excel package with formatting RSS

4 replies

Last post Aug 23, 2012 01:53 PM by abiruban

‹ Previous Thread|Next Thread ›

- Reply
Lajja

Member

18 Points

16 Posts

Write excel using excel package with formatting

Aug 23, 2012 11:24 AM|LINK

I want to write excel file using excel package from System.Data.DataTable

and need to format some cells in excel file like back ground color.

I dont want to use Interop.

How can I do that?
- Reply
kaushik_tatv...

Contributor

2808 Points

500 Posts

Re: Write excel using excel package with formatting

Aug 23, 2012 11:41 AM|LINK

If you dod not want to use interop then you can use any expertXLS and some other third party dll. but all other dll are chargeable.

MARK AS ANSWER IF THIS WORKS...

Mark Answered if it helps - Good luck!
Cheers!
- Kaushik Patel
- Marked as answer by Mark - MSFT on Aug 28, 2012 02:29 PM
- Reply
Lajja

Member

18 Points

16 Posts

Re: Write excel using excel package with formatting

Aug 23, 2012 12:11 PM|LINK

can you give me any example code ? and I found that .dll is chargeable
- Reply
kaushik_tatv...

Contributor

2808 Points

500 Posts

Re: Write excel using excel package with formatting

Aug 23, 2012 12:24 PM|LINK

I could not provide my code here......but i used following three dll - ExpertXLS, MYXLS and Aspose.

I would like to prefer ASPOSE dll and you can easily find code on net for this...

MARK AS ANSWER...

Mark Answered if it helps - Good luck!
Cheers!
- Kaushik Patel
- Edited by kaushik_tatva on Aug 23, 2012 12:26 PM
- Reply
abiruban

All-Star

16048 Points

2734 Posts

Re: Write excel using excel package with formatting

Aug 23, 2012 01:53 PM|LINK

HI,

http://excelpackage.codeplex.com/

http://steveorr.net/Articles/ExcelExport.aspx

thanks...

Please excuse my poor/bad English
***DON'T FORGET TO CLICK “MARK AS ANSWER” ON THE POST IF HELPED YOU.
- Marked as answer by Mark - MSFT on Aug 28, 2012 02:29 PM