2

I have a code that read an excel file that was input and post the data into a mysql database. The problem is that sometimes, not always, when I post the method, i receiv the following error: Error: Corrupted zip : can't find end of central directory, so I want to try again until it works .. I use the library XLSX-Populate to parse the data

import { createConnection } from "typeorm";

const XlsxPopulate = require('xlsx-populate');

export async function xlsxImportParser(filePath: string): Promise<string> {
    let response: string;
    await XlsxPopulate.fromFileAsync(filePath, {encoding:'base64'}) // Leio o XLSX
        .then(async workbook => { // Dou uma variavel pra planilha, pra acessar os dados dela
            let recordsAdded = 0; // Crio uma variavel com total de itens na planilha
            await TempHomologados.delete({});
            console.log('processando')
            for(let i = 2; i < workbook.sheet(0)._rows.length; i++) { // Faco um for, para cada linha da planilha, eu adicionar um registro no banco de dados, comecando por 1, porque a linha 0 e o cabeçalho
                try {
                    let temp_homologados = await TempHomologados.findOne({ codigo_candidato: workbook.sheet(0).cell(`B${i}`).value()});
                    let newPessoa = false;
polonio
  • 333
  • 3
  • 11

0 Answers0