前端上传Excel到服务器相应文件夹，后台更加文件夹名称获取上传路径，然后导入datatable

最新推荐文章于 2024-07-26 10:04:48 发布
最新推荐文章于 2024-07-26 10:04:48 发布
阅读量646 收藏
点赞数 1
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/grh_168/article/details/85098491
版权

#region 前端选中导入把文件存在服务器上

var formData = new FormData();

formData.append("file", $("#upload")[0].files[0]);

$.ajax({

    url: "https://mxgcrm-api.lvshou.com/Upload/UploadFiles",

    type: 'POST',

    data: formData,

    // 告诉jQuery不要去处理发送的数据

    processData: false,

    // 告诉jQuery不要去设置Content-Type请求头

    contentType: false,

    beforeSend: function() {

        console.log("正在进行，请稍候");

    },

    success: function(responseStr) {

        console.log(responseStr);

    },

    error: function(responseStr) {

        console.log("error");

    }

});

//后端上传文件方法

public MyJsonResult UploadFiles()
        {
            MyJsonResult jsonResult = new MyJsonResult();

            object Data = new { };
            try
            {
                HttpFileCollectionBase filelist = Request.Files;
                string resourceDirectoryName = System.Configuration.ConfigurationManager.AppSettings["uploadUrl"];
                string path = Server.MapPath(resourceDirectoryName);
                if (filelist != null && filelist.Count > 0)
                {
                    for (int i = 0; i < filelist.Count; i++)
                    {
                        HttpPostedFileBase file = filelist[i];
                        string fileName = file.FileName;
                        string ext = Path.GetExtension(fileName);

                        string newFileName = DateTime.Now.ToString("yyyyMMddHHmmssfff") + ext;

                        fileName = Path.Combine(path, newFileName);

                        DirectoryInfo di = new DirectoryInfo(path);
                        if (!di.Exists) { di.Create(); }

                        file.SaveAs(fileName);

                        Data = new { code = ReturnCode.访问成功, msg = ReturnCode.访问成功.ToString(), data = new { fileName = newFileName } };

                    }
                }
                else
                {
                    Data = new { code = ReturnCode.尚未选择文件, msg = ReturnCode.尚未选择文件.ToString(), data = new { fileName = "" } };
                }
            }
            catch (Exception ex)
            {
                Data = new { code = ReturnCode.服务器发生错误, msg = ReturnCode.服务器发生错误.ToString(), data = new { } };
            }

            jsonResult.Data = Data;

            return jsonResult;
        }

#endregion

#region 导入方法

