Skip to content

Instantly share code, notes, and snippets.

@dav11d

dav11d/dhl_importer.js

Created October 22, 2017 23:19
Show Gist options
  • Save dav11d/2a3feec1a7b44837cc6c6d41d3a64f7e to your computer and use it in GitHub Desktop.
Save dav11d/2a3feec1a7b44837cc6c6d41d3a64f7e to your computer and use it in GitHub Desktop.
Download ZIP
Raw
dhl_importer.js
var Excel = require('exceljs');
XLSX = require('xlsx');
var workbook = new Excel.Workbook();
var wb = XLSX.readFile('dhl.xls');
sheet1 = XLSX.utils.sheet_to_json(wb.Sheets.Sheet1);
var rows = new Array();
for (var x in sheet1) {
rows.push([sheet1[x]['Waybill'], sheet1[x]['Shippers Reference']]);
}
var outbook = new Excel.Workbook();
var outsheet = outbook.addWorksheet('Tracking Numbers');
// add column headers
outsheet.columns = [
{ header: 'Waybill', key: 'Waybill'},
{ header: 'order_id', key: 'order_id'}
];
outsheet.addRows(rows);
// console.log(rowData)
outbook.csv.writeFile('complete.csv').then(function() {
console.log("saved");
});
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment