http://ayende.comAyende @ RahienCopyright (C) Ayende Rahien 2004 - 2021 (c) 202660Just received the news that MS has acquired OfficeWriter from Softartisans... http://ayende.com/2552/looking-for-word-excel-documents-generation#comment27http://ayende.com/2552/looking-for-word-excel-documents-generation#comment27Thu, 14 Jun 2007 17:26:26 GMT I need to make the same decision in the next days, and started to evaluate: http://www.activexls.com/ It costs less than $300 (much cheaper than aspose), and it seems sufficient to get the job done. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment26http://ayende.com/2552/looking-for-word-excel-documents-generation#comment26Thu, 14 Jun 2007 14:27:42 GMTI second CarlosAg's Excel XML Writer. http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx http://ayende.com/2552/looking-for-word-excel-documents-generation#comment25http://ayende.com/2552/looking-for-word-excel-documents-generation#comment25Thu, 14 Jun 2007 12:50:57 GMTBecause my current customer is pretty conservative about deploying *any* new software (probably including the openxml package for office 2003) we went the custom XML/XSLT route. As you always do Ayende, please post what you end up using and why. I've already found some good stuff in the comments here ;) http://ayende.com/2552/looking-for-word-excel-documents-generation#comment24http://ayende.com/2552/looking-for-word-excel-documents-generation#comment24Thu, 14 Jun 2007 03:17:51 GMTI collected a list from the recommendations here so far: http://dotmad.blogspot.com/2007/06/creating-ms-office-documents-from-code.html http://ayende.com/2552/looking-for-word-excel-documents-generation#comment23http://ayende.com/2552/looking-for-word-excel-documents-generation#comment23Wed, 13 Jun 2007 22:23:47 GMTI don't know about Word, but +1 for http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx It was mentioned in Windows Developer Powertools book and i was happy to find it. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment22http://ayende.com/2552/looking-for-word-excel-documents-generation#comment22Wed, 13 Jun 2007 18:14:15 GMT+1 on ExcelWriter from Softartisans. Expensive, but pretty well tested, and a reasonable API. Great for running behind a server - optimized for exactly that purpose. I used it with great success for an application that had to generate word, on the fly, from behind a employee opinion survey web app that needed to be able to serve thousands of users per hour. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment21http://ayende.com/2552/looking-for-word-excel-documents-generation#comment21Wed, 13 Jun 2007 16:04:07 GMTWe've been using ExcelWriter from Softartisans for years now, even integrated VSTO solutions.They also have WordWriter. http://www.softartisans.com/ http://ayende.com/2552/looking-for-word-excel-documents-generation#comment20http://ayende.com/2552/looking-for-word-excel-documents-generation#comment20Wed, 13 Jun 2007 11:35:40 GMTWe create word and excel 2003 documents and save them as office xml format. In word or excel, you can map elements from an xsd very easily onto parts of the document. You can then use the office 2003 xsl inference toolkit to generate xsl from the saved office xml. Next, we create a C# class with xsd.exe from the xsd and use serialization and xslt to create office documents. All free except the office 2003 license needed to create the 'template' document. Business users can maintain the templates from within office 2003. As long as the xsd doesn't change, there is no need for development. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment19http://ayende.com/2552/looking-for-word-excel-documents-generation#comment19Wed, 13 Jun 2007 06:46:40 GMTWe use OpenDocument generation via libraries provided at: http://www.opendocument4all.com/ Libraries are not good, but we do all documents currently. Good points: : it's open source and free, : It's OpenDocument : you can save the result at the moment in pdf, html and odt files : use Boo as a scripting language inside the documents (instead of writing many replace statements) Bad points: : Its OpenDocument : Library is not working always correctly : It's not what you need (excel and word) http://ayende.com/2552/looking-for-word-excel-documents-generation#comment18http://ayende.com/2552/looking-for-word-excel-documents-generation#comment18Wed, 13 Jun 2007 06:00:51 GMTI used office COM automation for a long time for little document, but when documents are big or they must be generated on a web server is not a feasible solution. For simple Doc file I build some years ago a very little RTF generator, rtf format is textual and not too complex to use. For exel file I resorted to get data from sql with the For XML instruction and then I build some XSLT that will transform the file in xml format for excel 2000. If you do not mind to force the user to download the compatibility pack I vote for OpenXml. Alk. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment17http://ayende.com/2552/looking-for-word-excel-documents-generation#comment17Wed, 13 Jun 2007 05:55:01 GMTI second Aspose (http://www.aspose.com), we've used their PowerPoint component which is super fast gives an identical API to that of the Office Object Library. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment16http://ayende.com/2552/looking-for-word-excel-documents-generation#comment16Wed, 13 Jun 2007 04:49:24 GMTSeriously, how many people have OpenXML capable versions of Office? I think very few do. Especially outside the US. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment15http://ayende.com/2552/looking-for-word-excel-documents-generation#comment15Wed, 13 Jun 2007 04:22:46 GMTMy client requires a WYSIWYG tool to create/maintain their own templates. The solution we arrived at was to create a service that accepted a number of standard XML-based messages (e.g. Policy, Claim, etc). The service reads the template ID from the message and hands the message payload to Business Objects XI, which uses the XML as a data source to generate the output document. The service drops the document into a document management system, where it can then be retrieved/edited by the user that requested the document's creation. This approach allows our client to create as many templates as they like against any one of the standard XML schemas, and also allows them to update their templates without any support from IT. Business Objects XI supports Word 2003 as an output format, as well as PDF and many others. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment14http://ayende.com/2552/looking-for-word-excel-documents-generation#comment14Wed, 13 Jun 2007 03:49:46 GMTI've been using this free Excel library for the past couple years: http://www.carlosag.net/Tools/ExcelXmlWriter/Default.aspx You can give it an Excel XML document and it will automatically translate it to C#. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment13http://ayende.com/2552/looking-for-word-excel-documents-generation#comment13Wed, 13 Jun 2007 02:41:18 GMTNathan, I agree with you, but the so called XLS format is a very tricky format. In many cases a lot of report generators would generate files that are not actually a BIFF but try to fault excel by the extension. And to the great compatibility evil of MS, Excel does handle all these files relatively correct. Now the problem is for most 3rd party we are doing some sort of reverse engineering for the file, which means its nearly impossible to make sure we have a peaceful handling of the file. My experience on using Koogra to read BIFF excel for example, does still have some hiccups when I try to open the file. So, while you are correct on the market side of binary format, it is actually not that an evil decision on choosing OpenXML too, if you intend to really have a supported native generation on the server. Ayende, I think it largely depends on what is your client group going to be, if its a closed workgroup (i.e. within a company), I would definitely try my best to drive everyone on OpenXML, especially MS does provides a great way to handle OpenXML on the older versions of Office (I remember its down to 2000). However if you are aiming for public audience, your situation is going to be way more complicated. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment11http://ayende.com/2552/looking-for-word-excel-documents-generation#comment11Wed, 13 Jun 2007 02:29:21 GMTNathan, I agree with you, but the so called XLS format is a very tricky format. In many cases a lot of report generators would generate files that are not actually a BIFF but try to fault excel by the extension. And to the great compatibility evil of MS, Excel does handle all these files relatively correct. Now the problem is for most 3rd party we are doing some sort of reverse engineering for the file, which means its nearly impossible to make sure we have a peaceful handling of the file. My experience on using Koogra to read BIFF excel for example, does still have some hiccups when I try to open the file. So, while you are correct on the market side of binary format, it is actually not that an evil decision on choosing OpenXML too, if you intend to really have a supported native generation on the server. Ayende, I think it largely depends on what is your client group going to be, if its a closed workgroup (i.e. within a company), I would definitely try my best to drive everyone on OpenXML, especially MS does provides a great way to handle OpenXML on the older versions of Office (I remember its down to 2000). However if you are aiming for public audience, your situation is going to be way more complicated. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment12http://ayende.com/2552/looking-for-word-excel-documents-generation#comment12Wed, 13 Jun 2007 02:29:21 GMTMy advice - don't use OpenXML; support for the older binary formats is far more prevalent. I have used GemBox spreadsheet with success. It was nice and easy to implement, and relatively cheap. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment10http://ayende.com/2552/looking-for-word-excel-documents-generation#comment10Wed, 13 Jun 2007 02:05:40 GMTI've had really good luck creating Excel files with SyncFunsion. Rock solid component, clear API. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment9http://ayende.com/2552/looking-for-word-excel-documents-generation#comment9Wed, 13 Jun 2007 01:46:19 GMTFor Excel, I've used Syncfusion's XlsIo and it works really well. No hassles and fast: http://www.syncfusion.com/products/xlsio/windows/default.aspx On the Word side I've used Tx Text Control: http://www.textcontrol.com. It works but the API seems clunky to me. It would be worth giving the Syncfusion DocIO product a go but I haven't tried it myself. As an aside, I've had fault resolution and version backward compatibility issues with Syncfusion controls, but none of that with the XlsIO product. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment8http://ayende.com/2552/looking-for-word-excel-documents-generation#comment8Wed, 13 Jun 2007 00:58:02 GMTFor Word, I've used RTF creation but it's pretty awkward and gets very very fiddly. Best way is definitely the OpenXML. I've used it with Excel without too many problems and this was using Excel 2003 so I'm hoping 2007 would be much better. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment7http://ayende.com/2552/looking-for-word-excel-documents-generation#comment7Tue, 12 Jun 2007 23:43:22 GMTusing Apache POI in conjunction with IKVM. Here an example with IKVM and Apache FOP: http://www.onjava.com/pub/a/onjava/2004/08/18/ikvm.html http://ayende.com/2552/looking-for-word-excel-documents-generation#comment6http://ayende.com/2552/looking-for-word-excel-documents-generation#comment6Tue, 12 Jun 2007 21:59:58 GMTThere is always the low-tech method of generating HTML and changing the Response.ContentType to that of the application you want the result to open with. I have used this for both a generic search results export to excel as well as for custom excel reports with images and formatting. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment5http://ayende.com/2552/looking-for-word-excel-documents-generation#comment5Tue, 12 Jun 2007 21:16:28 GMTDefinetly look into using open xml. Microsoft added the System.IO.Packaging namespace to .Net 3.0 and has just released a SDK as a CTP. Also there is a great community site here: http://openxmldeveloper.org If your docs will be opened in office 2000/XP/2003 then you'll need to install the compatibility pack but that is available as a free patch from microsoft. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment4http://ayende.com/2552/looking-for-word-excel-documents-generation#comment4Tue, 12 Jun 2007 20:59:46 GMTHave a look at http://www.codeplex.com/ExcelPackage for generating Excel files. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment3http://ayende.com/2552/looking-for-word-excel-documents-generation#comment3Tue, 12 Jun 2007 20:57:15 GMTOur company is using these components: http://www.aspose.com/ $8K for a site license but a lot of functionality and easy to use. http://ayende.com/2552/looking-for-word-excel-documents-generation#comment2http://ayende.com/2552/looking-for-word-excel-documents-generation#comment2Tue, 12 Jun 2007 20:11:47 GMThttp://www.infoq.com/news/2007/06/OpenXML-Libraries http://ayende.com/2552/looking-for-word-excel-documents-generation#comment1http://ayende.com/2552/looking-for-word-excel-documents-generation#comment1Tue, 12 Jun 2007 19:15:07 GMT