-
Notifications
You must be signed in to change notification settings - Fork 0
Methods
Martin Davtyan edited this page Jun 6, 2015
·
11 revisions
Algorithms working with Excel data are going to be implemented as methods of the Context object. This object is loaded into the memory throughout the entire lifetime of Worker. Data written by one method should be accessible to other methods.
_______ events _________
| | -----> | Worker |
| Excel | |(runtime)|
|_______| <----- |_________|
actions
| What we need to do | What needs to be stored |
|---|---|
| Header detection | Position of header, column names on every sheet |
| Table detection | Position of beginning and end of table on every sheet |
| Error detection for columns | Column validation features (numpy.array's) |
| Autofill from another column (in another sheet) | A sequence of previously entered cells with their position |
| Selecting elements that user highlights | A sequence of previously highlighted elements |
| Event name | When triggered | Information contained (and passed to Worker) |
|---|---|---|
| WorkbookOpen | New Excel file is open | Name of file |
| WorkbookBeforeClose | Before the Excel file is closed | Name of file |
| SheetChange | When any cell is changed | A new value of a cell, it's metaparameters (formatting, etc, could serialize Excel Cell object into a dict) and a cell address |