Answer the question
In order to leave comments, you need to log in
What are the features when working with excel files through ole db?
For example there is a code:
OleDbCommand command = new OleDbCommand();
OleDbConnection connection = new OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + fileName + ";Extended Properties=Excel 8.0;");
connection.Open();
string sql = "select * from Sheet1";
command.Connection = connection;
command.CommandText = sql;
OleDbDataReader reader = command.ExecuteReader();
...
Answer the question
In order to leave comments, you need to log in
A logical impression, in principle)
Yes, the opportunity is convenient, but for a "regular" cell structure, you can write (it was a long time ago, offhand) anything without changing the format
Plus dancing with the data source (is there an appropriate provider in the system, settings)
If the format is floating, then it is more logical to use the Excel Primary Interop Assembly
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question