I can't read Excel with Angular2

Question

I want send Excel with Angular to my Server (SpringBoot). I can't do this.

So, I thought that my problem maybe is "Angular doesn't read Excel." I am trying read my Excel with Angular and I get error ->

My intention is "If Angular can read the Excel, then I will try send Excel."

Because I am trying send Excel and I can't send...

Then:

In this code:

 fileChange(event) {
 
    let file: File = event.files[0];
    let myReader: FileReader = new FileReader();
    let fileType = event.parentElement.id;
    myReader.onloadend = function (e) {

      console.log(myReader.result);

    }
    console.log('fileType' , fileType);
    myReader.readAsText(file);
  }

ERROR

ERROR TypeError: Cannot read property '0' of undefined

This code I got the ->

Upload a File and Read Data with FileReader in Angular 2

Before I try with this code:

fileChange(event) {
    let fileList: FileList = event.target.files;
    if (fileList.length > 0) {
      let file: File = fileList[0];
      this.formData.append('uploadFile', file, file.name);
      console.log('al cambiar file' ,  file);
    }
    console.log(' formdata' ,  this.formData );
    console.log(' fileList' ,  fileList);
    console.log('stack' ,  event.files[0]);
  }

result

With this code I get name the File and last modification but I can't get cells of Excel.

can you show your responseType that you are sending with post mehtod? — Chellappan வ, Jul 16 '18 at 06:39
hi, you can see the answer server in my first link the my question. — EduBw, Jul 16 '18 at 06:45
instead of headers.append('Content-Type', 'multipart/form-data') change headers.append('Content-Type', 'ResponseContentType.Blob') and try to post — Chellappan வ, Jul 16 '18 at 06:51
http://localhost:8080/ml/insert 415 () status":415,"error":"Unsupported Media Type","exception":"org.springframework.web.HttpMediaTypeNotSupportedException","message":"Invalid mime type \"ResponseContentType.Blob\": does not contain '/'","path":"/ml/insert"}" — EduBw, Jul 16 '18 at 07:00

score 0 · Answer 1 · answered Jul 16 '18 at 08:27

0

use 'xlsx' package.

npm install xlsx

answered Jul 16 '18 at 08:27

Amir Rajabi

1
1

I can't read Excel with Angular2

1 Answers1