在mvc4中上传、导入和导出excel表方法总结

最新推荐文章于 2024-08-27 14:45:25 发布
最新推荐文章于 2024-08-27 14:45:25 发布
阅读量196 收藏
点赞数
文章标签： 测试 json javascript ViewUI
原文链接：http://www.cnblogs.com/lunawzh/p/7966214.html
版权

通过excel的导入导出练习，使用NPOI组件还是方便一点，所有下面就以NPOI下的导入导出给出实例，通过网页导入excel表，首先上传，再导入数据到库，这里为了方便就不导入到库中了，直接拿到数据。导出方法比较多。

 

第一步下载NPOI组件，并在VS中导入dll.

第二步：为了方便，把功能提取成方法:

1 集合与DataTable间的相互转换创建类

public static class DataTableTool
    {
        /// <summary>    

        /// 转化一个DataTable    

        /// </summary>    

        /// <typeparam name="T"></typeparam>    
        /// <param name="list"></param>    
        /// <returns></returns>    
        public static DataTable ToDataTable<T>(this IEnumerable<T> list)
        {

            //创建属性的集合    
            List<PropertyInfo> pList = new List<PropertyInfo>();
            //获得反射的入口    

            Type type = typeof(T);
            DataTable dt = new DataTable();
            //把所有的public属性加入到集合 并添加DataTable的列    
            Array.ForEach<PropertyInfo>(type.GetProperties(), p => { pList.Add(p); dt.Columns.Add(p.Name, p.PropertyType); });
            foreach (var item in list)
            {
                //创建一个DataRow实例    
                DataRow row = dt.NewRow();
                //给row 赋值    
                pList.ForEach(p => row[p.Name] = p.GetValue(item, null));
                //加入到DataTable    
                dt.Rows.Add(row);
            }
            return dt;
        }


        /// <summary>    
        /// DataTable 转换为List 集合    
        /// </summary>    
        /// <typeparam name="TResult">类型</typeparam>    
        /// <param name="dt">DataTable</param>    
        /// <returns></returns>    
        public static List<T> ToList<T>(this DataTable dt) where T : class, new()
        {
            //创建一个属性的列表    
            List<PropertyInfo> prlist = new List<PropertyInfo>();
            //获取TResult的类型实例  反射的入口    

            Type t = typeof(T);

            //获得TResult 的所有的Public 属性 并找出TResult属性和DataTable的列名称相同的属性(PropertyInfo) 并加入到属性列表     
            Array.ForEach<PropertyInfo>(t.GetProperties(), p => { if (dt.Columns.IndexOf(p.Name) != -1) prlist.Add(p); });

            //创建返回的集合    

            List<T> oblist = new List<T>();

            foreach (DataRow row in dt.Rows)
            {
                //创建TResult的实例    
                T ob = new T();
                //找到对应的数据  并赋值    
                prlist.ForEach(p => { if (row[p.Name] != DBNull.Value) p.SetValue(ob, row[p.Name], null); });
                //放入到返回的集合中.    
                oblist.Add(ob);
            }
            return oblist;
        }




        /// <summary>    
        /// 将集合类转换成DataTable    
        /// </summary>    
        /// <param name="list">集合</param>    
        /// <returns></returns>    
        public static DataTable ToDataTableTow(IList list)
        {
            DataTable result = new DataTable();
            if (list.Count > 0)
            {
                PropertyInfo[] propertys = list[0].GetType().GetProperties();

                foreach (PropertyInfo pi in propertys)
                {
                    result.Columns.Add(pi.Name, pi.PropertyType);
                }
                for (int i = 0; i < list.Count; i++)
                {
                    ArrayList tempList = new ArrayList();
                    foreach (PropertyInfo pi in propertys)
                    {
                        object obj = pi.GetValue(list[i], null);
                        tempList.Add(obj);
                    }
                    object[] array = tempList.ToArray();
                    result.LoadDataRow(array, true);
                }
            }
            return result;
        }


        /**/

        /// <summary>    
        /// 将泛型集合类转换成DataTable    

        /// </summary>    
        /// <typeparam name="T">集合项类型</typeparam>    

        /// <param name="list">集合</param>    
        /// <returns>数据集(表)</returns>    
        public static DataTable ToDataTable<T>(IList<T> list)
        {
            return ToDataTable<T>(list, null);

        }


        /**/

        /// <summary>    
        /// 将泛型集合类转换成DataTable    
        /// </summary>    
        /// <typeparam name="T">集合项类型</typeparam>    
        /// <param name="list">集合</param>    
        /// <param name="propertyName">需要返回的列的列名</param>    
        /// <returns>数据集(表)</returns>    
        public static DataTable ToDataTable<T>(IList<T> list, params string[] propertyName)
        {
            List<string> propertyNameList = new List<string>();
            if (propertyName != null)
                propertyNameList.AddRange(propertyName);
            DataTable result = new DataTable();
            if (list.Count > 0)
            {
                PropertyInfo[] propertys = list[0].GetType().GetProperties();
                foreach (PropertyInfo pi in propertys)
                {
                    if (propertyNameList.Count == 0)
                    {
                        result.Columns.Add(pi.Name, pi.PropertyType);
                    }
                    else
                    {
                        if (propertyNameList.Contains(pi.Name))
                            result.Columns.Add(pi.Name, pi.PropertyType);
                    }
                }

                for (int i = 0; i < list.Count; i++)
                {
                    ArrayList tempList = new ArrayList();
                    foreach (PropertyInfo pi in propertys)
                    {
                        if (propertyNameList.Count == 0)
                        {
                            object obj = pi.GetValue(list[i], null);
                            tempList.Add(obj);
                        }
                        else
                        {
                            if (propertyNameList.Contains(pi.Name))
                            {
                                object obj = pi.GetValue(list[i], null);
                                tempList.Add(obj);
                            }
                        }
                    }
                    object[] array = tempList.ToArray();
                    result.LoadDataRow(array, true);
                }
            }
            return result;
        }  
    }

 

