ansaurus

Question

excel processing in c#

Answer 1

+1 A:

To do this you would need to start 50 instances of Excel, that would not work.

You have 3 options:

Use Open XML SDK 2.0 for Microsoft Office. This allows you to write to an excel file as if it was an xml file. No need to start Excel.
Use SharePoint Excel Services. This allows you to do server side Excel processing. No need to start Excel. The problem with this is that the SharePoint version that includes Excel Services is expensive.
Process the files one at a time, as you suggested.

Shiraz Bhaiji 2010-10-12 13:01:22

Open XML is supported in Excel 2007. But I need to support Excel 2003.

Jai 2010-10-12 13:23:21

Since Open XML is the only option for my problem. Moving to Excel 2007 and open xml.

Jai 2010-10-12 15:19:30

Answer 2

A:

Does the generation of 50 excel files require user interaction?
If not, you can create a nightly job that generates files.

If it is a plain text kind of a format(or CSV), you don't need Excel.
Also, you can use one excel instance to generate all the files, one after the other.

shahkalpesh 2010-10-12 13:15:02

Answer 3

+1 A:

ooooh i once have that kind of problem b4.

my solution is i use html excel. honestly, its kinda stupid solution, but it work pretty well and very easy to implement.

1 create html template a bit like this

<html>
<body>
name - <div>$<name>$</div>
</body>
</html>

2 read your template as string

System.IO.StreamReader stream = new System.IO.StreamReader("");
string template = stream.ReadToEnd();
template = template.Replace("$<name>$", "John");

3 then save your string as .xls

**to create a template sheets is very easy.

1 create excel template like u normally do in excel

2 in the cell u want to replace yout value type in $$name$$ *note that above i use $<'value'>$. but if we do this way i suggest u cahnge to $$name$$ becus for < and > excel gonna do HtmlEncode for us

3 u can create many sheets as u like

4 'Save as' .mht

5 then later change file.mht to .xls and string.Replace("$$name$$", "John");

888 2010-10-12 14:01:22

In my past life I have done this and it works pretty well. Excel is basically tabular data. You use quite a lot of formatting using HTML tags and excel will properly open your file.

Pradeep 2010-10-12 14:08:59

pls redirect me to some links, so I can get more information on this. My scenario is I will have a excel sheet which contains multiple sheets, I need to format excel, create charts in it. Using this html type can I generate charts?

Jai 2010-10-12 14:13:55

ansaurus

tags:

views:

answers:

excel processing in c#

related questions