| |
- formatCsv(dicts)
- Converts a list of dictionaries into a CSV-formatted flat table
(including a header row).
- getCsv(file, filters={})
- Given a specific CSV file (string) and a set of filters (dictionary
key-values pairs), will return a CSV-formatted table of the matching data
entries from that file (including a header row).
- getExcel(file, filters={})
- Given a specific Excel file (string) and a set of filters (dictionary
key-values pairs), will return a CSV-formatted table of the matching data
entries from that file (including a header row). Defaults to the first
sheet in the workbook; other sheets can be specified by name or
zero-based index using the '_sheet' parameter in the URL's query segment.
- getSqlite(file, filters={})
- Given a specific SQLite file (string) and a set of filters (dictionary
key-values pairs), will return a CSV-formatted table of the matching data
entries from that file (including a header row). Requres a '_table'
parameter in filters to query from the appropriate table.
|