http://mschnlnine.vo.llnwd.net/d1/Dev/App_Themes/C9/images/feedimage.pnghttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/To Excel or not... what would you use to create Excel reports?http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/en-usThu, 03 Jul 2008 17:36:53 GMTThu, 03 Jul 2008 17:36:53 GMTEvNet (EvNet, Version=1.0.3250.42470, Culture=neutral, PublicKeyToken=null)what is you want complex formatting?<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=413609Thu, 03 Jul 2008 17:36:53 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4136090http://channel9.msdn.com/413609/WebViewBug.aspx?EVT=0what is you want complex formatting?Ion Todirel0http://channel9.msdn.com/413609/Trackback.aspxI would like to do SQL reporting, but until that is deployed... (Why wouldn't it be deployed?!?!)<br /><br />XML Excel dialect? Any examples? I think that's the kind of thing the MonoRail code is doing, but it looks like ASP classic, with MonoRail code interspersed in the View file with Markup.<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=413605Thu, 03 Jul 2008 17:31:40 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4136050http://channel9.msdn.com/413605/WebViewBug.aspx?EVT=0I would like to do SQL reporting, but until that is deployed... (Why wouldn't it be deployed?!?!)XML Excel dialect? Any examples? I think that's the kind of thing the MonoRail code is doing, but it looks like ASP classic, with MonoRail code interspersed in the View file with Markup.qwert2310http://channel9.msdn.com/413605/Trackback.aspxJust XML Excel dialect (not OOXML etc.). Simple and fast. Even OpenOffice can open this format.<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412916Mon, 30 Jun 2008 22:38:57 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4129160http://channel9.msdn.com/412916/WebViewBug.aspx?EVT=0Just XML Excel dialect (not OOXML etc.). Simple and fast. Even OpenOffice can open this format.BlackTiger0http://channel9.msdn.com/412916/Trackback.aspxTeleriks Reporting Framework and Teleriks Rad Grid both export to Excel, PDF, DOC.<br /><br />SQL Server Reporting Services offers similair functionality. <br /><br />Point is do not get in the business of manually creating Excel docs. Going third party will usually be easier and result in less maintenance.http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412908Mon, 30 Jun 2008 21:34:13 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4129080http://channel9.msdn.com/412908/WebViewBug.aspx?EVT=0Teleriks Reporting Framework and Teleriks Rad Grid both export to Excel, PDF, DOC.SQL Server Reporting Services offers similair functionality. Point is do not get in the business of manually creating Excel docs. Going third party will usually be easier and result in less maintenance.foreachdev0http://channel9.msdn.com/412908/Trackback.aspx+1 on CSV.&nbsp; Keep it simple.<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412902Mon, 30 Jun 2008 21:07:15 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4129020http://channel9.msdn.com/412902/WebViewBug.aspx?EVT=0+1 on CSV.&nbsp; Keep it simple.Matthew van Eerde0http://channel9.msdn.com/412902/Trackback.aspxWell, here's some more info:<br /><br />These reports are not straight tables of data. It'll have a header, different sections of data, and they want to be able to adjust/add to the data once they get the report.<br /><br />Currently the solution uses MonoRail.<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412855Mon, 30 Jun 2008 18:52:57 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4128550http://channel9.msdn.com/412855/WebViewBug.aspx?EVT=0Well, here's some more info:These reports are not straight tables of data. It'll have a header, different sections of data, and they want to be able to adjust/add to the data once they get the report.Currently the solution uses MonoRail.qwert2310http://channel9.msdn.com/412855/Trackback.aspxI actually am exporting a single dataset through an XSLT template, transforming it to an .xsl file ... and it works like a charm.<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412374Fri, 27 Jun 2008 10:48:22 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4123740http://channel9.msdn.com/412374/WebViewBug.aspx?EVT=0I actually am exporting a single dataset through an XSLT template, transforming it to an .xsl file ... and it works like a charm.Zeus0http://channel9.msdn.com/412374/Trackback.aspxI link a lot of sql server analysis services cubes to excel. <br /><br />Its brilliant. I create a whole bunch of data sources and views and give them items, dimensions, measure groups. Thry control their own grouping sorting etc by hitting check box's. Very powerful stuff because from one report and one cube its can produce 50 or so different reports (or ways of looking at the report) ... and whats best the user decides! Brilliant<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412367Fri, 27 Jun 2008 10:25:49 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4123670http://channel9.msdn.com/412367/WebViewBug.aspx?EVT=0I link a lot of sql server analysis services cubes to excel. Its brilliant. I create a whole bunch of data sources and views and give them items, dimensions, measure groups. Thry control their own grouping sorting etc by hitting check box's. Very powerful stuff because from one report and one cube&#8230;Pace0http://channel9.msdn.com/412367/Trackback.aspxDatatable &gt; Excel.<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412325Fri, 27 Jun 2008 07:23:02 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4123250http://channel9.msdn.com/412325/WebViewBug.aspx?EVT=0Datatable &gt; Excel.jh712830http://channel9.msdn.com/412325/Trackback.aspxIt depends how your current web reports are generated, i.e. .rdls' or some third party solution like crystal reports? <br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412314Fri, 27 Jun 2008 07:01:54 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4123140http://channel9.msdn.com/412314/WebViewBug.aspx?EVT=0It depends how your current web reports are generated, i.e. .rdls' or some third party solution like crystal reports? vesuvius0http://channel9.msdn.com/412314/Trackback.aspxI would want to know about more about the reports and what they are going to do with them once they have the data. Perhaps provide them with a webservice so they can pump data&nbsp;straight from your system to theirs without using a middle man.http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412313Fri, 27 Jun 2008 06:58:14 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4123130http://channel9.msdn.com/412313/WebViewBug.aspx?EVT=0I would want to know about more about the reports and what they are going to do with them once they have the data. Perhaps provide them with a webservice so they can pump data&nbsp;straight from your system to theirs without using a middle man.Sabot0http://channel9.msdn.com/412313/Trackback.aspxUnless some major formatting is required, I think I'd go with CSV too.http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412271Fri, 27 Jun 2008 00:28:30 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4122710http://channel9.msdn.com/412271/WebViewBug.aspx?EVT=0Unless some major formatting is required, I think I'd go with CSV too.spivonious0http://channel9.msdn.com/412271/Trackback.aspxWell, as a matter of fact, I already went for&nbsp;CSV once...&nbsp;&nbsp; Customers hardly notice the difference and never requested an "upgrade".http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412260Thu, 26 Jun 2008 22:15:49 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4122600http://channel9.msdn.com/412260/WebViewBug.aspx?EVT=0Well, as a matter of fact, I already went for&nbsp;CSV once...&nbsp;&nbsp; Customers hardly notice the difference and never requested an "upgrade".raptor36760http://channel9.msdn.com/412260/Trackback.aspx<blockquote> <div>qwert231 said:</div> <div>(After a few responses I'll reply with what my predecessor decided to go with.)</div> </blockquote> <br />CSV?http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412216Thu, 26 Jun 2008 20:03:23 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4122160http://channel9.msdn.com/412216/WebViewBug.aspx?EVT=0 qwert231 said: (After a few responses I'll reply with what my predecessor decided to go with.) CSV?littleguru0http://channel9.msdn.com/412216/Trackback.aspxdepends on how complex. OWC if its fairly straightfoward, aspose if it is something more complex.<br /><br />Of course the future is excel services from MOSS(?) but afaik it is not free like owc, nor as easy to install.http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412207Thu, 26 Jun 2008 19:27:27 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4122070http://channel9.msdn.com/412207/WebViewBug.aspx?EVT=0depends on how complex. OWC if its fairly straightfoward, aspose if it is something more complex.Of course the future is excel services from MOSS(?) but afaik it is not free like owc, nor as easy to install.harumscarum0http://channel9.msdn.com/412207/Trackback.aspxThere are a few libraries out there that can generate Excel format file without requiring Excel to be on the server.<br /><br />And, you never, ever want Excel running on your server.<br />http://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=412206Thu, 26 Jun 2008 19:22:31 GMThttp://channel9.msdn.com/forums/Coffeehouse/412204-To-Excel-or-not-what-would-you-use-to-create-Excel-reports/?CommentID=4122060http://channel9.msdn.com/412206/WebViewBug.aspx?EVT=0There are a few libraries out there that can generate Excel format file without requiring Excel to be on the server.And, you never, ever want Excel running on your server.Minh0http://channel9.msdn.com/412206/Trackback.aspx