ado c#

[Analizer1]

help with excel files plz

ive gotten some xls files dont know from which version
ive also got them to open using ado net , but i had to physically open them
and save them to 4.0
i have office 2003 on my machine...

any good examples out here working with xls files

thks

 

[Kalpesh]

Hi,

This is not a group for Excel. You might need to look at
microsoft.public.excel.programming.
Also, you have not said anything about what problem you are facing?

Kalpesh

 

[Analizer1]

considering im using c#20 and ado net 2.0 , we programmers utilize all kinda
different things in our programming...
so this is a good place to ask for others experience
using c# and or ado net with office products

i am not writing macros...but i'll post to the excel group also

thanks

 

[Nicholas Paldino [.NET/C# MVP]]

Analizer1,

Well, you ^should^ be able to select data from them using the classes in
the System.Data.OleDb namespace, assuming you are using the correct provider
for Excel data.

If the provider won't give you the data (because it is not structured in
a way that prevents the data from being pulled from it), then you can always
automate the process, reading the contents through the automation interface
(COM interop, look for the Primary Interop Assemblies for Office/Excel).

 

[Rad [Visual C# MVP]]

help with excel files plz

ive gotten some xls files dont know from which version
ive also got them to open using ado net , but i had to physically open them
and save them to 4.0
i have office 2003 on my machine...

any good examples out here working with xls files

thks

You should be able to open excel files using the OleDB provider. Google
will help you in terms of the correct parameters to construct the
connection string to cater for things like column headings, etc

 

[Analizer1]

Ive Tried all kind of Different Connect Strings with ole dataprovider , and
this particular xls file just wont open

Now if I open it with Excel and save it ...it works gr8
one of my connection strings, below...
I'll keep working with it, and thank you for getting back to me

much appriciated

ConnStr = "Provider=Microsoft.Jet.OLEDB.4.0;" +

"Data Source=d:\\junk\\Reject 596998_02262008.xls;" +

"Extended Properties='Excel 8.0;HDR=YES;'";

 

[Analizer1]

little more digging into the files, that would not open through oledb

lol..well they come into our business as xls files..but they
are .DBF files....sorry for the inconvienence and
thanks for the help.....

much appriciated