Advertisement
Guest User

Untitled

a guest
Mar 25th, 2019
78
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. function parseSheet(filePath, sheetNum) {
  2.     if (sheetNum === undefined) {
  3.         return false;
  4.     }
  5.  
  6.     let items = [];
  7.  
  8.     let workbook = xlsx.readFile(filePath, {type: 'binary'});
  9.  
  10.     let sheetName = workbook.SheetNames[sheetNum];
  11.  
  12.     let sheet = workbook.Sheets[sheetName];
  13.  
  14.     if (sheetNum == SHEETS['terrorists']) {
  15.         let row = 2;
  16.         while (sheet['B' + (++row)]) {
  17.             let user = {};
  18.             user.name = sheet['B' + row] ? sheet['B' + row].v : undefined;
  19.             user.birth = sheet['C' + row] ? sheet['C' + row].v : undefined;
  20.             user.doc = sheet['D' + row]? sheet['D' + row].v : undefined;
  21.             user.address = sheet['E' + row]? sheet['E' + row].v : undefined;
  22.  
  23.             if (!user.name) {
  24.                 continue;
  25.             }
  26.  
  27.             items.push(user);
  28.         }
  29.     }
  30.  
  31.     if (sheetNum == SHEETS['iccntribs']) {
  32.         let row = 1;
  33.         while (sheet['B' + (++row)]) {
  34.             let user = {};
  35.             user.fullname = sheet['B' + row].v;
  36.             user.surname = sheet['C' + row] ? sheet['C' + row].v : undefined;
  37.             user.name = sheet['D' + row] ? sheet['D' + row].v : undefined;
  38.             user.patronymic = sheet['E' + row] ? sheet['E' + row].v : undefined;
  39.             user.fullnameEng = sheet['F' + row] ? sheet['F' + row].v : undefined;
  40.             user.birthDate = sheet['G' + row] ? sheet['G' + row].v : undefined;
  41.             if (typeof user.birthDate == 'number') {
  42.                 user.birthDate = new Date(1900, 0, user.birthDate - 1);
  43.                 user.birthDate = datesHelper.getDate(user.birthDate, "iso");
  44.             }
  45.             user.birthYear = sheet['H' + row] ? sheet['H' + row].v : undefined;
  46.             user.address = sheet['I' + row] ? sheet['I' + row].v : undefined;
  47.  
  48.             if (!user.fullname) {
  49.                 continue;
  50.             }
  51.             items.push(user);
  52.         }
  53.     }
  54.  
  55.     return items;
  56. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement