XLSX Service

Available methods

• exportJsonToXlsx: exports json data into a .xlsx file
• parseXlsxSheetByPositionToJson: parse specific sheet in xml defined by the sheet's position into json
• parseXlsxSheetByNameToJson: parse specific sheet in xml defined by the sheet's name into json
• parseXlsxFullToJson: parse full xlsx file into json

Usage examples

yarn add @novo-x/xlsx

import {XlsxService} from "@novo-x/xlsx"

const MyService = new XlsxService();

MyService.exportJsonToXlsx(
    jsonData,
    sheetName,
    fileName
);

const importedDataByPosition = MyService.parseXlsxSheetByPositionToJson(
    filePath, 
    sheetNumber
);

const importedDataByName = MyService.parseXlsxSheetByNameToJson(
    filePath,
    sheetName
);

const importedFullXlsx = MyService.parseXlsxFullToJson(
    filePath
);

Dependencies

xlsx