locked
how to read xls data as utf8 RRS feed

  • Question

  • User-1634604574 posted

    i have this code to read xls file i want to read that file as utf8 how can i do it?

    var workbook = XLSX.read(data, {
    type: 'binary',

    });

    Sunday, May 26, 2019 10:12 AM

All replies

  • User-2054057000 posted

    i have this code to read xls file i want to read that file as utf8 how can i do it?

    var workbook = XLSX.read(data, {
    type: 'binary',

    });

    Consider taking a look to this tutorial on Reading Excel file.

    Sunday, May 26, 2019 12:55 PM
  • User839733648 posted

    Hi zhyanadil.it@gmail.com,

    i have this code to read xls file i want to read that file as utf8 how can i do it?

    var workbook = XLSX.read(data, {
    type: 'binary',

    });

    According to your description and code, it seems that you are using SheetJS js-xlsx, right?

    I've checked the official documentation and find that you may set the type as string.

    string: JS string (characters interpreted as UTF8)

    XLSX.read(data, {
      type: 'string',
    });

    For more, you could refer to : https://docs.sheetjs.com/#parsing-options

    Best Regards,

    Jenifer

    Monday, May 27, 2019 6:36 AM