Excel sheet values in a string

<pre>
private string strConnectionString, SelectString;
private OleDbCommand objCmdSelect;
private OleDbDataAdapter objAdapter;
private OleDbConnection objConn;
private DataSet dsUpload, ds;
bool strRet;
</pre>

<pre>
objConn = new OleDbConnection(strConnectionString);
objConn.Open();
DataTable SchemaTable = objConn.GetOleDbSchemaTable (OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
objConn.Close();
string ExcelFirstSheet = "";
string NotUploadedFiles = "";
String[] excelSheets = new String[SchemaTable.Rows.Count];
</pre>

<pre>
strRet = readExcelFile(SelectString);
</pre>

<pre>
private bool readExcelFile(string SelectString)
{
ds = new DataSet();
ds.Clear();
int idx = strFileUpldName.LastIndexOf(".");
if (idx != -1)
{
fileExtension = strFileUpldName.Substring(idx + 1);
}
if (fileExtension == "xls")
{
try
{
objConn = new OleDbConnection(strConnectionString);
objConn.Open();
OleDbCommand objCmdSelect = new OleDbCommand (SelectString,objConn);
OleDbDataAdapter objAdapter1 = new OleDbDataAdapter();
objAdapter1.SelectCommand = objCmdSelect;
objAdapter1.Fill(ds);
Session["dsCRM"] = ds;
objConn.Close();
objConn.Dispose();
return true;
}
catch (Exception e)
{
if (objConn != null)
{
if (objConn.State == ConnectionState.Open)
{
objConn.Close();
}
}
objConn = null;
return false;
}
}
else
{
return false;
}
}
</pre>

Here's some sample code, is VB but is easily convertible to C#:

You need to add a reference to Microsoft.Office.Interop.Excel.

<code>Dim oXL As Microsoft.Office.Interop.Excel.Application
Dim oBook As Microsoft.Office.Interop.Excel.Workbook
Dim oSheet As Microsoft.Office.Interop.Excel.Worksheet
Dim vValue As Object

oXL = New Microsoft.Office.Interop.Excel.Application
oBook = oXL.Workbooks.Open(OpenFileDialog1.FileName)
oSheet = oBook.Worksheets("Sheet1")
'Here you have cell value, just build a loop to get the data you want
'This will loop through all rows in the first column

For i As Integer = 0 To oSheet.Rows.Count
vValue = vValue + ";" + oSheet.Cells(1, i).Value 
Next


myTextBox.Text = vValue</code>