2 excel导入导出类

public static class ExcelTool
    { /// <summary>
        /// 将excel中的数据导入到DataTable中
        /// </summary>
        /// <param name="isFirstRowColumn">第一行是否是DataTable的列名</param>
        /// <param name="fileName">文件路径</param>
        /// <param name="sheetName">excel工作薄sheet的名称</param>
        /// <returns>返回的DataTable</returns>
        public static DataTable ExcelToDataTable(bool isFirstRowColumn, string fileName, string sheetName = "")
        {
            if (string.IsNullOrEmpty(fileName))
            {
                throw new ArgumentNullException(fileName);
            }
            var data = new DataTable();
            IWorkbook workbook = null;
            FileStream fs = null;
            try
            {
                fs = new FileStream(fileName, FileMode.Open, FileAccess.Read);
                if (fileName.IndexOf(".xlsx", StringComparison.Ordinal) > 0)
                {
                    workbook = new XSSFWorkbook(fs);
                }
                else if (fileName.IndexOf(".xls", StringComparison.Ordinal) > 0)
                {
                    workbook = new HSSFWorkbook(fs);
                }

                ISheet sheet = null;
                if (workbook != null)
                {
                    //如果没有找到指定的sheetName对应的sheet，则尝试获取第一个sheet
                    if (sheetName == "")
                    {
                        sheet = workbook.GetSheetAt(0);
                    }
                    else
                    {
                        sheet = workbook.GetSheet(sheetName) ?? workbook.GetSheetAt(0);
                    }
                }
                if (sheet == null) return data;
                var firstRow = sheet.GetRow(0);
                //一行最后一个cell的编号 即总的列数
                int cellCount = firstRow.LastCellNum;
                int startRow;
                if (isFirstRowColumn)
                {
                    for (int i = firstRow.FirstCellNum; i < cellCount; ++i)
                    {
                        var cell = firstRow.GetCell(i);
                        var cellValue = cell.StringCellValue;
                        if (cellValue == null) continue;
                        var column = new DataColumn(cellValue);
                        data.Columns.Add(column);
                    }
                    startRow = sheet.FirstRowNum + 1;
                }
                else
                {
                    startRow = sheet.FirstRowNum;
                }
                //最后一列的标号
                var rowCount = sheet.LastRowNum;
                for (var i = startRow; i <= rowCount; ++i)
                {
                    var row = sheet.GetRow(i);
                    //没有数据的行默认是null
                    if (row == null) continue;
                    var dataRow = data.NewRow();
                    for (int j = row.FirstCellNum; j < cellCount; ++j)
                    {
                        //同理，没有数据的单元格都默认是null
                        if (row.GetCell(j) != null)
                            dataRow[j] = row.GetCell(j).ToString();
                    }
                    data.Rows.Add(dataRow);
                }

                return data;
            }
            catch (IOException ioex)
            {
                throw new IOException(ioex.Message);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if (fs != null)
                {
                    fs.Close();
                }
            }
        }
        /// <summary>
        /// 将DataTable数据导入到excel中
        /// </summary>
        /// <param name="data">要导入的数据</param>
        /// <param name="isColumnWritten">DataTable的列名是否要导入</param>
        /// <param name="sheetName">要导入的excel的sheet的名称</param>
        /// <param name="fileName">文件夹路径</param>
        /// <returns>导入数据行数(包含列名那一行)</returns>
        public static int DataTableToExcel(DataTable data, string sheetName, bool isColumnWritten, string fileName)
        {
            if (data == null)
            {
                throw new ArgumentNullException("data");
            }
            if (string.IsNullOrEmpty(sheetName))
            {
                throw new ArgumentNullException(sheetName);
            }
            if (string.IsNullOrEmpty(fileName))
            {
                throw new ArgumentNullException(fileName);
            }
            IWorkbook workbook = null;
            if (fileName.IndexOf(".xlsx", StringComparison.Ordinal) > 0)
            {
                workbook = new XSSFWorkbook();
            }
            else if (fileName.IndexOf(".xls", StringComparison.Ordinal) > 0)
            {
                workbook = new HSSFWorkbook();
            }

            FileStream fs = null;
            try
            {
                fs = new FileStream(fileName, FileMode.OpenOrCreate, FileAccess.ReadWrite);
                ISheet sheet;
                if (workbook != null)
                {
                    sheet = workbook.CreateSheet(sheetName);
                }
                else
                {
                    return -1;
                }

                int j;
                int count;
                //写入DataTable的列名，写入单元格中
                if (isColumnWritten)
                {
                    var row = sheet.CreateRow(0);
                    for (j = 0; j < data.Columns.Count; ++j)
                    {
                        row.CreateCell(j).SetCellValue(data.Columns[j].ColumnName);
                    }
                    count = 1;
                }
                else
                {
                    count = 0;
                }
                //遍历循环datatable具体数据项
                int i;
                for (i = 0; i < data.Rows.Count; ++i)
                {
                    var row = sheet.CreateRow(count);
                    for (j = 0; j < data.Columns.Count; ++j)
                    {
                        row.CreateCell(j).SetCellValue(data.Rows[i][j].ToString());
                    }
                    ++count;
                }
                //将文件流写入到excel
                workbook.Write(fs);
                return count;
            }
            catch (IOException ioex)
            {
                throw new IOException(ioex.Message);
            }
            catch (Exception ex)
            {
                throw new Exception(ex.Message);
            }
            finally
            {
                if (fs != null)
                {
                    fs.Close();
                }
            }
        }
    }

