Xlsx-merge NPM

Property	Requiment	Default	Type	Description
`data`	`true`	-	`object[]`	Data record array to be displayed.
`columns`	`true`	-	`Column[]`	Columns of table.
`fileName`	`true`	-	`string`	Excel file name `(.xlsx)`.
`config`	`true`	-	`Config`	Column key mapping to excel fields.
`children`	`true`	-	`JSX.Element`	Element receives `onClick()` event.
`onLoading`	`true`	-	`function()`	Callback executed when `children element` is clicked.
`onSuccess`	`true`	-	`function()`	Callback executed when data is exported successfully.
`onEmpty`	`true`	-	`function()`	Callback executed when empty data.
`onConvert`	`false`	`undefined`	`function()`	Callback converted data before export.
`mergedFieldCondition`	`false`	`undefined`	`string`	Condition field to merge cell. Ex: `orderCode`, `bookingCode`,...

Property	Requiment	Default	Type	Description
`id`	`true`	-	`number`	Unique Id.
`field`	`true`	-	`string`	Field mapping to data.
`title`	`true`	-	`string`	Header title.
`children`	`false`	`undefined`	`Column[]`	Nested Columns.
`type`	`false`	`general`	`currency` \| `date` \| `general`	Values type.
`[key: number \\| string]`	-	-	`any`	-

Property	Requiment	Default	Type	Description
`alignKey`	`true`	-	`string`	Column key mapping to align. Ex: `align`, `textAlign`, `excelAlgin`,...
`mergedKey`	`true`	-	`string`	Column key mapping to merge. Ex: `mergeCell`, `isMerge`,...
`fractionKey`	`true`	-	`string`	Column key mapping to format float number. Ex: `fraction`, `excelFraction`,...
`widthKey`	`true`	-	`string`	Column key mapping to width. Ex: `width`, `excelWidth`,...
`widthRate`	`false`	`1`	`number`	Ratio of width in excel to that in the original column.
`widthDefault`	`false`	`80` \| `14`	`number`	Width default by unit: `wpx: 80`, `wch: 14`.
`unit`	`false`	`wpx`	`wpx` \| `wch`	Unit of width.

1 year ago