/// <summary>
        /// 导入初级资源(18/07/23 新版本)
        /// </summary>
        /// <param name="Params"></param>
        /// <returns></returns>
        public object ImportResources(string Params)
        {
            try
            {
                Hashtable jd = JsonConvert.DeserializeObject<Hashtable>(Params);
                string FileName = Convert.ToString(jd["fileName"]);
                string fileExt = Path.GetExtension(FileName).ToLower();
                if (fileExt == ".xls" || fileExt == ".xlsx")
                {
                    string resourceDirectoryName = ConfigurationManager.AppSettings["uploadUrl"];
                    string fileName = HttpContext.Current.Server.MapPath(resourceDirectoryName + FileName);
                    DataTable dt = ExcelToTable(fileName);//调用导入datatable方法
                    List<Msg> listMsg = new List<Msg>();
                    //  int rowCount = 0;
                    foreach (DataRow item in dt.Rows)
                    {
                        cinfo = new CustomerResourcesInfo();
                        Msg msg = new Msg();
                        if (item["客户名称"] != null && item["客户名称"].ToString() != "")
                        {
                            cinfo.CustomerName = item["客户名称"].ToString().Trim();
                        }
                        else
                        {
                            if (msg.msgInfo != null && msg.msgInfo != "")
                            {
                                msg.msgInfo = msg.msgInfo + ",";
                            }
                            msg.msgInfo = msg.msgInfo + "客户姓名不能为空";
                        }
                        if (item["客户来源"] != null && item["客户来源"].ToString() != "")
                        {
                            List<V_Category_TypeInfo> listcate = new BaseBLL<V_Category_TypeInfo>().GetList("CategoryID,CategoryName", "IsDelete=0  and KeyName='CustomerSource'", "", null);
                            foreach (var item1 in listcate)
                            {
                                if (item1.CategoryName == item["客户来源"].ToString().Trim())
                                {
                                    cinfo.CustomerSource = item1.CategoryID;
                                }
                            }
                        }
                        else
                        {
                            if (msg.msgInfo != null && msg.msgInfo != "")
                            {
                                msg.msgInfo = msg.msgInfo + ",";
                            }
                            msg.msgInfo = msg.msgInfo + "客户来源不能为空";
                        }
                        if (item["渠道"] != null && item["渠道"].ToString() != "")
                        {
                            if (cinfo.CustomerSource != null)
                            {
                                List<V_Category_TypeInfo> listcate = new BaseBLL<V_Category_TypeInfo>().GetList("CategoryID,CategoryName", "IsDelete=0  and  ParentID=@ParentID", "", new List<DBParameter>() { new DBParameter("@ParentID", cinfo.CustomerSource) });
                                foreach (var item1 in listcate)
                                {
                                    if (item1.CategoryName == item["渠道"].ToString().Trim())
                                    {
                                        cinfo.Channeling = item1.CategoryID;
                                    }
                                }
                            }
                        }
                        else
                        {
                            if (msg.msgInfo != null && msg.msgInfo != "")
                            {
                                msg.msgInfo = msg.msgInfo + ",";
                            }
                            msg.msgInfo = msg.msgInfo + "渠道不能为空";
                        }
                        if (item["关键词"] != null && item["关键词"].ToString() != "")
                        {
                            cinfo.KeyWord = item["关键词"].ToString().Trim();
                        }
                        else
                        {
                            if (msg.msgInfo != null && msg.msgInfo != "")
                            {
                                msg.msgInfo = msg.msgInfo + ",";
                            }
                            msg.msgInfo = msg.msgInfo + "关键词不能为空";
                        }
                        if (item["搜索引擎"] != null && item["搜索引擎"].ToString() != "")
                        {
                            List<V_Category_TypeInfo> listcate = new BaseBLL<V_Category_TypeInfo>().GetList("CategoryID,CategoryName", "IsDelete=0  and KeyName='SearchEngines'", "", null);
                            foreach (var item1 in listcate)
                            {
                                if (item1.CategoryName == item["搜索引擎"].ToString().Trim())
                                {
                                    cinfo.SearchEngine = item1.CategoryID;
                                }
                            }
                        }
                        else
                        {
                            if (msg.msgInfo != null && msg.msgInfo != "")
                            {
                                msg.msgInfo = msg.msgInfo + ",";
                            }
                            msg.msgInfo = msg.msgInfo + "搜索引擎不能为空";
                        }
                        if (item["日期"] != null && item["日期"].ToString() != "")
                        {
                            cinfo.CreateDate = Convert.ToDateTime(item["日期"]);
                        }
                        if (item["跟进状态"] != null && item["跟进状态"].ToString() != "")
                        {
                            List<V_Category_TypeInfo> listcate = new BaseBLL<V_Category_TypeInfo>().GetList("CategoryID,CategoryName", "IsDelete=0  and KeyName='FollowStatus'", "", null);
                            foreach (var item1 in listcate)
                            {
                                if (item1.CategoryName == item["跟进状态"].ToString().Trim())
                                {
                                    cinfo.FollowStatus = item1.CategoryID;
                                }
                            }
                        }
                        if (item["手机"] != null && item["手机"].ToString() != "")
                        {
                            cinfo.Tel = item["手机"].ToString().Trim();
                        }
                        if (item["客户类型"] != null && item["客户类型"].ToString() != "")
                        {
                            List<V_Category_TypeInfo> listcate = new BaseBLL<V_Category_TypeInfo>().GetList("CategoryID,CategoryName", "IsDelete=0  and KeyName='CustomerType'", "", null);
                            foreach (var item1 in listcate)
                            {
                                if (item1.CategoryName == item["客户类型"].ToString().Trim())
                                {
                                    cinfo.CustomerType = item1.CategoryID;
                                }
                            }
                        }
                        if (item["QQ或微信"] != null && item["QQ或微信"].ToString() != "")
                        {
                            cinfo.QQorWeixin = item["QQ或微信"].ToString().Trim();
                        }
                        if (item["网址"] != null && item["网址"].ToString() != "")
                        {
                            cinfo.URL = item["网址"].ToString().Trim();
                        }
                        if (item["备注"] != null && item["备注"].ToString() != "")
                        {
                            cinfo.Remark = item["备注"].ToString().Trim();
                        }
                        if (item["性别"] != null && item["性别"].ToString() != "")
                        {
                            cinfo.Sex = item["性别"].ToString().Trim();
                        }
                        if (item["设备"] != null && item["设备"].ToString() != "")
                        {
                            if (item["设备"].ToString().Trim() == "手机")
                            {
                                cinfo.Store = "1";
                            }
                            else if (item["设备"].ToString().Trim() == "电脑")
                            {
                                cinfo.Store = "2";
                            }
                        }
                        if (item["邮箱地址"] != null && item["邮箱地址"].ToString() != "")
                        {
                            cinfo.EmailAddress = item["邮箱地址"].ToString().Trim();
                        }
                        if (item["有无店铺"] != null && item["有无店铺"].ToString() != "")
                        {
                            if (item["有无店铺"].ToString().Trim() == "有")
                            {
                                cinfo.Store = "1";
                            }
                            else if (item["有无店铺"].ToString().Trim() == "无")
                            {
                                cinfo.Store = "2";
                            }
                        }
                        if (item["店铺名称"] != null && item["店铺名称"].ToString() != "")
                        {
                            cinfo.StoreName = item["店铺名称"].ToString().Trim();
                        }
                        if (item["邮编"] != null && item["邮编"].ToString() != "")
                        {
                            cinfo.PostCode = item["邮编"].ToString().Trim();
                        }
                        if (item["省份"] != null && item["省份"].ToString() != "")
                        {
                            RegionInfo rinfo = new Region().GetModel("", "District=@District and Level=1", "", new List<DBParameter>() { new DBParameter("@District", item["省份"].ToString().Trim()) });
                            if (rinfo != null && rinfo.District_id != null)
                            {
                                cinfo.Province = rinfo.District_id;
                                if (item["城市"] != null && item["城市"].ToString() != "")
                                {
                                    RegionInfo rinfoCity = new Region().GetModel("", "District=@District and Level=2", "", new List<DBParameter>() { new DBParameter("@District", item["城市"].ToString().Trim()) });
                                    if (rinfoCity != null && rinfoCity.District_id != null && !string.IsNullOrEmpty(cinfo.Province))
                                    {
                                        if (rinfoCity.Pid != null && rinfoCity.Pid == cinfo.Province)
                                        {
                                            cinfo.City = rinfoCity.District_id;
                                            if (item["县/区"] != null && item["县/区"].ToString() != "")
                                            {
                                                RegionInfo rinfoCounty = new Region().GetModel("", "District=@District and Level=3", "", new List<DBParameter>() { new DBParameter("@District", item["县/区"].ToString().Trim()) });
                                                if (rinfoCounty != null && rinfoCounty.District_id != null && !string.IsNullOrEmpty(cinfo.City))
                                                {
                                                    if (rinfoCounty.Pid != null && rinfoCounty.Pid == cinfo.City)
                                                    {
                                                        cinfo.County = rinfoCounty.District_id;
                                                    }
                                                    else
                                                    {
                                                        if (msg.msgInfo != null && msg.msgInfo != "")
                                                        {
                                                            msg.msgInfo = msg.msgInfo + ",";
                                                        }
                                                        msg.msgInfo = msg.msgInfo + item["省份"] + "不属于" + item["县/区"];
                                                    }

                                                }
                                                else
                                                {
                                                    if (msg.msgInfo != null && msg.msgInfo != "")
                                                    {
                                                        msg.msgInfo = msg.msgInfo + ",";
                                                    }
                                                    msg.msgInfo = msg.msgInfo + "找不到" + item["县 / 区"].ToString();
                                                }
                                            }
                                        }
                                        else
                                        {
                                            if (msg.msgInfo != null && msg.msgInfo != "")
                                            {
                                                msg.msgInfo = msg.msgInfo + ",";
                                            }
                                            msg.msgInfo = msg.msgInfo + item["城市"] + "不属于" + item["省份"];
                                        }
                                    }
                                    else
                                    {
                                        if (msg.msgInfo != null && msg.msgInfo != "")
                                        {
                                            msg.msgInfo = msg.msgInfo + ",";
                                        }
                                        msg.msgInfo = msg.msgInfo + "找不到" + item["城市"].ToString();
                                    }
                                }

                            }
                            else
                            {
                                if (msg.msgInfo != null && msg.msgInfo != "")
                                {
                                    msg.msgInfo = msg.msgInfo + ",";
                                }
                                msg.msgInfo = msg.msgInfo + "找不到" + item["省份"].ToString();
                            }
                        }
                        if (string.IsNullOrEmpty(cinfo.Tel) && string.IsNullOrEmpty(cinfo.QQorWeixin))
                        {
                            if (msg.msgInfo != null && msg.msgInfo != "")
                            {
                                msg.msgInfo = msg.msgInfo + ",";
                            }
                            msg.msgInfo = msg.msgInfo + "手机号或微信号必须填一个";
                        }
                        cinfo.IsDelete = false;
                        cinfo.IsAllocation = false;
                        cinfo.IsPropagable = false;
                        cinfo.CreateBy = GetUserByToken().ID;
                        cinfo.LastEditBy = GetUserByToken().ID;
                        cinfo.LastEditDate = DateTime.Now;
                        cinfo.RealityFollowDate = DateTime.Now;
                        if (listc.Exists(x => !string.IsNullOrEmpty(x.Tel) && x.Tel == cinfo.Tel))
                        {
                            if (msg.msgInfo != null && msg.msgInfo != "")
                            {
                                msg.msgInfo = msg.msgInfo + ",";
                            }
                            msg.msgInfo = msg.msgInfo + "该手机号" + cinfo.Tel + "已存在";
                        }
                        if (!string.IsNullOrEmpty(cinfo.Tel))
                        {
                            if (cbll.Exists("Tel= ('" + cinfo.Tel + "')", null))
                            {
                                if (msg.msgInfo != null && msg.msgInfo != "")
                                {
                                    msg.msgInfo = msg.msgInfo + ",";
                                }
                                msg.msgInfo = msg.msgInfo + "该手机号" + cinfo.Tel + "已存在";
                            }
                        }
                        if (msg.msgInfo == null || msg.msgInfo == "")
                        {
                            listc.Add(cinfo);
                        }
                        else
                        {
                            if (cinfo.Tel != null)
                            {
                                msg.msgTel = cinfo.Tel;
                            }
                            if (cinfo.CustomerName != null)
                            {
                                msg.msgCustomerName = cinfo.CustomerName;
                            }
                            listMsg.Add(msg);
                        }
                    }
                    cbll.Add(listc, "");
                    if (listMsg.Count > 0)
                    {
                        Data = ReturnFormat(ReturnCode.导入错误, "错误条数" + listMsg.Count + "条", listMsg);
                    }
                    else
                    {
                        Data = ReturnData(ReturnCode.访问成功, new { });
                    }
                }
                else
                {
                    Data = ReturnData(ReturnCode.请选择excel文件, new { });
                }
            }
            catch (Exception ex)
            {
                //2018、08、16 新增错误日志记录
                AddOperationLog("CustomerResources", "001", "记录导入错误日志", ex.ToString(), OperationLogType.错误日志);
                Data = ReturnData(ReturnCode.文件需要解密才能上传, new { });
            }
            return Data;
        }

