基本信息

---

下载

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

---

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

本次赞助数额为： 2 元　

支付宝支付

微信支付

   源码介绍

---

该实例用来统计火车走行的公里数,使用到Excel表格的读取和写入。

        private DataTable ExcelTable2DataTable(string filePath, int columnRowNo, int[] useColumnNo, string[] useColumnName)
        {
            DataTable dt = null;
            DataRow dataRow = null;

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(filePath);

            if (workbook.Worksheets.Count <= 0)
                return null;
            dt = new DataTable();

            Worksheet sheet = workbook.Worksheets[0];
            char ch = 'A';
            string cellName = null;

            dt = new DataTable(sheet.Name);
            for (int i = 0; i < useColumnName.Length; i )
                dt.Columns.Add(new DataColumn(useColumnName[i]));

            for (int i = columnRowNo 1; i <= 100000; i )
            {
                dataRow = dt.NewRow();
                for (int j = 0; j < useColumnNo.Length; j )
                {
                    if (useColumnNo[j] < 0)
                        break;

                    ch = (char)('A' useColumnNo[j] - 1);
                    cellName = ch.ToString() i.ToString();
                    if (sheet.Range[cellName].HasString)
                        dataRow[j] = sheet.Range[cellName].Text;
                    else if (sheet.Range[cellName].HasNumber)
                    {
                        dataRow[j] = (float)sheet.Range[cellName].NumberValue;
                    }
                    else if (sheet.Range[cellName].HasDateTime)
                        dataRow[j] = sheet.Range[cellName].DateTimeValue.ToString();
                    else if (sheet.Range[cellName].HasFormulaDateTime)
                        dataRow[j] = sheet.Range[cellName].FormulaDateTime.ToString();
                    else
                        ;
                }

                if (ExcelTableComeTail(dataRow, useColumnNo.Length))//表结束
                    break;

                dt.Rows.Add(dataRow);
            }

            return dt;
        }