怎样从不规则的Excel表格中提取数据

[jjfen]

怎么才能从不规则的Excel表格中提取数据,最好有详细代码,本人属菜鸟级别的,希望各位能尽可能详细的说明下,在此先谢谢了!!

[huo789]

不规则的Excel表格?

[zhqs1000]

public DataSet ExcelToDS()
{
string path = System.Environment.CurrentDirectory;
path = path + @"\" + "shwgexcel" + @"\";
string s = null;
string[] mFilesPath = System.IO.Directory.GetFiles(path);
MessageBox.Show(mFilesPath[1].ToString());
string strConn = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + mFilesPath[1].ToString() + ";" + "Extended Properties=Excel 8.0;";
OleDbConnection conn = new OleDbConnection(strConn);
conn.Open();
string strExcel = "";
OleDbDataAdapter myCommand = null;
DataSet ds = null;
strExcel = "select * from [全纪实$]";
myCommand = new OleDbDataAdapter(strExcel, strConn);
ds = new DataSet();
myCommand.Fill(ds, "table1");
return ds;
}

[lldwolf]

以Excel2003为例， 引用Excel COM库

using Excel = Microsoft.Office.Interop.Excel;
...
Excel.Application xApp = new Excel.ApplicationClass();
xApp.Visible = true;
Excel.Workbook xBook = xApp.Workbooks.Open("要读取的Excel文件");

//下标值从1开始，获取要读取的工作表
Excel.Worksheet xSheet = xBook.Worksheets[1];

//读取单元格（2，2）的内容
string cell_value = xSheet.Cells[2, 2].Value2;

[lldwolf]

上例中打开Excel文件的函数Open其实有很多参数，根据Excel的版本而不同，除了第一个参数外，其它都用System.Reflection.Missing.Value即可, 在Excel2003中如下

Excel.Workbook xBook = xApp.Workbooks.Open(@"c:\1.xls", Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value, Missing.Value);