simple-excel-js
v1.0.0
Published
Client-side script to easily parse / convert / write any Microsoft Excel XLSX / XML / CSV / TSV / HTML / JSON / etc formats.
Downloads
283
Maintainers
faisalmanReadme
SimpleExcel.js
Client-side script to easily parse / convert / write any Microsoft Excel XLSX / XML / CSV / TSV / HTML / JSON / etc formats. As for server-side solution you might want to check SimpleExcelPHP
Example
<!doctype html>
<html>
<head>
<script type="text/javascript" src="simple-excel.js"></script>
</head>
<body>
<input type="file" id="fileInput" /><br/>
<input type="button" id="fileExport" />
<script type="text/javascript">
// read a CSV file
var csvParser = new SimpleExcel.Parser.CSV();
var fileInput = document.getElementById('fileInput');
// parse when file loaded, then print the result to console
fileInput.addEventListener('change', function (e) {
var file = e.target.files[0];
csvParser.loadFile(file, function () {
console.log(csvParser.getSheet()); // print!
});
});
// write an XLSX file
var xlsxWriter = new SimpleExcel.Writer.XLSX();
var xlsxSheet = new SimpleExcel.Sheet();
var Cell = SimpleExcel.Cell;
xlsxSheet.setRecord([
[new Cell('ID', 'TEXT'), new Cell('Nama', 'TEXT'), new Cell('Kode Wilayah', 'TEXT')],
[new Cell(1, 'NUMBER'), new Cell('Kab. Bogor', 'TEXT'), new Cell(1, 'NUMBER')],
[new Cell(2, 'NUMBER'), new Cell('Kab. Cianjur', 'TEXT'), new Cell(1, 'NUMBER')],
[new Cell(3, 'NUMBER'), new Cell('Kab. Sukabumi', 'TEXT'), new Cell(1, 'NUMBER')],
[new Cell(4, 'NUMBER'), new Cell('Kab. Tasikmalaya', 'TEXT'), new Cell(2, 'NUMBER')]
]);
xlsxWriter.insertSheet(xlsxSheet);
// export when button clicked
document.getElementById('fileExport').addEventListener('click', function () {
xlsxWriter.saveFile(); // pop! ("Save As" dialog appears)
});
</script>
</body>
</html>License
GPLv2 & MIT License
Copyright © 2013 Faisalman <[email protected]>