read_file
Read an entire Excel or CSV file
get_cell
Get the value of a specific cell
get_range
Get values from a range of cells
get_headers
Get column headers from a file
search
Search for values in a file
filter_rows
Filter rows based on criteria
aggregate
Perform aggregation operations like sum on columns
read_file_chunked
Stream large files (100MB+) in chunks
get_file_info
Get metadata about a file
write_file
Create an Excel or CSV file
add_sheet
Add a new sheet to an existing workbook
write_multi_sheet
Create a multi-sheet workbook with formulas
export_analysis
Export analysis results to a file
format_cells
Apply formatting to cells
auto_fit_columns
Auto-fit column widths
statistical_analysis
Perform statistical analysis on data
correlation_analysis
Perform correlation analysis between columns
data_profile
Generate a data profile of a file
pivot_table
Create a pivot table from data
dcf_analysis
Perform discounted cash flow (DCF) valuation
budget_variance_analysis
Analyze budget vs actual variances
ratio_analysis
Perform financial ratio analysis
scenario_modeling
Run what-if scenario modeling
trend_analysis
Perform trend analysis on data
find_duplicates
Find duplicate rows in a file
data_cleaner
Clean data (fix dates, phones, names)
vlookup_helper
Perform cross-file lookups similar to VLOOKUP
bulk_aggregate_multi_files
Aggregate data across multiple files
bulk_filter_multi_files
Filter data across multiple files
validate_data_consistency
Check cross-file referential integrity
evaluate_formula
Evaluate a formula
parse_natural_language
Convert natural language to a formula
explain_formula
Explain what a formula does
smart_data_analysis
Perform AI-powered data analysis
ai_provider_status
Check the status of AI providers