Sign In| Join
Get Help:Ask a Question in our Forums|Report a Bug|More Help Resources
Last post Aug 23, 2012 01:53 PM by abiruban
Member
18 Points
16 Posts
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?
Contributor
2808 Points
500 Posts
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...
Aug 23, 2012 12:11 PM|LINK
can you give me any example code ? and I found that .dll is chargeable
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...
All-Star
16048 Points
2734 Posts
Aug 23, 2012 01:53 PM|LINK
HI,
http://excelpackage.codeplex.com/
http://steveorr.net/Articles/ExcelExport.aspx
thanks...
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?
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...
Cheers!
- Kaushik Patel
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
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...
Cheers!
- Kaushik Patel
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...
***DON'T FORGET TO CLICK “MARK AS ANSWER” ON THE POST IF HELPED YOU.