第三步：下面开始做一个很简单的网页来展示导入与导出，还有数据的显示页面。页面中使用Vue

@{
    Layout = null;
}
<!DOCTYPE html>
<html>
<head>
    <meta name="viewport" content="width=device-width" />
    <title>Index</title>
    <script src="~/Scripts/jquery-3.2.1.min.js"></script>
    <script src="~/Scripts/vue.js"></script>
    <script src="~/Scripts/axios.min.js"></script>
    <style>
        td{
            padding:1rem;
        }
    </style>
</head>
<body >
    <div id="app">

        <form id="myform">
            <table border="1">
                <tr>
                    <td>导入</td>
                    <td>
                        <input type="file" name="fileup" id="fileup" v-on:change="fileChange()" style="display:none"/>
                        <img src="/content/images/upload.png" v-on:click="upclick()">
                    </td>
                </tr>
            </table>
        </form>
        <table>
            <tr v-for="item in list">
                <td>{{item.No}}</td>
                <td>{{item.Name}}</td>
                <td>{{item.Age}}</td>
                <td>{{item.Sex}}</td>
            </tr>
        </table>
        <br />
        <a  href="/home/export">转成excel</a>
    </div>

    <script>

        var app = new Vue({
            el: "#app",
            data: {
                list: [],
            },
            methods: {
                downExcel: function () {
                    $.post("", {},function (res) {
                       
                    });
                },
                upclick:function(){
                    document.getElementById("fileup").click();
                },
                fileChange: function () {
                    
                    if (!document.getElementById("fileup").files[0].size) return;

                    var obj = new FormData(document.getElementById("myform"));
                    obj.append("name", "wzh");
                    var _this = this;
                    $.ajax({
                        type: 'post',
                        url: '/home/Import',
                        data: obj,
                        cache: false,
                        processData: false, // 不处理发送的数据，因为data值是Formdata对象，不需要对数据做处理
                        contentType: false, // 不设置Content-type请求头
                        success: function (data) {
                            if (data != "no") {
                                _this.list = data;
                            } else {
                                alert(data);
                            }
                        },
                    });
                },
            }
        })

    </script>
