471,354 Members | 1,199 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,354 software developers and data experts.

Excel 2003

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

Jan 8 '06 #1
5 1281
In article <uN**************@TK2MSFTNGP10.phx.gbl>, Ollie Riches wrote:
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?

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, PPT MVP
PPT FAQ: www.pptfaq.com
PPTools: www.pptools.com
================================================

Jan 8 '06 #2
Take a look at Office Web Components (OWC). Read the licensing details (if
you can possibly interpret them!)
Peter

--
Co-founder, Eggheadcafe.com developer portal:
http://www.eggheadcafe.com
UnBlog:
http://petesbloggerama.blogspot.com


"Ollie Riches" wrote:
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

Jan 9 '06 #3
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!

Jan 9 '06 #4
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
Jan 9 '06 #5
Check out this website:
http://msdn.microsoft.com/library/de...dc_oxppias.asp

greetz,
Dries

Ollie Riches wrote:
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

Jan 9 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

17 posts views Thread by Mansi | last post: by
3 posts views Thread by Atley | last post: by
15 posts views Thread by =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post: by
2 posts views Thread by smtwtfs007 | last post: by
reply views Thread by smtwtfs007 | last post: by
4 posts views Thread by =?Utf-8?B?THluZXJz?= | last post: by
reply views Thread by XIAOLAOHU | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.