Spreadsheet Object

OmniToolbox provides a SpreadsheetObject which can be constructed and passed around as a pointer to manage a singular XLSX spreadsheet, which can then later be imported into google sheets.

Right now, this class is very simple, future additions such as cell coloring might get added in the future.

To use the spreadsheet object, you call Initialize and declare your headers. Headers are the columns at the very top and dictate how far a row can get.

You then call AddRowByName and store the index.

You then call GetColumnIndexByHeader and store the index

To then modify a cell, you call EditCell and pass in the stored row and column index to modify the cell.

The file is then saved inside ProjectFolder/Saved/Spreadsheets whenever Save is called.

Last updated