accessing xl sheet data through .NET c#

Question

i want to access the cells of excel sheet in .NET c# as we do in case of oracle database. is there any code to convert xl data to oracle.please reply as early as possible.

Bechir Bejaoui · Answer

Not at all you're welcome ; )

Bechir Bejaoui · Answer

Not at all you're welcome ; )

Bechir Bejaoui · Answer

Not at all you're welcome ; )

shruti balapgol · Answer

thankyou so much this code has solved my problem string connectionString1 = "Dsn=scott;uid=system;pwd=query" ; System.Data.Odbc. OdbcConnection con = new System.Data.Odbc. OdbcConnection (connectionString1); System.Data. DataSet dsOracle = new System.Data. DataSet (); string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; " + "Data Source=" + "C:\TBL_STUD_EMP_REC.xls" + ";" + "Extended Properties='Excel" + " 8.0;HDR=NO;IMEX=1;'" ; string CommandText = "select * from [sheet1$]" ; OleDbConnection myConnection = new OleDbConnection (ConnectionString); OleDbCommand myCommand = new OleDbCommand (CommandText, myConnection); myConnection.Open(); OleDbDataReader reader = myCommand.ExecuteReader( CommandBehavior .CloseConnection); while (reader.Read()) { System. Console .WriteLine(reader[0].ToString()); string query = "INSERT INTO SCOTT.TBLSTUDEMPREC values('" + reader[0].ToString() + "','" + reader[1].ToString() + "','" + reader[2].ToString() + "')" ; //'" + reader[3].ToString() + "')"; //values(2,'rini','pune')"; con.Open(); System.Data.Odbc. OdbcCommand cmd = new System.Data.Odbc. OdbcCommand (query, con); System.Data.Odbc. OdbcDataAdapter adpt = new System.Data.Odbc. OdbcDataAdapter (cmd); adpt.Fill(dsOracle); con.Close(); }

Bechir Bejaoui · Answer

http://oraclebizint.wordpress.com/

shruti balapgol · Answer

s i want to read from excel and write it to oracle

Vijaya Kadiyala · Answer

Hi You want to read the data from excel or insert the data into Oracle? Thanks -- Vijaya Kadiyala http://dotnetvj.blogspot.com

Bechir Bejaoui · Answer

The question is not clear You want to access an Excel file or Transfer data from excel to oracle by using insert into SQL request

Sateesh Arveti · Answer

Hi, You can use either Excel Interop library or oledb provider to read excel data.After reading the data into a datareader,loop through it and insert into oracle table as shown below: string ConnectionString = @"Provider=Microsoft.Jet.OLEDB.4.0; Data Source=C:\spreadsheet.xls; Extended Properties=""Excel 8.0;"; string CommandText = "select * from [sheetName]"; OleDbConnection myConnection = new OleDbConnection(ConnectionString); OleDbCommand myCommand = new OleDbCommand(CommandText, myConnection); myConnection.Open(); OleDbDataReader reader = myCommand.ExecuteReader(CommandBehavior.CloseConnection); while (reader.Read()) { //name =reader[0].ToString(); //Oracle Insert stmt here with values got from reader object. }