when
worksheet
is
public Excel.Worksheet worksheet1 = null;
remeber you need to load the excel into worksheet1
-------------------------------------------------
public ReadExcelDoc(string filename)
{
app = new Excel.Application();
workbook = app.Workbooks.Open(filename, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue, misValue);
worksheet1 = (Excel.Worksheet)workbook.Worksheets.get_Item(1);
worksheet2 = (Excel.Worksheet)workbook.Worksheets.get_Item(2);
String or int or double as you need = readData(1, 1, worksheet1);
Close();
}
public double readData(int row, int col, Excel.Worksheet worksheet)
{
Object data;
workSheet_range = (Excel.Range)worksheet.Cells[row, col];
data = (System.Object)workSheet_range.get_Value(Missing.Value);
return Convert.ToDouble(data);
}
private object misValue = System.Reflection.Missing.Value;