#endregion

#region Excel导入成Datable
        /// Excel导入成Datable
        /// </summary>
        /// <param name="file">导入路径(包含文件名与扩展名)</param>
        /// <returns></returns>
        public DataTable ExcelToTable(string file)
        {
            DataTable dt = new DataTable();
            IWorkbook workbook;
            string fileExt = Path.GetExtension(file).ToLower();
            using (FileStream fs = new FileStream(file, FileMode.Open, FileAccess.Read))
            {
                //XSSFWorkbook 适用XLSX格式，HSSFWorkbook 适用XLS格式
                if (fileExt == ".xlsx") { workbook = new XSSFWorkbook(fs); } else if (fileExt == ".xls") { workbook = new HSSFWorkbook(fs); } else { workbook = null; }
                if (workbook == null) { return null; }
                ISheet sheet = workbook.GetSheetAt(0);

                if (sheet.LastRowNum == sheet.FirstRowNum)
                {
                    return dt;
                }

                //表头  
                IRow header = sheet.GetRow(sheet.FirstRowNum);
                //IRow header1 = sheet.GetRow(sheet.FirstRowNum + 1);
                List<int> columns = new List<int>();
                for (int i = 0; i < header.LastCellNum; i++)
                {
                    object obj = GetValueType(header.GetCell(i));
                    columns.Add(i);
                }
                //数据  
                for (int i = sheet.FirstRowNum + 1; i <= sheet.LastRowNum; i++)
                {
                    if (sheet.GetRow(i) == null)
                    {

                    }
                    else
                    {
                        DataRow dr = dt.NewRow();
                        bool hasValue = false;
                        foreach (int j in columns)
                        {
                            if (sheet.GetRow(i).GetCell(j) == null)
                            {
                                dr[j] = "";
                            }
                            else if (sheet.GetRow(i).GetCell(j).CellType == CellType.Numeric && HSSFDateUtil.IsCellDateFormatted(sheet.GetRow(i).GetCell(j)))
                            {
                                dr[j] = sheet.GetRow(i).GetCell(j).DateCellValue;
                            }
                            else if (sheet.GetRow(i).GetCell(j).CellType == CellType.Numeric)
                            {
                                dr[j] = sheet.GetRow(i).GetCell(j).NumericCellValue;
                            }
                            else
                            {
                                dr[j] = sheet.GetRow(i).GetCell(j).StringCellValue;
                            }
                            if (dr[j] != null && dr[j].ToString() != string.Empty)
                            {
                                hasValue = true;
                            }
                        }
                        if (hasValue)
                        {
                            dt.Rows.Add(dr);
                        }
                    }
                }
            }
            return dt;
        }
        #endregion

        #region 获取单元格类型
        /// <summary>
        /// 获取单元格类型
        /// </summary>
        /// <param name="cell"></param>
        /// <returns></returns>
        private object GetValueType(ICell cell)
        {
            if (cell == null)
                return null;
            switch (cell.CellType)
            {
                case CellType.Blank: //BLANK:  
                    return null;
                case CellType.Boolean: //BOOLEAN:  
                    return cell.BooleanCellValue;
                case CellType.Numeric: //NUMERIC:  
                    return cell.NumericCellValue;
                case CellType.String: //STRING:  
                    return cell.StringCellValue;
                case CellType.Error: //ERROR:  
                    return cell.ErrorCellValue;
                case CellType.Formula: //FORMULA:  
                default:
                    return "=" + cell.CellFormula;
            }
        }
        #endregion

