logisheets

Crates.iologisheets
lib.rslogisheets
version0.6.0
sourcesrc
created_at2022-04-18 09:51:45.665548
updated_at2024-01-03 08:05:38.961758
descriptionA web spreadsheets application written in Rust and Typescript
homepage
repositoryhttps://github.com/logisky/LogiSheets
max_upload_size
id569780
size4,174
(ImJeremyHe)

documentation

README

LogiSheets

MIT/Apache 2.0

What is LogiSheets?

LogiSheets is a web-based spreadsheet application that seamlessly integrates with Excel and is crafted for expansion. Notably, it comes at no cost!

You can utilize the Rust crate and Node package to efficiently read, perform operations, and write .xlsx files.

We are also working on a user interface to enable users to use spreadsheets directly in their web browsers.

WARNING

LogiSheets is currently in its early development stages. We welcome your feedback, issues, or pull requests!

Design goals

  • Easy further development: LogiSheets provides rich APIs to help you develop your plugins.
  • Structural Data Support: LogiSheets introduces a data structure (temporarily named Block) to maintain the consistent positions of cells within a specified area.
  • Supporting Cowork

Get Started

Use it in Rust

Now, LogiSheets provides APIs to read and write a .xlsx file. More APIs to manipulate the spreadsheets(like input a formula and calculate or write a file) is on the way.

Load a file:

use logisheets::{Value, Workbook};
use std::fs;
let mut buf = fs::read("tests/6.xlsx").unwrap();
let mut wb = Workbook::from_file(&mut buf, String::from("6")).unwrap();
let mut ws = wb.get_sheet_by_idx(0).unwrap();

And then get a value:

let v = ws.get_value(9, 1).unwrap();

Or get a formula:

let f = ws.get_formula(9, 1).unwrap();

Also you can get a cell style:

let s = ws.get_style(9, 1).unwrap();

You can get the comments of a sheet by:

let comments = ws.get_comments();

Use it as a web application

We are working on it. You can check the progress by running the cmd

yarn start:wasm

Featured

  • Insert/delete columns or rows.
  • Calculating and supporting 200+ functions.
  • Undo/Redo

LIMITATIONS

  • Insert/delete cells.
Commit count: 400

cargo fmt