Struct SpreadsheetDataModel 

pub struct SpreadsheetDataModel { /* private fields */ }

DuckDB-backed data model for spreadsheet

Implementations

impl SpreadsheetDataModel

pub fn new(columns: Vec<ColumnDef>) -> DuckResult<Self>

Create a new in-memory spreadsheet data model

pub fn insert_rows(&mut self, rows: Vec<Vec<String>>) -> DuckResult<()>

Insert multiple rows

pub fn insert_row(&mut self, values: Vec<String>) -> DuckResult<()>

Insert a single row

pub fn query_rows(&self) -> DuckResult<Vec<RowData>>

Query all rows

pub fn update_cell( &mut self, row_id: usize, col_idx: usize, value: String, ) -> Result<(), String>

Update a single cell

pub fn delete_row(&mut self, row_id: usize) -> DuckResult<()>

Delete a row

pub fn export_csv(&self, path: &Path) -> Result<(), String>

Export to CSV

pub fn import_csv(&mut self, path: &Path) -> Result<(), String>

Import from CSV

pub fn export_parquet(&self, path: &Path) -> Result<(), String>

Export to Parquet using DuckDB’s built-in support

pub fn import_parquet(&mut self, path: &Path) -> Result<(), String>

Import from Parquet using DuckDB’s built-in support