473,548 Members | 2,636 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Excel automation - writing image/picture files

I'm trying to automate Excel 2003 from Visual C# .Net. Is it possible to
export an picture/image file from c# to excel?

If so, how do you do this? Are there any code examples available?

Thanks.

Mansi

Nov 22 '05 #1
2 1920
You can use the COM libraries that MS provides. In your project go to add
reference to the COM tab. If you have office installed you should be able to
find a library similar to "Microsoft Excel 11.0 Object Library". This library
allows you to automate Excel. The object model is very easy to learn. Notice
that almost everything in the library is an interface. You can get started by
going through the ApplicationClas s class. Search MSDN for more information...

Take a look at this: www.codeproject.com/com/ComExcelImages.asp

"Mansi" wrote:
I'm trying to automate Excel 2003 from Visual C# .Net. Is it possible to
export an picture/image file from c# to excel?

If so, how do you do this? Are there any code examples available?

Thanks.

Mansi

Nov 22 '05 #2
Thanks so much for this link! This is exactly what I was looking for. :)

"Alex K" wrote:
You can use the COM libraries that MS provides. In your project go to add
reference to the COM tab. If you have office installed you should be able to
find a library similar to "Microsoft Excel 11.0 Object Library". This library
allows you to automate Excel. The object model is very easy to learn. Notice
that almost everything in the library is an interface. You can get started by
going through the ApplicationClas s class. Search MSDN for more information...

Take a look at this: www.codeproject.com/com/ComExcelImages.asp

"Mansi" wrote:
I'm trying to automate Excel 2003 from Visual C# .Net. Is it possible to
export an picture/image file from c# to excel?

If so, how do you do this? Are there any code examples available?

Thanks.

Mansi

Nov 22 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
453
by: Mansi | last post by:
I'm trying to automate Excel 2003 from Visual C# .Net. Is it possible to export an picture/image file from c# to excel? If so, how do you do this? Are there any code examples available? Thanks. Mansi
7
5329
by: taylor.bryant | last post by:
I am running: Win XP SP2 Excel 2002, Access 2002 (Office XP SP3) Using Visual Basic (not VB.NET) At one point (prior to XP SP2?!? - I can't pin it down), this did not happen and I was easily able to destroy instances of excel (with the exact same code). I have read many, many posts, and they seem to get bogged down in specifics. So I...
17
6314
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
4
1991
by: Banu_tr | last post by:
Hello, In my windows app. I send the result of sp to excel sheet. It has siz column. My problem is, I want to make the text in a column to hyperlink. How ca nI do this when I am sending the info to excel. thanks,
9
4416
by: hari krishna | last post by:
hi, I want to send the data from dataset information to Excel through ASP.Net. there will be no XL installed on web server. web server is win 2000 server machine. I am using visual basic code in asp.net. The Xl sheet should not be opened in the browser. All the information from dataset(datatable,datarows) should be sent to XL and the file...
1
1704
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 automation breaks on those machines. Does coding to the earliest supported version of Excel not apply once you get to 2003?
6
3154
by: Thelma Lubkin | last post by:
I am trying to modify an Access form that allows a user to specify the information s/he needs from a census-type database. The form's code builds a SQL statement from the user's request, and creates from this a record set that is used to populate a new Excel workbook. The form's code opens the new workbook and writes both a datasheet and a...
14
6880
by: cj | last post by:
I want to start a workbook and add sheets to it one at a time. Right now my code opens a workbook and it has 3 sheets alread in it and I don't even know how to move from one to another. Any help would be appreciated. Here is my code. Dim oXL As Excel.Application Dim oWB As Excel.Workbook Dim oSheet As Excel.Worksheet
3
3240
by: saragoesnuts | last post by:
I have a program that automates to Excel with information in tables. I want to add charts to the excel file (pie charts, bar charts, etc). Is this possible?
4
3970
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 sytems to Excel 2003 from Excel 2000. Our application started erroring out because it was having a problem with opening the Excel file. From...
0
7512
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7438
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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7707
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
0
7951
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
0
6036
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
1
5362
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5082
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 then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
1
1926
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
1
1051
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.