Creating Excel or Excel compatible Spreadsheets on the server side in C#

Posted by CVertex on Stack Overflow See other posts from Stack Overflow or by CVertex
Published on 2009-09-28T09:58:04Z Indexed on 2010/03/24 9:23 UTC
Read the original article Hit count: 1075

Filed under:

Office

|

spreadsheet

|

excel

|

c#

|

web

I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format.

I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed.

For this web project I'm building, the server doesn't have office installed (and they don't want to buy it).

What's the best library for me to use that allows me to generate office compatible spreadsheets from a windows server 2k8 using IIS7?

Some additional requirements

Ideally, free
Allows for simple cell formulas that can be inserted at runtime

© Stack Overflow or respective owner

Related posts about Office

How To Activate Your Free Office 2007 to 2010 Tech Guarantee Upgrade

as seen on How to geek - Search for 'How to geek'
Have you purchased Office 2007 since March 5th, 2010? If so, here’s how you can activate and download your free upgrade to Office 2010! Microsoft Office 2010 has just been released, and today you can purchase upgrades from most retail stores or directly from Microsoft via download. But… >>> More
"Error in the Site Data Web Service." when performing crawl

as seen on Server Fault - Search for 'Server Fault'
Installed SharePoint Services v3 (SP2, october 2009 cumulative updates, Language Pack), attached to a content database I had previously (all works). Installed Search server 2008 Express (with language pack) on top of WSS and crawl does not work. However it works for newly created web application +… >>> More
OCR anything with OneNote 2007 and 2010

as seen on How to geek - Search for 'How to geek'
Quality OCR software can often be very expensive, but you may have one already installed on your computer that you didn’t know about. Here’s how you can use OneNote to OCR anything on your computer. OneNote is one of the overlooked gems in recent versions of Microsoft Office. OneNote… >>> More
How To Switch Back to Outlook 2007 After the 2010 Beta Ends

as seen on How to geek - Search for 'How to geek'
Are you switching back to Outlook 2007 after trying out Office 2010 beta? Here’s how you can restore your Outlook data and keep everything working fine after the switch. Whenever you install a newer version of Outlook, it will convert your profile and data files to the latest format. … >>> More
Add Your Gmail Account to Outlook 2010 Using IMAP

as seen on How to geek - Search for 'How to geek'
If you’re upgrading from Outlook 2003 to 2010, you might want to use IMAP with your Gmail account to synchronize mail across multiple machines. Using our guide, you will be able to start using it in no time. Enable IMAP in Gmail First log into your Gmail account and open the Settings panel… >>> More

Related posts about spreadsheet

Error while reading from spreadsheet in Ruby

as seen on Stack Overflow - Search for 'Stack Overflow'
I am getting following error while reading from a spreadsheet file. I have searched alot on Google. I have seen posts with similar problems but no reply to the problems. Does anyone know how to resolve this error? C:/Ruby/lib/ruby/gems/1.8/gems/ruby-ole-1.2.8.2/lib/ole/storage/file_system.rb:125:in… >>> More
Copy and paste the data one Excel spreadsheet to another spreadsheet based on column name

as seen on Stack Overflow - Search for 'Stack Overflow'
I need to copy and paste the data from one Excel spreadsheet to another based on column name. For example, one shreadsheet has columns named like Asset, Asset owner. Another spreadsheet has column named like Application, Application Owner. Now I want "Asset" column data to copy and paste into the… >>> More
search & replace on 3000 row, 25 column spreadsheet

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm attempting to clean up data in this (old) spreadsheet and need to remove things like single and double quotes, HTML tags and so on. Trouble is, it's a 3000 row file with 25 columns and every spreadsheet app I've tried (NeoOffice, MS Excel, Apple Numbers) chokes on it. Hard. Any ideas on how else… >>> More
Translate report data export from RUEI into HTML for import into OpenOffice Calc Spreadsheets

as seen on Oracle Blogs - Search for 'Oracle Blogs'
A common question of users is, How to import the data from the automated data export of Real User Experience Insight (RUEI) into tools for archiving, dashboarding or combination with other sets of data.XML is well-suited for such a translation via the companion Extensible Stylesheet Language Transformations… >>> More
What is spreadsheet useful for?

as seen on Programmers - Search for 'Programmers'
I have been in computer business for 15 years in various roles (sysadmin, developer, researcher), and I have never encountered someone using excel for something more advanced than for formatting tables, or as an ad-hoc database that could have been maintained in a text-file. I had to do heavy data-processing… >>> More