</body>
</html>

第四步：actionresult的完成

上传与导入：

 public ActionResult Import()
        {
            try
            {
                HttpPostedFileBase uploadfile = Request.Files["fileup"];
                if (uploadfile == null)
                {
                    return Content("no:非法上传");
                }
                if (uploadfile.FileName == "")
                {
                    return Content("no:请选择文件");
                }

                string fileExt = Path.GetExtension(uploadfile.FileName);
                StringBuilder sbtime = new StringBuilder();
                sbtime.Append(DateTime.Now.Year).Append(DateTime.Now.Month).Append(DateTime.Now.Day).Append(DateTime.Now.Hour).Append(DateTime.Now.Minute).Append(DateTime.Now.Second);
                string dir = "/UploadFile/" + sbtime.ToString() + fileExt;
                string realfilepath = Request.MapPath(dir);
                string readDir = Path.GetDirectoryName(realfilepath);
                if (!Directory.Exists(readDir))
                    Directory.CreateDirectory(readDir);

                uploadfile.SaveAs(realfilepath);
                //提取数据 

                var dt =ExcelTool.ExcelToDataTable(true, realfilepath);
                List<User> list = new List<User>();
                foreach (DataRow item in dt.Rows)
                {
                    list.Add(new User()
                    {
                        No = Convert.ToInt32(item[0]),
                        Name = item[1].ToString(),
                        Age = Convert.ToInt32(item[2]),
                        Sex = item[3].ToString()
                    });
                }

                return Json(list,JsonRequestBehavior.AllowGet);
            }
            catch (Exception ex)
            {
                return Content(ex.Message);
            }
        }

