xlsx-merge

Core library: xlsx-js-style

Publish Package (using yarn):

1. yarn login
2. yarn build
3. yarn publish

ExcelExportTSQ Properties:

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,...

Column

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	-

Config

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.