How to insert image in excel 2007 based on ID or NO ?

Question

1.00/5 (1 vote)

See more:

.NET4.5

, +

I work in windows form application c# vs 2015
I can insert data in excel but image cannot insert
when insert another data i using

System.Data.OleDb.OleDbCommand excelCommand = new System.Data.OleDb.OleDbCommand("INSERT INTO [AllPrinting$](UserID,UserName,Country,Member) VALUES (?,?,?,?)", excelConnection);

and i can insert but image cannot insert
how to insert image in excel sheet ?
my insert i need is

"INSERT INTO [AllPrinting$](UserID,UserName,Country,Member,Imag) VALUES (?,?,?,?,?)"

so that how to insert image on excel based on ID OR No
I Search more on internet but not got any thing ?

What I have tried:

How to insert image in excel 2007 ?

Posted 7-Mar-17 2:17am

ahmed_sa

Updated 7-Mar-17 2:34am

v2

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Jochen Arndt · Answer 1 · 2017-03-07T02:34:00

I'm sorry, but this is not possible using OLEDB.

OLEDB is a database interface and supports only cell based import/export for Excel. But images are not stored within cells with Excel. They are separate objects just shown above cells.

[EDIT]
If you need to export images you have to choose a method that supports it.

Excel Automation / Microsoft Office Interop (requires installed Excel)
How to automate Microsoft Excel from Microsoft Visual C#.NET[^]

For the new (Office 2007 XLSX) file formats you can use the Open XML SDK:
Welcome to the Open XML SDK 2.5 for Office[^]
Read and write Open XML files (MS Office 2007)[^]

There are also third party libraries (free and commercial). From my point of view these should be only used for the old XLS file format and when using automation is not possible (Excel not installed on all clients).

Just query a search engine with the above keywords (e.g. "c# excel export <method>"; optional also with "image") to get more information.
[/EDIT]