导出：

  public ActionResult export()
        {
            var path = Server.MapPath(@"/content/user.xlsx");

            var dt = ExcelTool.ExcelToDataTable(true, path);
            List<User> list = new List<User>();
            foreach (DataRow item in dt.Rows)
            {
                list.Add(new User()
                {
                    No = Convert.ToInt32(item[0]),
                    Name = item[1].ToString(),
                    Age = Convert.ToInt32(item[2]),
                    Sex = item[3].ToString()
                });
            }

            //datatable
            //DataTable d = new DataTable();
            //d.Columns.Add("No");
            //d.Columns.Add("Name");
            //d.Columns.Add("Age");
            //d.Columns.Add("Sex");
            //foreach (var item in list)
            //{
            //    d.NewRow();
            //    d.Rows.Add(new object[]{item.No,item.Name,item.Age,item.Sex});
            //}
            //创建生成的excel的名称
            StringBuilder sbtime = new StringBuilder();
            sbtime.Append(DateTime.Now.Year).Append(DateTime.Now.Month).Append(DateTime.Now.Day).Append(DateTime.Now.Hour).Append(DateTime.Now.Minute).Append(DateTime.Now.Second);
               
            var d = DataTableTool.ToDataTableTow(list);
            var url = "/downfile/"+sbtime+".xls";
            var newpath = Server.MapPath(url);
            ExcelTool.DataTableToExcel(d, "aa", true, newpath);
            //取到生成的名称
            var name=Path.GetFileName(newpath);
            return File(newpath, "application/vnd.ms-excel",name);
        }

 

 

这样就完成此次的功能，下面补充几个知识点，

1、File中的参数contentType有

扩展名类型/子类型
 application/octet-stream
