You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Currently the SheetObjectDictionary requires that the number of columns within the speadsheet match up with the number of object data members. A nice addition would be to allow for other columns that may be ignored by the class/object.
Proposed Solution
For reading in the data The entire sheet can be read in as an array of dictionaries, and the class constructor can simply pull in data it wants. and store the rest in a variable called "The Rest" or something with the associated column names etc.
For writing in the data The data is written back as normal.
The text was updated successfully, but these errors were encountered:
Problem
Currently the SheetObjectDictionary requires that the number of columns within the speadsheet match up with the number of object data members. A nice addition would be to allow for other columns that may be ignored by the class/object.
Proposed Solution
For reading in the data The entire sheet can be read in as an array of dictionaries, and the class constructor can simply pull in data it wants. and store the rest in a variable called "The Rest" or something with the associated column names etc.
For writing in the data The data is written back as normal.
The text was updated successfully, but these errors were encountered: