基本信息

---

下载

   友情提示：（无需注册或充值，赞助后即可获取资源下载链接）

---

     嘿，亲！知识可是无价之宝呢，但咱这精心整理的资料也耗费了不少心血呀。小小地破费一下，绝对物超所值哦！如有下载和支付问题，请联系我们QQ(微信同号)：813200300

本次赞助数额为： 1 元　

支付宝支付

微信支付

   源码介绍

---

导入导出Excel

【/// <summary>
        /// 读取Excel文件到DataSet
  /// </summary>
  /// <param name="path">Excel文件物理路径</param>
        /// /// <param name="sheetWidth">Excel中要读取的Sheet的宽度</param>
  /// <param name="hasTitleRow">是否含有标题列</param>
  /// <returns></returns>
        public DataSet Import(string path,int sheetWidth,bool hasTitleRow)
        {
            Workbook tcWorkBook = new Workbook();
            tcWorkBook.Open(path);
            WorksheetCollection tcWorkSheets = tcWorkBook.Worksheets;
            DataSet ds = new DataSet();
            //遍历此Excel文件中的所有Sheet
            for (int i = 0; i < tcWorkSheets.Count; i )
            {
                Worksheet tcWorkSheet = tcWorkSheets[i];
                Cells tcCells = tcWorkSheet.Cells;
                //如果是空Sheet，跳过
                if (tcCells.Rows.Count == 0 || tcCells.Columns.Count == 0)
                {
                    continue;
                }
                DataTable dt = new DataTable();
                //将此Sheet的单元格中的数据导出到DataTable
                dt = tcCells.ExportDataTable(0, 0, tcCells.Rows.Count, sheetWidth);
                dt.TableName = tcWorkSheet.Name;
                //如果Sheet包含标题行，将此行的数据映射到DataTable的列名
                if (hasTitleRow)
                {
                    for (int m = 0; m < dt.Columns.Count; m )
           {
                        dt.Columns[m].ColumnName = dt.Rows[0][m].ToString();
           }
                    dt.Rows.RemoveAt(0);
                }
                ds.Tables.Add(dt);
            }
            return ds;
        }

 /// <summary>
        /// 导出Excel的方法
        /// </summary>
        /// <param name="dtList"></param>
        /// <param name="title"></param>
        /// <param name="filename"></param>
        public void Export(List<DataTable> dtList, string title, string path)
        {
            path = DisposePath(path);
            Workbook book = new Workbook();
            book.Worksheets.Clear();
            //遍历DataTable的泛型，将所有的DataTable填充到Sheet后保存到Excel文件中
            for (int index = 0; index < dtList.Count; index )
            {
                DataTable dt = dtList[index];
                int sheetCount = 0;
                //如果此DataTable的数据行数大于65536，计算此DataTable需要填充的Sheet的个数
                if (dt.Rows.Count > 65535)
                {
                    if (dt.Rows.Count % 65535 != 0)
                    {
                        sheetCount = Convert.ToInt32(dt.Rows.Count / 65535) 1;
                    }
                    else
                    {
                        sheetCount = Convert.ToInt32(dt.Rows.Count / 65535) / 65535;
                    }
                }
                //需要多Sheet填充的DataTable的导出处理
                if (sheetCount > 1)
                {
                    //将此DataTable按照65536的Excel极限数据行数进行切割导出到多Sheet
                    for (int sheetIndex = 0; sheetIndex < sheetCount; sheetIndex )
                    {
                        Worksheet sheet = book.Worksheets.Add(dt.TableName (index 1).ToString() "_" (sheetIndex 1).ToString());
                        int colCount = dt.Columns.Count;
                        //添加列头标题
                        for (int cIndex = 0; cIndex < colCount; cIndex )
                        {
                            sheet.Cells[0, cIndex].PutValue(dt.Columns[cIndex].ToString());
                        }
                        if (sheetIndex 1 == sheetCount)
                        {
                            //添加每一行的数据
                            for (int rIndex = 0; rIndex < dt.Rows.Count % 65535; rIndex )
                            {
                                for (int cIndex = 0; cIndex < colCount; cIndex )
                                {
                                    sheet.Cells[rIndex 1, cIndex].PutValue(dt.Rows[65535 * sheetIndex rIndex][cIndex].ToString());
                                }
                            }
                        }
                        else
                        {
                            //添加每一行的数据
                            for (int rIndex = 0; rIndex < 65535; rIndex )
                            {
                                for (int cIndex = 0; cIndex < colCount; cIndex )
                                {
                                    sheet.Cells[rIndex 1, cIndex].PutValue(dt.Rows[65535 * sheetIndex rIndex][cIndex].ToString());
                                }
                            }
                        }
                    }
                }
                else//不需要多Sheet填充的DataTable的导出处理
                {
                    Worksheet sheet = book.Worksheets.Add(dt.TableName (index 1).ToString());
                    FillSheet(dt, sheet);
                }
            }
            book.Save(path);
            book = null;
            GC.Collect();
        }】