西伯利亚天狼
关注
后台可以直接获取绝对路径的上传文件方法_后台getshell常用技巧总结
weixin_31091881的博客
01-26 1608
1.利用文件上传漏洞，找文件上传处想办法上传php文件。一些网站在设置可以允许修改上传的文件类型则直接添加php有时候会还有检测是否为php文件，可以通过文件名变形，大小写，双写等形式绕过，只要是黑名单的都比较好绕过很多cms还有.hatccess文件禁止访问或者执行这个目录下的文件的情况这种情况直接上传一个.hatccess文件覆盖这个，让其失效。或者上传不重命名的话上传../../s...
Asp.net获取服务器指定文件夹目录文件并提供下载的方法
10-24
这段代码会将文件夹中的文件名填充到一个DataTable中，然后绑定到Repeater控件，以便在网页上显示文件列表。 当用户点击某个文件进行下载时，我们需要处理点击事件。这里假设使用一个名为"down"的按钮或链接，我们...
利用jxl实现excel文件上传解析，并获取地址获得高德经纬度
lv1321821792的博客
10-26 527
文件上传功能一直是我最头疼的地方，写这个博客只是作为记录，以便于自己下次能够找到模板 首先controller层： public static String url = "https://restapi.amap.com/v3/geocode/geo?key=332c42865845ba43bac0&amp;address="; @RequestMapping("/social") ...
前端 实现文件夹上传(保留目录结构)
最新发布
weixin_52041354的博客
07-26 924
WEB上传一个文件夹，网上搜了一下基本上都是借助于HTML5也就是chrome的API来实现的功能，试了一下不怎么好用，第一是断点续传功能需要自己实现，他没有实现好，还需要写额外的代码，第二是队列控制逻辑没有实现，需要自己实现，第三是后端存储逻辑，以及层级结构信息逻辑没有实现，需要自己实现，基本上这html5也就是chrome实现的东西也不多，可以说太少了。免费提供源码讲解服务，功能讲解，逻辑讲解，原理讲解，思路讲解，核心代码功能实现讲解，新业务功能扩展指导，免费提供编译指导，免费提供部署指导。
Java 模拟formdata上传excel文件到指定地址
weixin_41152613的博客
12-16 457
public static Map<String, Object> uploadFile(String fileName, ByteArrayOutputStream bos,String merCode) { //fileName 文件的名称 Map<String, Object> result = new HashMap<>(); HttpURLConnection connection = null; String.
Excel导入，前台上传文件，后台获取文件流，并在服务器保存文件，返回服务器文件地址，根据地址将文件导入数据库。
qq_44758798的博客
03-30 3537
1、过程流程： 本地excel（要上传的文件） 页面截图： 开始操作！！！ 点击选择文件，选取第一张图（本地要上传的excel），选择之后，点击upload上传。 在服务器端生成的文件： 数据库添加的数据： 2、具体代码： 1）需要IDEA Mysql; SpringBoot; Mybatis 2）html代码：（需要引入jquery） <!DOCTYPE html> <html lang="en"> <html xmlns:th=...
上传到linux服务器上的EXCEL、图片、文件地址获取不同
weixin_44347111的博客
09-12 545
场景： 最近写的项目有涉及到读取文件、excel、图片信息到项目中，在本地运行一切正常，放到服务器上的路径就读取不出来了。下面给出解决办法 1、项目中的excel模板的读取方式（模板在resource下的ExcelModule文件夹中） // 读取源文件，模板数据存放位置，Linux环境下获取jar包classpath中的文件 InputStream inputStream = this.getClass().getClassLoader().getResourceAsStream("Exce.
C#导入Excel到Datatable等等
04-08
改程序实现了Excel的数据导入到Datatable，在后台动态生成Lable和文本框等控件，以及如何取到控件的值和生成文本文档、添加显示图片等等的源代码，下载所需积分怎么涨这么快，给大家点福利，重置为5积分。
C# .net Excel导入到DataTable（不需要插件）
07-12
方便简单，将类文件放入项目中，直接即可使用，不需要引用dll或插件即可，
asp.net实现数据从DataTable导入到Excel文件并创建表的方法
10-23
在本场景中，我们关注的是如何将数据从 DataTable 导入到 Excel 文件，并在 Excel 中创建相应的表格。以下是对这个过程的详细解释： 首先，我们需要一个包含数据的 DataTable。DataTable 是 .NET Framework 中用于...
从Excel_导入数据到DataTable
04-12
### 从Excel导入数据到DataTable的知识点解析 在IT领域，特别是数据分析与处理工作中，将Excel数据导入到.NET Framework中的`DataTable`是非常常见的需求之一。本文将深入解析如何实现这一功能，并详细介绍其中的...
获取目录下文件路径信息写入Excel并打包上传远程服务器
10-09
最近在练习go代码，恰好工作中有一些场景需要经常去访问某个目录下所有文件，将相对路径写入Excel并上传系统，同时打包文件上传服务器。利用工作之余，练练手学习写了一个小工具，主要实现功能如下： 获取指定目录下所有文件路径信息 将获取文件相对路径信息保存至Excel文件中 将对应目录下所有文件打入tar包 将war包上传至指定的服务器路径 参考 config.yaml 配置相关信息，并将配置文件与EXE执行程序放置同一目录下
【无标题】项目上遇到的，给了一个.xlsx格式的文件，需要找出里面的批量地址对应的经纬度，所以写了一个HTML，只需要将文件上传，就能返回出包含经纬度的json数据
isDIK的博客
11-24 223
EXCEL文件中的批量地址，拿到对应的经纬度，并返回成json格式
datatables 树形表格 java数据组装_前端插件之Datatables使用上篇
weixin_39943220的博客
11-29 468
工欲善其事，必先利其器本系列文章介绍我在运维系统开发过程中用到的那些顺手的前端插件，前边两篇分别介绍了Duallistbox插件和Select2插件的使用，这一篇开始Databases的征服之旅Databases是一款基于JQuery的表格插件，主要用来优化table，支持表格分页、搜索、排序、显示条数、异步加载等众多好用的功能项目地址：https://datatables.net/基本...
Excel文件的上传和读取
rrgef的博客
12-05 2089
首先按照要求的模板制作Excel文档，然后上传之服务器，并读入到数据库中 本文章针对，先将Excel文档存在服务器中，然后再将存放文档的路径传到Service层，最后写入到数据库当中，具体看一下代码： 前端代码： <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="h
jQuery实现文件上传
weixin_43222587的博客
04-07 795
html代码段 要先引入ajaxFileUpload.js文件 <span onclick="chooseTheFile()">点我上传文件</span> <input type="file" id="excelFile" name="excelFile" onchange="filesUpload()" style="display: none;" /> JS代码段 // 上传文件 function chooseTheFile() { $('#excelFile
得到上传控件中文件的文件名、长度和完全路径
weixin_30906185的博客
01-16 62
FileUpload ful = new FileUpload();ful.FileName; //文件名ful.PostedFile.ContentLength;//文件大小,单位 B,除以 1024得到 Kful.PostedFile.FileName;//完全路径 转载于:https://www.cnblogs.com/ruiruizhang/archive/2010/01/16/1...
生成Excel直接上传服务器+下载
weixin_43572224的博客
02-04 885
//生成Excel文件 直接上传服务器 //生成excel XSSFWorkbook workbook = new XSSFWorkbook(); //sheet页名 XSSFSheet sheet = workbook.createSheet("Sheet1"); XSSFCellStyle cellStyle = workbook.createCellStyle(); cellStyle.setAlignment(Ho.
前端读取服务器文件,js读取服务器端的txt文件
weixin_35916239的博客
07-31 5094
js读取服务器端的txt文件有两种方式：1、ajax方式读取文件var url = "http://10.22.19.150:8080/timer/resources/test.txt";var htmlobj= $.ajax({url:url,async:false});var dataString = htmlobj.responseText;// var data =JSON.parse(d...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

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

抵扣说明：

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

余额充值