323text/h323
acxapplication/internet-property-stream
aiapplication/postscript
aifaudio/x-aiff
aifcaudio/x-aiff
aiffaudio/x-aiff
asfvideo/x-ms-asf
asrvideo/x-ms-asf
asxvideo/x-ms-asf
auaudio/basic
avivideo/x-msvideo
axsapplication/olescript
bastext/plain
bcpioapplication/x-bcpio
binapplication/octet-stream
bmpimage/bmp
ctext/plain
catapplication/vnd.ms-pkiseccat
cdfapplication/x-cdf
cerapplication/x-x509-ca-cert
classapplication/octet-stream
clpapplication/x-msclip
cmximage/x-cmx
codimage/cis-cod
cpioapplication/x-cpio
crdapplication/x-mscardfile
crlapplication/pkix-crl
crtapplication/x-x509-ca-cert
cshapplication/x-csh
csstext/css
dcrapplication/x-director
derapplication/x-x509-ca-cert
dirapplication/x-director
dllapplication/x-msdownload
dmsapplication/octet-stream
docapplication/msword
dotapplication/msword
dviapplication/x-dvi
dxrapplication/x-director
epsapplication/postscript
etxtext/x-setext
evyapplication/envoy
exeapplication/octet-stream
fifapplication/fractals
flrx-world/x-vrml
gifimage/gif
gtarapplication/x-gtar
gzapplication/x-gzip
htext/plain
hdfapplication/x-hdf
hlpapplication/winhlp
hqxapplication/mac-binhex40
htaapplication/hta
htctext/x-component
htmtext/html
htmltext/html
htttext/webviewhtml
icoimage/x-icon
iefimage/ief
iiiapplication/x-iphone
insapplication/x-internet-signup
ispapplication/x-internet-signup
jfifimage/pipeg
jpeimage/jpeg
jpegimage/jpeg
jpgimage/jpeg
jsapplication/x-javascript
latexapplication/x-latex
lhaapplication/octet-stream
lsfvideo/x-la-asf
lsxvideo/x-la-asf
lzhapplication/octet-stream
m13application/x-msmediaview
m14application/x-msmediaview
m3uaudio/x-mpegurl
manapplication/x-troff-man
mdbapplication/x-msaccess
meapplication/x-troff-me
mhtmessage/rfc822
mhtmlmessage/rfc822
midaudio/mid
mnyapplication/x-msmoney
movvideo/quicktime
movievideo/x-sgi-movie
mp2video/mpeg
mp3audio/mpeg
mpavideo/mpeg
mpevideo/mpeg
mpegvideo/mpeg
mpgvideo/mpeg
mppapplication/vnd.ms-project
mpv2video/mpeg
msapplication/x-troff-ms
mvbapplication/x-msmediaview
nwsmessage/rfc822
odaapplication/oda
p10application/pkcs10
p12application/x-pkcs12
p7bapplication/x-pkcs7-certificates
p7capplication/x-pkcs7-mime
p7mapplication/x-pkcs7-mime
p7rapplication/x-pkcs7-certreqresp
p7sapplication/x-pkcs7-signature
pbmimage/x-portable-bitmap
pdfapplication/pdf
pfxapplication/x-pkcs12
pgmimage/x-portable-graymap
pkoapplication/ynd.ms-pkipko
pmaapplication/x-perfmon
pmcapplication/x-perfmon
pmlapplication/x-perfmon
pmrapplication/x-perfmon
pmwapplication/x-perfmon
pnmimage/x-portable-anymap
pot,application/vnd.ms-powerpoint
ppmimage/x-portable-pixmap
ppsapplication/vnd.ms-powerpoint
pptapplication/vnd.ms-powerpoint
prfapplication/pics-rules
psapplication/postscript
pubapplication/x-mspublisher
qtvideo/quicktime
raaudio/x-pn-realaudio
ramaudio/x-pn-realaudio
rasimage/x-cmu-raster
rgbimage/x-rgb
rmiaudio/mid
roffapplication/x-troff
rtfapplication/rtf
rtxtext/richtext
scdapplication/x-msschedule
scttext/scriptlet
setpayapplication/set-payment-initiation
setregapplication/set-registration-initiation
shapplication/x-sh
sharapplication/x-shar
sitapplication/x-stuffit
sndaudio/basic
spcapplication/x-pkcs7-certificates
splapplication/futuresplash
srcapplication/x-wais-source
sstapplication/vnd.ms-pkicertstore
stlapplication/vnd.ms-pkistl
stmtext/html
svgimage/svg+xml
sv4cpioapplication/x-sv4cpio
sv4crcapplication/x-sv4crc
swfapplication/x-shockwave-flash
tapplication/x-troff
tarapplication/x-tar
tclapplication/x-tcl
texapplication/x-tex
texiapplication/x-texinfo
texinfoapplication/x-texinfo
tgzapplication/x-compressed
tifimage/tiff
tiffimage/tiff
trapplication/x-troff
trmapplication/x-msterminal
tsvtext/tab-separated-values
txttext/plain
ulstext/iuls
ustarapplication/x-ustar
vcftext/x-vcard
vrmlx-world/x-vrml
wavaudio/x-wav
wcmapplication/vnd.ms-works
wdbapplication/vnd.ms-works
wksapplication/vnd.ms-works
wmfapplication/x-msmetafile
wpsapplication/vnd.ms-works
wriapplication/x-mswrite
wrlx-world/x-vrml
wrzx-world/x-vrml
xafx-world/x-vrml
xbmimage/x-xbitmap
xlaapplication/vnd.ms-excel
xlcapplication/vnd.ms-excel
xlmapplication/vnd.ms-excel
xlsapplication/vnd.ms-excel
xltapplication/vnd.ms-excel
xlwapplication/vnd.ms-excel
xofx-world/x-vrml
xpmimage/x-xpixmap
xwdimage/x-xwindowdump
zapplication/x-compress
zipapplication/zip

 

