An universal plugin for importing .xls and .xlsx files directly as ZikoJS Matrix.
npm install xlsx-transformer.xls / .xlsx files directly in JavaScript/TypeScript as either:
js
import {header, data} from './data.xls'
`
- Multiple sheets : returns a named export Sheets, an object where each sheet contains header (array) and data (a Matrix instance from ZikoJS).
`js
import { Sheets } from './data.xls'
`
Install
`bash
npm i xlsx-transformer
`
Integrations
$3
`js
import { defineConfig } from "vite";
import XlsxTranformer from "xlsx-transformer/vite"
export default defineConfig({
plugins:[
XlsxTranformer({
firstSheetOnly : false // Optional, the default is true
})
]
});
`