vue如何分批上传excel？

Question

请问vue如何让excel分批上传呢？比如一次最多上传1000条，上次一下子上传20000多条，直接报错了

Answer 1

可以把文件切割分片再上传

 var bytesPerPiece = 1024 * 1024; // 每个文件切片大小定为1MB .
 var totalPieces;
 //发送请求
 function upload() {
   var blob = document.getElementById("file").files[0];
   var start = 0;
   var end;
   var index = 0;
   var filesize = blob.size;
   var filename = blob.name;

   //计算文件切片总数
   totalPieces = Math.ceil(filesize / bytesPerPiece);
   while(start < filesize) {
     end = start + bytesPerPiece;
     if(end > filesize) {
       end = filesize;
     }
     
     var chunk = blob.slice(start,end);
     var formData = new FormData();
     formData.append("file", chunk, filename);
     $.ajax({
       url: 'http://localhost:8080',
       type: 'POST',
       cache: false,
       data: formData,
       processData: false,
       contentType: false,
     }).done(function(res){}).fail(function(res) {});
     start = end;
     index++;
   }
 }