visi

relative_salmon_sadie

Excel on the command line

0likes0comments

Visit project 0

Project details

About this project

visi provides a command line interface for reading, updating, and executing Excel spreadsheets. Built in Rust, it prioritizes performance and correctness.

visi is a command-line interface (CLI) application designed for reading, updating, and evaluating Excel files.

Key Features

Full Compatibility with Excel: Strives to match Excel's execution behavior 100%, even down to the errors
Performance Optimization: The application is crafted for rapid startup and efficient processing of large datasets

Functional Capabilities

Workbook Inspection

visi info data.xlsx
visi info data.xlsx --json

Reading Sheet Content

visi read data.xlsx
visi read data.xlsx --sheet Sheet1 --range A1:C10

Formula Evaluation

visi eval data.xlsx --in-place
visi eval data.xlsx --print --format table

Updating and Setting Values

visi set data.xlsx --sheet Sheet1 --cell A1 --value 100 --output updated.xlsx
visi set data.xlsx -s Sheet1 -S A1=100 -S A2=200 -S A3="=A1+A2" -S A4="=AVERAGE(A1:A2)" -i

Worksheet Management

visi sheet list data.xlsx
visi sheet add data.xlsx --name "Summary" -i

Row and Column Manipulation

visi row insert data.xlsx --sheet Sheet1 --index 0 -i
visi col delete data.xlsx --sheet Sheet1 --label C -i

Data Export

visi export data.xlsx --sheet Sheet1 --format csv --output sheet1.csv