vtools.datastore.excel package¶

Subpackages¶

Catalog class for a excel file data.

For the moment, it is virtually an empty class.

class ExcelCatalog(excel_file_path)¶

Bases: vtools.datastore.catalog.Catalog

A simple catalog class for excel data source.

No capacity for the time being.

data_references(selector, excelformatentry)¶: Excel implementaiton of create data ref based on selector and format setting, different from other type of data sources.

ExcelFormat(ts_type='rts', time='auto', header=None, write_times=True, interval=None, start=None, header_labels=None)¶

class ExcelFormatEntry¶

Bases: object

A helper class to store Excel stroing and retrieving format setting.

Service to access excel data source.

class ExcelService¶

Bases: vtools.datastore.service.Service

Service to access excel data source.

batch_add(ref, ts_list)¶

Add a number of ts into a excel worksheet pointed by ref.

input:: ts_list: might be single ts or list of ts. ref: data refernce instance.

For the limitation of excel, a number of ts has to be added into excel worksheet in one time.

Utility function to store time series into or retrieve time series from excel file.

excel_store_ts(ts, excel_file, selection, header=None, write_times='all')¶: store single series or list of series into excel

excel_retrieve_ts(excel_file, selection, ts_type, time=None, **args)¶: ” retrieve ts from excel file may return a single ts or list of ts.