count rows xlsx

xlsxreadcount.js

const XLSX = require('xlsx');
const fs = require('fs');
const path = require('path');
const { createHash } = require('crypto');

let overallRowCount = 0;
try {
  // Function to count rows in a single .xlsx file
  const countRows = (filePath) => {
    try {
      const workbook = XLSX.readFile(filePath);
      const sheetName = workbook.SheetNames[0];
      const worksheet = workbook.Sheets[sheetName];
      return XLSX.utils.sheet_to_json(worksheet).length;

    } catch (error) {
      console.log(error);
    }
  };
  const generateMD5 = (filePath) => {
    const fileBuffer = fs.readFileSync(filePath);
    const hashSum = createHash('md5');
    hashSum.update(fileBuffer);
    const hex = hashSum.digest('hex');
    return hex;
  };


  // Function to count rows of all .xlsx files in a folder
  const countRowsInFolder = (folderPath) => {
    const files = fs.readdirSync(folderPath);
    //console.log(`path: ${folderPath}`)
    try {
      files.forEach((file) => {
        //console.log(`file: ${file}`)
        if (path.extname(file) === '.xlsx') {
          const filePath = path.join(folderPath, file);
          //console.log(`filePath: ${filePath}`);
          const rowCount = countRows(filePath);
          overallRowCount = overallRowCount + rowCount;
          const md5Hash = generateMD5(filePath);
          console.log(`${file}, rows: ${rowCount}, hash: ${md5Hash}, overall: ${overallRowCount}`);
        }
      });
    } catch (error) {
      console.log(error);
    }
  };

  // Replace 'your/folder/path' with the path to the folder containing your .xlsx files
  countRowsInFolder('/Users/vinayak/Downloads/GSM-Bulk-Registrations');
} catch (error) {
  console.log(error);
}