2、导出方法还有：

    public FileResult ExportExcel()  
    {  
        var sbHtml = new StringBuilder();  
        sbHtml.Append("<table border='1' cellspacing='0' cellpadding='0'>");  
        sbHtml.Append("<tr>");  
        var lstTitle = new List<string> { "编号", "姓名", "年龄", "创建时间" };  
        foreach (var item in lstTitle)  
        {  
            sbHtml.AppendFormat("<td style='font-size: 14px;text-align:center;background-color: #DCE0E2; font-weight:bold;' height='25'>{0}</td>", item);  
        }  
        sbHtml.Append("</tr>");  
      
        for (int i = 0; i < 1000; i++)  
        {  
            sbHtml.Append("<tr>");  
            sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", i);  
            sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>屌丝{0}号</td>", i);  
            sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", new Random().Next(20, 30) + i);  
            sbHtml.AppendFormat("<td style='font-size: 12px;height:20px;'>{0}</td>", DateTime.Now);  
            sbHtml.Append("</tr>");  
        }  
        sbHtml.Append("</table>");  
      
        //第一种:使用FileContentResult  
        byte[] fileContents = Encoding.Default.GetBytes(sbHtml.ToString());  
        return File(fileContents, "application/ms-excel", "fileContents.xls");  
      
        //第二种:使用FileStreamResult  
        var fileStream = new MemoryStream(fileContents);  
        return File(fileStream, "application/ms-excel", "fileStream.xls");  
      
        //第三种:使用FilePathResult  
        //服务器上首先必须要有这个Excel文件,然会通过Server.MapPath获取路径返回.  
        var fileName = Server.MapPath("~/Files/fileName.xls");  
        return File(fileName, "application/ms-excel", "fileName.xls");  
    }

 

导出文件名有问题可以看这里

http://blog.csdn.net/denghejing/article/details/60753205

 

转载于:https://www.cnblogs.com/lunawzh/p/7966214.html

