Excel 2003

[Ollie Riches]

What Office (2003) software (dll's) is required to programmatically (C#
..Net) generate an excel file on a production server that does not have any
office software installed on it?

Can I use only the office SDK or do I require an installation of office?

Is it possible I can only install the dll's required to do the automation?

Thanks in advance

Ollie

 

[Steve Rindsberg]

What Office (2003) software (dll's) is required to programmatically (C#
..Net) generate an excel file on a production server that does not have any
office software installed on it?

That's the wrong question.

You should be asking "Is this legal".

The answer would be "No", at least if you plan to distribute the DLLs w/o
purchasing a full copy of Office for the computer.

If you have a legal copy of Office for the server, why not install it rather
than worry over what bits are or aren't required to do what you want?

 

[Alexander]

You can't use Excel with only the interop dll. You need to have Excel
completely installed.

Why? because the interop dll only calls a Excel process thats been
started using DCOM.

If you want this using ASP.NET I suggest you don't (or use the new .net
2005 word interop's) because its really a pain in the ass because of
security and the running processes. If your program fails the process
won't be terminated!

 

[Peter Bromberg [C# MVP]]

Take a look at Office Web Components (OWC). Read the licensing details (if
you can possibly interpret them!)
Peter

 

[Stephen Bullen]

Hi Ollie,

What Office (2003) software (dll's) is required to programmatically (C#
..Net) generate an excel file on a production server that does not have any
office software installed on it?

The easiest way is probably to generate an Excel workbook in xml form. The
easiest way to do that is to create a workbook on a client machine and save it
as xml. Then manually edit the xml, add some bookmark IDs and save it on the
server. Then the server process and read the xml, find/replace the bookmark
IDs with actual data and save it. If you're lucky, you'll get a readable Excel
workbook.

Regards

Stephen Bullen
Microsoft MVP - Excel

Professional Excel Development
The most advanced Excel VBA book available
www.oaltd.co.uk/ProExcelDev

 

[Dries]

Check out this website:
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnoxpta/html/odc_oxppias.asp

greetz,
Dries