ansaurus

Question

How can I programatically create, read, write an excel without having office installed?

Answer 1

+5 A:

read and write csv files instead. Excel reads them just fine and they're easier to use. If you need to work against .xls files then try having support for OpenOffice as well as Excel. OpenOffice can read and write excel files.

RHicke 2009-09-02 18:28:13

The OpenOffice API can be very useful here: http://api.openoffice.org/

Jweede 2009-09-02 18:38:31

Problem here is 0 formatting.

Kyle Rozendo 2009-09-02 18:42:28

Answer 2

+7 A:

Without Office installed you'll need something designed to understand the Excel binary file format (unless you only want to open Office 2007 .xlsx files).

The best I've found (and that I use) is SpreadsheetGear, which in addition to being .NET native, is much faster and more stable then the COM/OLE solutions (which I've used in the past)

David 2009-09-02 18:28:48

Answer 3

A:

Excel files are in a proprietary format so (afaik) you're not going to be able to do this without having the office interop available. Some third party tools exist (which presumably licence the format from MS?) but I've not used them myself to comment on their usefulness.

I assume that you can't control the base file format, i.e. simple CSV or XML formats aren't going to be possible?

annakata 2009-09-02 18:30:13

Answer 4

+18 A:

write your excel in HTML table format:

<html>
<body>
  <table>
    <tr>
    <td style="background-color:#acc3ff">Cell1</td>
    <td style="font-weight:bold">Cell2</td>
    </tr>
  </table>
</body>
</html>

and give your file an xls extension. Excel will convert it automatically

Gregoire 2009-09-02 18:34:49

you're freaking kidding me.

eviljack 2009-09-02 19:25:42

I've used this method several times, simple, works great. But in the case of web apps, just set the content type/mime type to excel (cant remember the exact mime type off the top of my head)

Neil N 2009-09-02 19:33:56

And, depending on your version of excel, it usually picks up formatting as well. Bolded table cell? Excel carries it over.. Background color? copies that too...

Neil N 2009-09-02 19:35:37

I use this all the time to export xls files from web apps.

recursive 2009-09-02 19:37:27

That is the coolest thing i've seen this week. I've spent hours trying to find a nice way to export XLS from PHP

Neil Aitken 2009-10-22 15:34:48

Answer 5

A:

I used to use a very nice library called CarlosAg, which uses Excel XML format. It was great (and Excel recognizes the format), and also incredibly fast. Check it out here.

Oh, as a side note, we used to use this for the very same reason you need it. The servers that generated these files were not able to have Excel installed.

Kyle Rozendo 2009-09-02 18:36:16

Answer 6

A:

If you cannot work with CSV files as per @RHicke's suggestion, and assuming you are working on a web app, since a desktop app would be guaranteed to have XL installed as per requirements.

I'd say, create your processing app as a webservice, and build an XL addin which will interact with your webservice directly from XL.

John MacIntyre 2009-09-02 18:38:21

Answer 7

+1 A:

Did you consider way number bazillion and one: using the Open XML SDK? You can retain styles and tweak it to your liking. Anything you can do in an actual file is possible to achieve programatically. The SDK comes with a tool called Document Reflector that shows the underlying XML and even shows LINQ statements that can be used to generate them. That is key to playing around with it, seeing how the changes are made, then recreating that in code.

The only caveat is this will work for the new XML based formats (*.xlsx) not the older versions. There's a slight learning curve but more material is making its way on blogs and other sites.

Ahmad Mageed 2009-09-02 18:39:27

Answer 8

A:

Excel XLSX files "just" XML files - more precisely ZIP files containing several XML files. Just rename a Excel file Test.xslx to Test.zip and open it with your favourit ZIP program. XML schemas are, afaik, standardized and availiable. But I think it might not be that easy to manipulate them only using primitive XML processiing tools and frameworks.

Daniel Brückner 2009-09-02 18:39:43

Answer 9

A:

For XLSX files, look at using http://www.codeplex.com/ExcelPackage. Otherwise, some paid 3rd party solutions are out there, like the one David suggested.

Josh 2009-09-02 18:44:37

Answer 10

+1 A:

Chris Persichetti 2009-09-02 19:18:08

After trying out some of the free alternatives, my team decided on using Aspose.Cells as well. It's very intuitive to use and the code is easy to maintain.

dawntrader 2009-09-03 01:31:08

ansaurus

tags:

views:

answers:

How can I programatically create, read, write an excel without having office installed?

related questions