Excel gerneration using OWC

Posted by Nishithraj under Regular Expressions on 1/20/2010 | Views : 3627 | Status : [Member] | Replies : 4
How do we work with excel files using OWC in ASP.NET and C#.

Following are the requirements.

1) I need to create the columns & rows dynamically from database.
2) I need to protect some rows and unprotect some rows.
3) I need to hide some columns.
4) I need to read the values from some columns.

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan



Responses

Posted by: Cika.Pero1 on: 1/27/2010 [Member] Starter

Up
0
Down
Hi,

you could check out GemBox.Spreadsheet .NET spreadsheet library.
http://www.gemboxsoftware.com/GBSpreadsheet.htm

Reading from database is trivial with export/import Excel file to DataTable.
http://www.gemboxsoftware.com/LA/Import-Export-DataTable-XLS-XLSX-CSV-HTML-.NET.htm

Your other requirements are also supported within one method call to our library.

Additional features include read/write XLS, XLSX, ODS, CSV from same programming model and independence of Excel for fast reading & writing and for server side usage.

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: David Den on: 7/10/2010 [Member] Starter

Up
0
Down
try to using Spire.XLS, it to do following work just few line code,

1) I need to create the columns & rows dynamically from database.
2) I need to protect some rows and unprotect some rows.
3) I need to hide some columns.
4) I need to read the values from some columns.

Demos
http://www.e-iceblue.com/Knowledgebase/Spire.XLS/Demos.html
More detail,
http://www.e-iceblue.com/Introduce/excel-for-net-introduce.html

Hope help to you.





David den

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Sagarp on: 1/20/2010 [Member] Bronze

Up
0
Down
ref
this
http://srtsolutions.com/blogs/billwagner/archive/2004/05/15/simple-excel-formatting-with-owc.aspx


Thanks
sagar

Thanks
SagarP
http://www.emanonsolutions.net
http://emanonsolutions.blogspot.com/

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Nishithraj on: 1/20/2010 [Member] Bronze

Up
0
Down
Sagar, the link that you provided is not there in C#.

Any body worked with OWC and C# kindly help

Mark this as answer, if it is.....

With regards
Nishithraj Narayanan

Nishithraj, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response