SheetSense


A robust TypeScript library for Excel workbook analysis that helps detect quality issues, validate formulas, and ensure data consistency across spreadsheets. SheetSense provides comprehensive validation and analysis capabilities to help maintain high-quality Excel workbooks.

Features

- Formula Analysis
- Complexity scoring and validation
- Division by zero detection
- Circular reference detection
- Pattern recognition system
- Risk assessment system
- Data Validation
- Type consistency checking
- Date format validation
- Column type analysis
- Mixed type detection
- Hidden Content Detection
- Hidden cell identification
- Hidden row/column analysis
- Hidden range reporting
- Style Checks
- Number format consistency
- Format pattern detection
- Metadata Analysis
- Statistics tracking
- Formula counting
- Named ranges listing
- Hidden content metrics

$3

``bash
pnpm install sheetsense
`

$3

`ts
import { ExcelAnalyzer } from 'sheetsense';
import { readFile } from 'xlsx';

// Load your workbook
const workbook = XLSX.read(data,{
type: 'buffer',
cellFormula: true,
cellNF: true,
cellText: true,
cellStyles: true,
cellDates: true,
raw: true
});

// Create analyzer instance
const analyzer = new ExcelAnalyzer(workbook);

// Perform analysis
const analysis = analyzer.analyze();

// Access results
console.log(analysis.issues); // Array of detected issues
console.log(analysis.metadata); // Workbook metadata and statistics
`

$3


The analyzer returns and Analysis object containing:
`ts
{
issues: Array<{
type: 'formula' | 'style' | 'data';
severity: 'error' | 'warning' | 'info';
cell: string;
sheet: string;
message: string;
suggestion?: string;
}>;
metadata: {
formulaCount: number;
sheetCount: number;
namedRanges: string[];
volatileFunctions: number;
externalReferences: number;
hiddenContent: {
totalHiddenCells: number;
totalHiddenRows: number;
totalHiddenColumns: number;
hiddenRanges: string[];
};
};
}
`

$3

`bash
pnpm install
pnpm test
pnpm run coverage
pnpm run build
``

$3

Contributions are welcome! Please feel free to submit a Pull Request. For major changes, please open an issue first to discuss what you would like to change.

$3

For support, bug reports and feature requests please use GitHub Issues.

Roadmap

$3

- [ ] Basic complexity scoring
- ✅ Division by zero detection
- [ ] Complex formula detection
- ✅ Basic formula parser
- ✅ Circular reference detection

$3

- ✅ Data type consistency
- ✅ Date format validation
- ✅ Column type analysis
- ✅ Mixed type detection

$3

- ✅ Number format consistency
- ✅ Format pattern detection

$3

- ✅ Hidden cell detection
- ✅ Hidden row/column analysis
- ✅ Hidden range identification
- ✅ Hidden content metrics

$3

- ✅ Basic statistics tracking
- ✅ Formula count
- ✅ Sheet count
- ✅ Named ranges list
- ✅ Basic metrics

🚧 In Development

$3

- ✅ Integrate xlsx for parsing
- ✅ Pattern recognition system
- Enhanced complexity scoring
- ✅ Risk assessment system
- Formula explanation generator

$3

- Rule engine interface
- Dependency mapper
- Documentation generator
- Performance analyzer

$3

- Team collaboration
- Audit logging (winston)
- User management
- Rule import/export
- Analysis dashboard
- Claude API integration