import { ExcelFormatter } from 'xlsx-generator';

const excel = new ExcelFormatter();

const excel = new ExcelFormatter();
// parameter as a string or null
excel.SetWorkBookDefault('Author');

const excel = new ExcelFormatter();
// Example Header
const _header = [
    { header: 'Id', key: 'id', width: 10 },
    { header: 'Name', key: 'name', width: 25 },
    { header: 'Image', key: 'image', width: 50 },
];
// Example Data
const _data = [
    { id: 'test1', name: 'testUser1', image: 'file/file/test1.jpg' },
    { id: 'test2', name: 'testUser2', image: 'file/file/test2.jpg' },
    { id: 'test3', name: 'testUser3', image: 'file/file/test3.jpg' },
    { id: 'test4', name: 'testUser4', image: 'file/file/test4.jpg' },
];

// with fileName and sheetName
excel.WriteFileToExcel(_header, _data, 'mySheet', 'myFile');

// without fileName and sheetName
excel.WriteFileToExcel(_header, _data);

const excel = new ExcelFormatter();

excel.ReadFileFromExcel('myFile', 'mySheet');