generating and publishing Excel sheets on the web

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

ASP.NET

generating and publishing Excel sheets on the web

Author

Topic

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-11-27 : 11:14:28

Question: any practical documentation or quickstarts for generating and publihing excel sheets from sql server to be published on asp.net

2/what do we call this need in the asp.net jargon
Thanks a lot for your help.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-11-27 : 12:15:22

publishing how?

have you looked into OWC = Offce web components?

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-11-27 : 12:24:03

There's lots of tools for doing it
This one is free and works pretty well
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx

I've used this one and found the company to be pretty helpful
http://www.aspose.com/Products/Aspose.Excel/Default.aspx

Or you can take your pick
http://www.google.com/search?hl=en&q=excel+.net+library

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-11-27 : 12:41:31

Can I also use .Net built-in functionnalities. where is that in msdn documentation pls?
I am asking for .net built in way because i don t think the company i will work for has any of the third party tools.
It s first time i m gonna learn that.

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-11-27 : 12:49:59

i'm still not quite clear what you're trying to do.
display data in excel form on the net or something like that?

there is no .net built in way. you have to use com interop.
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx pointed by snSQL is free and looks great.

OWA has some weird licencing issues.

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

snSQL
Master Smack Fu Yak Hacker

1837 Posts

Posted - 2006-11-27 : 12:51:53

There are no Excel libraries built in to the .NET Framework. You could generate the spreadsheets by writing code to create XML, see
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnofftalk/html/Office05012006Excel2003SpreadsheetML.asp
http://www.microsoft.com/downloads/details.aspx?FamilyId=FE118952-3547-420A-A412-00A2662442D9&displaylang=en

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-11-27 : 14:12:26

thanks a lot amigo

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-11-27 : 23:51:54

Here is what I need: The data is in SQL server, I need to treat it and then generate excel sheets or pdf files to be published on asp.net. (sorry if my stuff still doesn t make sense)

spirit1
Cybernetic Yak Master

11752 Posts

Posted - 2006-11-28 : 04:02:31

i have to repeat myself:
http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx
or OWC

Go with the flow & have fun! Else fight the flow

blog thingie: http://weblogs.sqlteam.com/mladenp

rtutus
Aged Yak Warrior

522 Posts

Posted - 2006-11-28 : 10:41:57

thanks dear spirit , snsql and to all of you guys.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources