Excel.Range range; // 取第一行,第一列这个格的值 range = objSheet.get_Range("A1",Missing.Value); range = range.get_Resize(1, 1); String[,] saRet = new String[1, 1]; saRet = range.get_Value(Missing.Value);
6. 给单元格设置变量:Range range1 = worksheet.get_Range("C1", Missing.Value); if (range1 == null) { Console.WriteLine ("ERROR: range == null"); } const int nCells = 1; Object[] args1 = new Object[1]; args1[0] = nCells; range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, range1, args1);
Excel.Range range = objSheet.get_Range("A1",Missing.Value); range = range.get_Resize(1, 1); String[,] saRet = new String[1, 1]; saRet = range.get_Value(Missing.Value);
// 取第一行,第一列这个格的值
range = objSheet.get_Range("A1",Missing.Value); range = range.get_Resize(1, 1);
String[,] saRet = new String[1, 1];
saRet = range.get_Value(Missing.Value);
把Excel中的数据读到DataSet中,然后从DataSet中取想要的值!
http://www.codeproject.com/csharp/Package.asp
http://support.microsoft.com/kb/302084
if (range1 == null) {
Console.WriteLine ("ERROR: range == null");
}
const int nCells = 1;
Object[] args1 = new Object[1];
args1[0] = nCells;
range1.GetType().InvokeMember("Value", BindingFlags.SetProperty, null, range1, args1);
range = range.get_Resize(1, 1);
String[,] saRet = new String[1, 1];
saRet = range.get_Value(Missing.Value);