文件上传（模板导出、批量导入）(文件上传模板怎么弄)

推荐整理分享文件上传（模板导出、批量导入）(文件上传模板怎么弄)，希望有所帮助，仅作参考，欢迎阅读内容。

文章相关热门搜索词:文件上传解决方案,文件上传模板,文件上传功能的实现步骤,文件上传模板怎么弄,文件上传模板,文件上传功能的实现步骤,文件上传流程,文件上传流程,内容如对您有帮助，希望把文章链接给更多的朋友！

<b class="addBtn UseraddBtn" style="background: #3d7bde;right: 93px;">+ 批量导入</b>

          <input type="file" id="fileInput"

            style="opacity: 0;right: 93px;width: 88px;height:29px;position: absolute;top:-5px" οnchange="BatchImport()">

          <a href="./模板.xlsx" class="addBtn UseraddBtn" target="_blank"

            style="background-color: #0E9D5F;color: #fff;">导出模板</a>

限制文件上传格式：

1、图片格式    

        accept="image/*"

        仅限制gif png格式   

        accept="image/gif,image/png"

2、excel格式  

        //限制.xls文件         accept="application/vnd.ms-excel"             //限制.xlsx文件         accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet" 

        同时限制上传.xls、.xlsx文件

        accept="application/vnd.openxmlformats-officedocument.spreadsheetml.sheet,application/vnd.ms-excel "

        或

        accept=".xls,.xlsx"

//批量导入

  function BatchImport() {

    var form = new FormData(), fileInput = document.getElementById("fileInput");

    form.append("file", fileInput.files[0]);

    if (!attributeid) {

      layer.msg("请先选择导入部门！");

      return;

    }

    layer.confirm('您确定要导入该文件吗？', {

      btn: ['确定', '取消'] //按钮

    }, function () {

      $.ajax({

        url: src + "/api/MailList/InsertPhone?attrid=" + attributeid,

        type: "POST",

        contentType: false,

        processData: false,

        data: form,

        success: function (data) {

          if (data) {

            layer.msg("导入成功", { icon: 1 });

            fileInput.value = "";

            setTimeout(() => { loadUserlist(); }, 1000);

          }

        },

        error: function (msg) {

          console.log(msg)

        }

      })

    }, function () {

      layer.close(50)

    })

  }

js部分限制上传文件类型

if (!['application/vnd.openxmlformats-officedocument.spreadsheetml.sheet', 'application/vnd.ms-excel'].includes(fileInput.files[0].type)) {

      layer.msg('只能上传.XLS|.XLSX格式的文件！', { icon: 2 });

      return;

    }

*.3gpp    audio/3gpp, video/3gpp    3GPP Audio/Video *.ac3    audio/ac3    AC3 Audio *.asf    allpication/vnd.ms-asf    Advanced Streaming Format *.au    audio/basic    AU Audio *.css    text/css    Cascading Style Sheets *.csv    text/csv    Comma Separated Values *.doc    application/msword    MS Word Document *.dot    application/msword    MS Word Template *.dtd    application/xml-dtd    Document Type Definition *.dwg    image/vnd.dwg    AutoCAD Drawing Database *.dxf    image/vnd.dxf    AutoCAD Drawing Interchange Format *.gif    image/gif    Graphic Interchange Format *.htm    text/html    HyperText Markup Language *.html    text/html    HyperText Markup Language *.jp2    image/jp2    JPEG-2000 *.jpe    image/jpeg    JPEG *.jpeg    image/jpeg    JPEG *.jpg    image/jpeg    JPEG *.js    text/javascript, application/javascript    JavaScript *.json    application/json    JavaScript Object Notation *.mp2    audio/mpeg, video/mpeg    MPEG Audio/Video Stream, Layer II *.mp3    audio/mpeg    MPEG Audio Stream, Layer III *.mp4    audio/mp4, video/mp4    MPEG-4 Audio/Video *.mpeg    video/mpeg    MPEG Video Stream, Layer II *.mpg    video/mpeg    MPEG Video Stream, Layer II *.mpp    application/vnd.ms-project    MS Project Project *.ogg    application/ogg, audio/ogg    Ogg Vorbis *.pdf    application/pdf    Portable Document Format *.png    image/png    Portable Network Graphics *.pot    application/vnd.ms-powerpoint    MS PowerPoint Template *.pps    application/vnd.ms-powerpoint    MS PowerPoint Slideshow *.ppt    application/vnd.ms-powerpoint    MS PowerPoint Presentation *.rtf    application/rtf, text/rtf    Rich Text Format *.svf    image/vnd.svf    Simple Vector Format *.tif    image/tiff    Tagged Image Format File *.tiff    image/tiff    Tagged Image Format File *.txt    text/plain    Plain Text *.wdb    application/vnd.ms-works    MS Works Database *.wps    application/vnd.ms-works    Works Text Document *.xhtml    application/xhtml+xml    Extensible HyperText Markup Language *.xlc    application/vnd.ms-excel    MS Excel Chart *.xlm    application/vnd.ms-excel    MS Excel Macro *.xls    application/vnd.ms-excel    MS Excel Spreadsheet *.xlt    application/vnd.ms-excel    MS Excel Template *.xlw    application/vnd.ms-excel    MS Excel Workspace *.xml    text/xml, application/xml    Extensible Markup Language *.zip    aplication/zip    Compressed Archive