Releases: securedeveloper/react-data-export
Releases · securedeveloper/react-data-export
Fixes Installation, Library, Cell Width issues.
Although I'm still working core excel API (https://github.com/securedeveloper/javascript-excel) but I took some time to find the issues, tracked down the reasons and fixed them.
- tempa-xlsx (instead of github) to avoid any installation issue.
- add
xlsx
in dev dependency to avoid dependency collision. - Merged PRs addressing cell width and cell data type (int)
** Followup
After (https://github.com/securedeveloper/javascript-excel) I will change library to use Typescript, hence typings will be provided along the way.
Added Excel File style and better documentation
Refactored library to support excel cell styling, We also refactored our documentation to better explain the library.
Added support of multiple dataset
/*When you want to use dataSet directly, you can specify multiple data to single ExcelSheet with following structure,
//i.e You can have multiple dataSets on Multiple Sheets in Single Excel File
interface {
xSteps?: number; //How many cells to skips from left (Optional)
ySteps?: number; //How many rows to skips from last data (Optional)
columns: [array | string] //array (required)
data: [array_of_array | string|boolean|number] //array of arrays (required)
}
*/
import React from "react"
import {default as ExcelFile, ExcelSheet} from "react-data-export"
const multiDataSet = [
{
columns: ["Name", "Salary", "Sex"],
data: [
["Johnson", 30000, "Male"],
["Monika", 355000, "Female"],
["Konstantina", 20000, "Female"],
["John", 250000, "Male"],
["Josef", 450500, "Male"],
]
},
{
xSteps: 1, // Will start putting cell with 1 empty cell on left most
ySteps: 5, //will put space of 5 rows,
columns: ["Name", "Department"],
data: [
["Johnson", "Finance"],
["Monika", "IT"],
["Konstantina", "IT Billing"],
["John", "HR"],
["Josef", "Testing"],
]
}
];
class App extends React.Component {
render() {
return (
<ExcelFile>
<ExcelSheet dataSet={multiDataSet} name="Organization" />
<!-- You can add more ExcelSheets if you need -->
</ExcelFile>
);
}
}
Initial library release.
ReleaseLog
Version 0.1.0
Supported file formats and extensions.
This version support excel
export with xlsx
format and data format to export has a format like this,
var data = [
{...object1},
{...object2},
{...object3}
]