读取EXCEL内容

最新推荐文章于 2025-05-15 10:23:45 发布

原创最新推荐文章于 2025-05-15 10:23:45 发布 · 379 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#excel #dataset #string #object #properties #path

c# 专栏收录该内容

23 篇文章

订阅专栏

本文介绍如何使用C#将Excel文件中的数据读取到DataSet中，并将其保存到本地的另一个Excel文件中。

   private void GetExcel()
        {
            string Path = Server.MapPath("Scripts/micr.xls");
            Microsoft.Office.Interop.Excel.Application excelApplication = new Microsoft.Office.Interop.Excel.Application();
            object missing = Missing.Value;
            Microsoft.Office.Interop.Excel.Workbooks workBooks = excelApplication.Workbooks;
            Microsoft.Office.Interop.Excel.Workbook workBook = workBooks.Add(Path);
            Microsoft.Office.Interop.Excel.Sheets sheets = workBook.Worksheets;
            Microsoft.Office.Interop.Excel.Worksheet workSheet = (Microsoft.Office.Interop.Excel.Worksheet)sheets.get_Item(1);
            DataSet ds = new DataSet();           
            string strConn = ("Provider=Microsoft.Jet.OleDb.4.0;" + "data source=") + Path + ";Extended Properties=Excel 8.0;";
            using (OleDbConnection Conn = new OleDbConnection(strConn))
            {
                Conn.Open();
                string strSql = "Select * From [Sheet1$]";
                OleDbCommand Cmd = new OleDbCommand(strSql, Conn);
                OleDbDataAdapter sqlada = new OleDbDataAdapter();
                sqlada.SelectCommand = Cmd;
                sqlada.Fill(ds);
                Conn.Close();
            }
            for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
            {
                if (i == 0)
                {
                    string aa = ds.Tables[0].Rows[i][0].ToString();
                    workSheet.Cells[i + 1, 9] = "";
                    workSheet.Columns.AutoFit();
                    Microsoft.Office.Interop.Excel.Range rang = workSheet.get_Range((object)workSheet.Cells[i+1, 9], (object)workSheet.Cells[i+1, 9]);
                }
                else
                {
                        string aa = ds.Tables[0].Rows[i][0].ToString();
                        workSheet.Cells[i + 1, 9] = "false";
                        workSheet.Columns.AutoFit();
                        Microsoft.Office.Interop.Excel.Range rang = workSheet.get_Range((object)workSheet.Cells[i + 1, 9], (object)workSheet.Cells[i + 1, 9]);
                    

                }
            }
            string homePath = @"C:\Documents and Settings\a507394\Desktop\123.xls";
            workBook.SaveAs(homePath, missing, missing, missing, missing, missing, XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing, missing); 　


        }