C#操作MS Excel

//将Excel表格中某一sheet中内容放于dataGrid中显示示例:
/*
string strCon = " Provider = Microsoft.Jet.OLEDB.4.0 ; Data Source = f://表.xls;Extended Properties=Excel 8.0";
            OleDbConnection myConn = new OleDbConnection(strCon);
            string strCom = " SELECT * FROM [表$] ";
            myConn.Open();
            OleDbDataAdapter myCommand = new OleDbDataAdapter(strCom, myConn);
            DataSet myDataSet;
            myDataSet = new DataSet();
            myCommand.Fill(myDataSet, "[表$]");
            myConn.Close();

            this.dataGridView1.DataSource = myDataSet.Tables[0];
*/

 

//新建一个只含有一个表单的Excel文件,并对其内单元格进行操作示例:
/*
            Microsoft.Office.Interop.Excel.Application newXls = new Microsoft.Office.Interop.Excel.Application();
            Microsoft.Office.Interop.Excel.Workbook obj = newXls.Application.Workbooks.Add(true);
            newXls.Cells[1, 2] = "hei,chrovan!";
           // newXls.Workbooks.Add(@"f:/表.xls");
            newXls.Visible = false;
           obj.SaveAs(@"f:/xx.xls", Microsoft.Office.Interop.Excel.XlFileFormat.xlExcel9795, null, null, false, false, Microsoft.Office.Interop.Excel.XlSaveAsAccessMode.xlNoChange, null, null, null, null,null);
           newXls.Application.Quit();
*/

 

//获得所有的sheet
/*
           public string GetExcelSheetName(string path1)
           {
           string tableName = null;
           if (File.Exists(path1))
           {
           using (OleDbConnection conn = new OleDbConnection("Provider=Microsoft.Jet."+
              "OLEDB.4.0;Extended Properties=/"Excel 8.0/";Data Source=" + path1))
           {
           conn.Open();
           DataTable dt = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, null);
           for(int i=0;i<dt.Rows.Count;i++)
           {
           tableName+=dt.Rows[i][2].ToString().Trim()+";";
           }
           }
           }
           return tableName;
           }
*/