insertaPersonas

public insertaPersonas(path: string) {
    console.log('entre');
    const workbook = xlsx.readFile(path);
    const sheet = workbook.SheetNames[0];
    var worksheet = workbook.Sheets[sheet];


    for (let i = 7; i < 500; i++) {
      var aux = 'A' + i.toString();
      var auxAp1 = 'B' + i.toString();
      var auxAp2 = 'C' + i.toString();
      var auxNom = 'D' + i.toString();
      var auxSec = 'E' + i.toString();
      var auxEsp = 'F' + i.toString();
      var celda = worksheet[aux];
      var celdaNom = worksheet[auxNom];
      var celdaAp1 = worksheet[auxAp1];
      var celdaAp2 = worksheet[auxAp2];
      var celdaSec = worksheet[auxSec];
      var celdaEsp = worksheet[auxEsp];

      if (celda == null || celdaNom == null || celdaAp1 == null || celdaAp2 == null ||
        celdaSec == null || celdaEsp == null) {
        console.log('Fin');
        break;
      } else {
        console.log(celda.v + ' ' + celdaNom.v + ' ' +
          celdaAp1.v + ' ' + celdaAp2.v + ' ' + celdaSec.v + ' ' +
          celdaEsp.v);

        //var str = celdaNom.v + ' ' + celdaAp1.v + ' ' + celdaAp2.v;
        //console.log(str);

        //console.log(secciones(celdaSec.v));

        //console.log(especialidad(celdaEsp.v));

      }

    }
  };