js导出excel科学计数法

function formatNumber(num, decimalPlaces) {
  return num.toFixed(decimalPlaces);
}

const number = 123456789012345;
const formattedNumber = formatNumber(number, 0); // "123456789012345"

const XLSX = require('xlsx');

const workbook = XLSX.utils.book_new();
const worksheet = XLSX.utils.aoa_to_sheet([
  ['Name', 'Value'],
  ['Number1', 123456789012345],
  ['Number2', 0.000000000123]
]);

// 设置单元格格式为文本
worksheet['A2'].t = 's';
worksheet['B2'].t = 's';
worksheet['A3'].t = 's';
worksheet['B3'].t = 's';

XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');
XLSX.writeFile(workbook, 'output.xlsx');

const XLSX = require('xlsx');

function formatNumber(num, decimalPlaces) {
  return num.toFixed(decimalPlaces);
}

const data = [
  ['Name', 'Value'],
  ['Number1', formatNumber(123456789012345, 0)],
  ['Number2', formatNumber(0.000000000123, 12)]
];

const worksheet = XLSX.utils.aoa_to_sheet(data);
const workbook = XLSX.utils.book_new();
XLSX.utils.book_append_sheet(workbook, worksheet, 'Sheet1');

XLSX.writeFile(workbook, 'output.xlsx');