weixin_34144848
关注
  • 0
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MVC实现Excel的导入导出
hjb_nice的博客
08-09 792
MVC实现Excel的导入导出 读取 Excel，相应的方法有： //获取文件流 InputStream is = new FileInputStream(file); //得到Excel工作簿对象 XSSFWorkbook xssfWorkbook = new XSSFWorkbook(is); //得到Excel工作表对象 XSSFSheet xssfSheet = xssfWorkbook.getSheetAt(0); //得到Excel工作表的指定行对象 XSSFRow xssfRow = xssf
spring mvc中导入导出excel
JRpro0814的博客
10-20 257
POI介绍 Apache POI是Apache软件基金会的开源项目，POI提供API给Java程序对Microsoft Office格式档案读和写的功能 导入jar包：poi-4.1.2.jar，xwork-core-2.3.15.3.jar 1、写excel package excel; import org.apache.poi.hssf.usermodel.HSSFCell; import org.apache.poi.hssf.usermodel.HSSFRow; import org.apac
MVC简单的导入功能
03-01
mvc简单的导入功能包含前后端和js方便简单易用下载后复制粘贴即可使用（ /// 上传Excel短信联系人 /// 创建者：周石荣）
MVC4.0 上传Excel并存入数据库
weixin_30352645的博客
06-20 119
这里的这个功能实现在WebForm很好实现，上传阶段简单的一个FileUoLoad控件就搞定了，什么取值，什么上传都是浮云，微软都帮我们封装好了，我们只需要一拖一拽就OK了，但这些在MVC中是不行的！ MVC实现了显示和控制的分离就不可能再使用服务端控件了，所以我们就又回到了原始的表单提交，AJAX异步提交数据什么的，不多说直接上代码,简单的写一下 View： ...
ASP.NET MVC4上传文件，并将excel内容导入数据库，导入后删除文件
kwb690632917的博客
10-14 4281
关于ASP.Net MVC直接在控制器书写方法！废话不多少，直接上代码！  public ActionResult MoreInput(HttpPostedFileBase uploadFile)         {                          if (uploadFile != null)             {                 if (up
Mvc导入
Unknowncheats的博客
05-03 74
[HttpPost] public void Import() { //获取文件 HttpPostedFileBase fileBase = Request.Files["file"]; if(fileBase==null) { 　　Response.Write(""); } //转数据流 Stream stream = fileBase.InputStream; IWorkbo...
MVC导入
大猴子的专栏
09-21 449
1、点击导入按钮 2、   //打开dialog 与处理导入Excel        function ImportExcel()        {            $("#ImportExcel").show();            $("#ImportExcel").dialog({                title: "导入车型",
MVC导入与导出excel文件
07-01
在MVC架构下，处理导入和导出Excel文件是常见的需求，尤其在数据管理、报表生成以及数据交换场景中。下面我们将详细探讨如何在MVC应用中实现这个功能。 首先，导入Excel文件涉及到读取Excel数据并将其转化为可操作...
MVC开发的导入导出Excel文件
11-16
这就是在MVC中实现Excel导入导出的基本步骤。为了提高用户体验，你还可以添加错误处理和进度显示。同时，注意处理大文件以避免内存问题，可能需要分批读取或使用流处理。在实际项目中，你还需要考虑数据验证、权限...
.Net Mvc之NPOI Excel数据导出和批量导入功能实现
05-03
在我们的实践开发中我们经常会遇到很多关于报表问题的数据展示，当然了有报表肯定是少不了数据的导出和导入的一些功能的啦，我这个demo就是专门使用nopi第三方库对excel的数据批量导入和数据导出的相关功能实现。
mvc npoi 导入导出Demo
08-19
mvc npoi excel 导入导出 Demo
C# asp.net导入和导出excel完整源码
11-28
在C# ASP.NET开发中，导入和导出Excel文件是一项常见的需求，这通常涉及到与数据库交互，以便将数据从数据库导出到Excel表格或者从Excel表格导入到数据库中。本项目提供了一个完整的实例代码，可以帮助开发者快速...
使用EasyPoi轻松导入导出Excel文档的方法示例
08-25
EasyPoi轻松导入导出Excel文档的方法示例 EasyPoi是一个功能强大、使用简单的Excel处理工具，能够轻松地导入和导出Excel文档。它的主要特点是设计精巧、使用简单、接口丰富、扩展简单、默认值多、支持Spring MVC等...
mvc导入导出
weixin_30839881的博客
03-11 154
publicclassExcelController:Controller { // //GET:/Excel/ Models.zbwxglEntitiesmyMdl=newModels.zbwxglEntities(); ///<summary> ...
mvc 导入excel
qq_41638562的博客
06-04 488
https://blog.csdn.net/jinwufeiyang/article/details/52216218
MVC 导入excel
小发发吖的博客
08-01 446
/// /// 导入excel /// /// public ActionResult Import() { HttpPostedFileBase file = Request.Files["excel"]; //1、先保存上传的excel文件（这一步与上传图片流程
MVC excel导入
u014392988的博客
09-14 248
MVC excel导入view部分 代码 @{ Layout = "~/Views/Shared/_LayoutPage1.cshtml"; ViewBag.Title = "Index"; } <script src="~/scripts/jquery-1.10.2.js"></script> <link rel="stylesheet" href="~/Content/kd.c
从MVC中导入数据库
weixin_44540773的博客
04-07 788
从MVC中导入数据库 开发工具与关键技术：MVC 作者：赵纯雨 班级：1804 撰写时间：2019.04.11 在学习MVC的时候，学会如何去创建文件夹，在第一天学习MVC的时候，在连接数据库的时候，遇到了一个问题，就是在创建model的时候，它会在web.config当中自动生成一串代码，如下图： （以上代码太长，我把它分...
软件测试学习笔记丨Pytest配置文件
最新发布
ceshiren_com的博客
08-27 3060
pytest.ini是pytest的配置文件；可以修改pytest的默认行为；不能使用任何中文符号，包括汉字、空格、引号、冒号等。
Java使用Easypoi操作Excel：导入与导出
easypoi-annotation用于注解支持，easypoi-base主要处理导入导出功能，而easypoi-web则与Spring MVC集成，简化了在Web环境中的导出操作。" Easypoi是一个强大的Java工具包，专门用于处理Excel的导入和导出任务。在...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值