We have shown how the PersisTable toolkit allows data to be managed from within Excel without requiring expert intervention. The demonstration data has been ranges of data that can be Tabulated and fed into a CSV file. There are circumstances where multiple ranges are logically part of the same data set. The annual financial statement […]
We have discussed Arenas as places where PersisTable data is stored. This physically separates sets of data; your local data is private to you while a shared Arena allows you to collaborate with colleagues. Genres allow PersisTable information to be logically separated. A Genre represents a class or type of information. So Genres may be […]
Once an Excel workbook has become useful, it is likely to be copied. Maybe a Sales ledger workbook has proved useful in one office and there is then a temptation to copy the workbook to other offices so they can use the functionality. Unfortunately this means that any problems or improvements to the original workbook […]
We have seen how to save and load data and how to find previosuly saved data using the PersisTable Viewer. Arenas were mentioned as a place to store data. However, the Local Arena is only accessible to the logged-on User and so that does not allow data to be shared easily. To share data we […]
The PersisTables Toolkit makes it easy to save data. As we have seen we just need to specify the moniker and name we want to give to the data using the TKTable_Save() function. Reloading it is done with the same moniker and name. However as the volume of data increases it becomes less easy to […]
A common complaint with spreadsheets is that it is difficult to monitor changes to the information within them. If a spreadsheet gets corrupted the data may be lost, creating problems for the business relying on it. Where data held within Excel has become the business books and records, changes need to be audited. Exporting data […]