module

Sheety::Spreadsheet

Spreadsheet data structures and converters

Class methods

convert(from_file : String, to_file : String) : Nil

Convert between any two formats

Source
create_empty(file_path : String) : Nil

Create an empty spreadsheet file

Source
populate_generator(data : WorkbookData, generator : CroupierGenerator) : Hash(String, BigFloat | String | Bool)

Populate a CroupierGenerator with the formulas of a workbook and collect the initial values for every non-formula cell. Shared by the CLI launch path and the .cr / .sheety converters, which previously each carried their own copy of this loop.

Source
read(file_path : String) : WorkbookData

Read a file and return the data

Source
read_with_metadata(file_path : String) : SpreadsheetFile

Read a file and return the data with metadata

Source
write(data : WorkbookData, file_path : String, source_file : String | Nil = nil) : Nil

Write the in-memory representation to a file

Source

Nested types