473,408 Members | 1,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,408 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 1329
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

17
by: Mansi | last post by:
I need to do some research on how to use excel automation from c#. Does anyone know of any good books related to this subject? Thanks. Mansi
3
by: Atley | last post by:
I am trying to create a new spreadsheet in Excel using VB.net 2003. This application has to be useable by a range of users running anywhere from Excel 2000 to Excel XP to Excel 2003. My dev...
1
by: Troy | last post by:
I have VB.Net code that opens Excel files and imports data from them. It works fine for all versions up to 2003 and has for over a year. We have users updating to Office 2003 and the Excel...
2
by: sherifffruitfly | last post by:
Hi, I'm using an adaptation of excel-reading code that's all over the internet - I don't much like or understand it, but it has worked for me in the past.... beggars can't be choosers... : ...
0
by: Bill Fallon | last post by:
I am developing a VB.Net application with VS 2005 that opens an Excel workbook and populates the worksheet with data. I started developing the application with Office 2007 installed on my Vista...
1
by: ypap1 | last post by:
I am using Microsoft Excel 2002 with Microsoft Excel library 10 but when I try to run my VBA code in Excel 2003 (comes with office 2003) it does not work. I have imagined that the reason lies with...
15
by: =?Utf-8?B?c2hhc2hhbmsga3Vsa2Fybmk=?= | last post by:
Hi All, We are in the process of Upgrade Excel 2003 (Office 2003) to Excel 2007 (Office 2007) for one of web application. This web application is using Excel (Pivot Table) reports. With Excel...
2
by: smtwtfs007 | last post by:
Guys, I am having problems with Excel 2000 to Excel 2003 dll in production. I am having version 2003 in my PC and I used the below code change to open password protected excel files in my...
0
by: smtwtfs007 | last post by:
Guys, I am having problems with Excel 2000 to Excel 2003 dll in production. I am having version 2003 in my PC and I used the below code change to open password protected excel files in my...
4
by: =?Utf-8?B?THluZXJz?= | last post by:
Hello All, We have a VB.NET application writen using VS 2003. This application apens an excel file from a vendor, reads the data and performs whatever functions it needs. We recently upgraded our...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
0
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

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.