.Net Core + Aspose.Cells创建和读取Excel(.xls,.xlsx)数据

1.下载

Aspose下载地址：https://products.aspose.com/cells/net

破解版下载地址：https://download.csdn.net/download/wylcy/10389581?utm_source=bbsseo

官方文档地址：https://docs.aspose.com/display/cellsnet/Home

官方Demo代码：https://github.com/aspose-cells/Aspose.Cells-for-.NET

2.用Nuget包安装：

System.Drawing.Common

System.Text.Encoding.CodePages

3.创建Excel文件代码

 public static void SaveExcelData(string path)
        {
            //Aspose.Cells.License li = new Aspose.Cells.License();
            //li.SetLicense("Aspose.Cells.lic");
            Aspose.Cells.Workbook wk = new Aspose.Cells.Workbook();
            Worksheet ws = wk.Worksheets[0];
            for (int i = 0; i < 9; i++)
            {
                for (int j = 0; j < 9; j++)
                {
                    ws.Cells.Rows[i][j].Value = (i + 1) + "*" + (j + 1) + "=" + (i + 1) * (j + 1);
                }
            }
            wk.Save(path);
        }

4.创建Excel文件代码

public static void ReadExcelData(string path)
        {
            DataTable dt = new DataTable();
            //验证license
            //Aspose.Cells.License li = new Aspose.Cells.License();
            //li.SetLicense("Aspose.Cells.lic");
            Aspose.Cells.Workbook wk = new Aspose.Cells.Workbook(path);
            Worksheet ws = wk.Worksheets["人力资源报表"];
            dt = ws.Cells.ExportDataTable(0, 0, ws.Cells.MaxDataRow + 1, ws.Cells.MaxDataColumn + 1);
            for (int k = 1; k < dt.Rows.Count; k++)
            {
                var code = dt.Rows[k][2].ToString();
                var subDept = dt.Rows[k][0].ToString();
                var dept = dt.Rows[k][1].ToString();
                var userName = dt.Rows[k][3].ToString();
                var gender = dt.Rows[k][4].ToString();
                Console.WriteLine($"code={code},subDept={subDept},dept={dept},userName={userName},gender={gender}");
            }
        }

4.1自己写的

public static DataTable ReadExcelData(string path)
        {
            DataTable dt = new DataTable();
            Aspose.Cells.Workbook wk = new Aspose.Cells.Workbook(path);
            Aspose.Cells.Worksheet ws = wk.Worksheets["TC1"];
　　　　　　　//去掉标题行从第2行开始读
            dt = ws.Cells.ExportDataTable(1, 0, ws.Cells.MaxDataRow, ws.Cells.MaxDataColumn + 1);
            return dt;
        }

5、本文项目代码下载

下载地址：https://www.cjavapy.com/download/5c4c4e49dc72d93b685b6f63/

6.文章来源

.Net Core Aspose.Cells创建和读取Excel(.xls,.xlsx)数据-CJavaPy