XLSX.read always read sheetname as sheet1

[consciousnessdev]

I have problem when run XLSX.read its always return sheet name as Sheet1, even though the sheet name has been changed to 'data',

Maybe can help with below clues:

• my laptop use linux xubuntu 20.04 x64 with latest Google Chrome version, before opened by WPS Spreadsheet / Libre Calc it keeps read sheet name as sheet1,
• before read by XLSX, i did converted file object to base64, then read file with syntax: const workbook = XLSX.read(convertFileToBase64, { type: 'base64' });

[consciousnessdev]

Solved.

Caused by File Object must Converted to Binary String, then set XLSX.read type to binary

[robhoff-laerdal]

@consciousnessdev How did you convert your file to a binary string? I am having the same issue.

[consciousnessdev]

@consciousnessdev How did you convert your file to a binary string? I am having the same issue. With this Code @robhoff-laerdal

const fileObjectToBinary = fileObj => new Promise((resolve, reject) => {
const reader = new FileReader();
reader.readAsBinaryString(fileObj);
reader.onload = () => resolve(reader.result);
reader.onerror = error => reject(error);
});

Hope its help you :)