17 lines
628 B
JavaScript
17 lines
628 B
JavaScript
const xlsx = require('xlsx');
|
|
const fs = require('fs');
|
|
const filePath = 'd:\\Projects\\AI SOP Monitoring\\Consolidated_report_v2_with_feed-names (1).xlsx';
|
|
const workbook = xlsx.readFile(filePath);
|
|
|
|
console.log("Sheets found:", workbook.SheetNames);
|
|
|
|
const timeMatrixSheet = workbook.SheetNames.find(s => s.toLowerCase() === 'time matrix');
|
|
if (timeMatrixSheet) {
|
|
console.log("First 10 rows of Time Matrix:");
|
|
const sheet = workbook.Sheets[timeMatrixSheet];
|
|
const data = xlsx.utils.sheet_to_json(sheet, { header: 1 });
|
|
console.log(data.slice(0, 10));
|
|
} else {
|
|
console.log("Time Matrix sheet not found.");
|
|
}
|