打赏

怎么使用Aspose.Cells读取excel 转化为Datatable

说明：vs2012 asp.net mvc4 c#

        使用Aspose.Cells 读取Excel 转化为Datatable

1、HTML前端代码

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm4.aspx.cs" Inherits="MvcAppTest.WebForm4" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title>获取文件本地路径</title> 
</head>
<body>
    <form action="Home/GetexcelNew" method="post" enctype="multipart/form-data">
        <input type="file" value="" name="files" />
        <input type="submit" value="提交" />
    </form>
</body>
</html>

2、Home控制器后台代码

        [HttpPost]
        public void GetexcelNew(IEnumerable<HttpPostedFileBase> files)
        {
            Int32 count = files.Count();
                foreach (var file in files)
                {
                    if (file != null && file.ContentLength > 0)
                    {
                        string[] picName = file.FileName.Split('.');
                        if (picName[1] == "xls" || picName[1] == "xlsx")
                        {
                            DataTable dt = ReadExcel(file);
                        }
                    }
                }            
        }
    public static System.Data.DataTable ReadExcel(HttpPostedFileBase file)
        {
       
            Workbook book = new Workbook(file.InputStream);  
            
            Worksheet sheet = book.Worksheets[0];
            Cells cells = sheet.Cells;
            return cells.ExportDataTableAsString(0, 0, cells.MaxDataRow + 1, cells.MaxDataColumn + 1, true);
        }

注意：后台代码 要引用：using Aspose.Cells;

3、引用文件下载地址

链接：https://pan.baidu.com/s/1TTcrTIVO4nkC2TH27whFwQ
提取码：2w1j

posted @ 2019-01-16 16:07  学习靠自己  阅读(2521)  评论(0)  编辑  收藏  举报