C# oledbconnection external table is not in the expected format where XLSX contains image

Question

0.00/5 (No votes)

See more:

I have an excel file where it contains an image in the header, I don't care about that image even if it has to be removed. 

I get the following error message while making the connection to the file which contains the image.

    conn.Open();

**External table is not in the expected format**

Whereas if I remove the image from the same excel, everything works fine.

I am looking for a solution to the same, if solution suggests removing the image from excel using C# then it should not be referring to any third party DLL, neither I can have Microsoft office on the server.


Is there any possibility to remove image from excel without OleDb, without office being installed or without using any third party dll ?

Thanks in advance.

What I have tried:

I have tried using third party libraries which are rejected by client, MS office will not be provided on the server and OleDb cannot make a connection to the file which contain Shapes.

Posted 25-Jun-18 0:15am

coolNish

Updated 25-Jun-18 22:07pm

Add a Solution

Comments

Richard MacCutchan 25-Jun-18 6:28am

I just tried to open an XLSX file with an image in the sheet and it works fine. You need to provide more details.

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)

Maciej Los · Answer 1 · 2018-06-25T22:08:00

Solution 1

Just ignore headers. All you need to do is to change connection string from:

C#

strig sConn= string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}='Excel 12.0 Xml;HDR=YES;';", sFullFileName);

to:

C#

strig sConn= string.Format(@"Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0};Extended Properties='Excel 12.0 Xml;HDR=NO;';", sFullFileName);

For further details, please see: Excel connection strings - ConnectionStrings.com[^]

Posted 25-Jun-18 22:08pm

Maciej Los

Comments

Richard MacCutchan 26-Jun-18 4:26am

I had "HDR=YES" in my code and it loaded fine, and just ignored the image.

Maciej Los 26-Jun-18 4:32am

Seems, it depends on image... ;)

Richard MacCutchan 26-Jun-18 4:35am

As is so often the case, not enough information.

Maciej Los 26-Jun-18 4:37am

Oh, yeah!