C# 读取excel

最新推荐文章于 2024-03-26 07:30:00 发布

测试接口

最新推荐文章于 2024-03-26 07:30:00 发布

阅读量369

点赞数

分类专栏： C#

本文链接：https://blog.csdn.net/xinyanan1992/article/details/53996117

版权

C# 专栏收录该内容

16 篇文章 0 订阅

订阅专栏

public  DataSet GetWorkbook(string filename)
        {
            DataSet ds = new DataSet();
            Microsoft.Office.Interop.Excel.Application app = new Microsoft.Office.Interop.Excel.Application();    //初始化Excel对象
            app.Visible = false;
            app.DisplayAlerts = false;
            object missing = System.Reflection.Missing.Value;
            Microsoft.Office.Interop.Excel.Workbook wb;
            try
            {
                wb = app.Workbooks.Open(filename, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing, missing);
            }
            catch (Exception ex)
            {
                MessageBox.Show(ex.ToString());
                throw;
            }
            foreach (Microsoft.Office.Interop.Excel.Worksheet ws in wb.Sheets)
            {
                ds.Tables.Add(GetWorksheet(ws));
            }
            app.Workbooks.Close();
            app.Quit();
            return ds;
        }
        public  DataTable GetWorksheet(Microsoft.Office.Interop.Excel.Worksheet ws)
        {
            DataTable dt = new DataTable();
            dt.TableName = ws.Name;

            int row = ws.UsedRange.Rows.Count + 1;
            int col = ws.UsedRange.Columns.Count + 1;

            for (int c = 1; c < col; c++)
            {
                dt.Columns.Add("F" + c);
            }

            for (int r = 1; r < row; r++)
            {
                DataRow newRow = dt.NewRow();
                for (int c = 1; c < col; c++)
                {
                    newRow[c - 1] = ((Microsoft.Office.Interop.Excel.Range)ws.Cells[r, c]).Value2;  //问题是不是出在这里，请问怎么解决呢
                }
                dt.Rows.Add(newRow);
            }

            return dt;
        }