UploadController

import { Request, Response, NextFunction } from 'express';
import pool from '../database';
import helper from '../lib/helpers';
import { Estudiante } from '../models/Estudiante';
import { Usuario } from '../models/Usuario';
import passport from 'passport';
const IncomingForm = require('formidable').IncomingForm;
import fs from 'fs-extra';
import xlsx from 'xlsx';

class uploadController {

  stringPath: string = 'nah';

  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));

      }

    }
  };

  public secciones(seccion: string) {
    var sec = seccion.split('-')[0];
    switch (sec) {
      case "10":
        return "1";
      case "11":
        return "2";
      case "12":
        return "3";
    }
  };

  public especialidad(esp: string) {
    var espec = esp.split(" ")[0];
    switch (espec) {
      case "Accounting":
        return "1";
      case "Informática":
        return "2";
      case "Turismo":
        return "3";
      case "Contabilidad":
        return "4";
      case "Secretariado":
        return "5";
      case "Ejecutivo":
        return "6";
      case "Productividad":
        return "7";
    }
  };

  public async subirArchivo(req: Request, res: Response) {
    var form = new IncomingForm();
    let readStream;
    let aux;
    form.parse(req);
    form.on('file', async (field: any, file: any) => {
      // Do something with the file
      // e.g. save it to the database
      // you can access it using file.path
      console.log('file', file.name);
      readStream = fs.createReadStream(file.path);
      // console.log(readStream.path);
      await this.insertaPersonas('cahcadj');
    });
    form.on('end', () => {
      res.json();
    });
  }

}

const uploadControllers = new uploadController();
export default uploadControllers;