Home       Trees       Indices       Help   
Package tlib :: Package base :: Module XlsModerator :: Class XlsModerator
[hide private]
[frames] | no frames]

Class XlsModerator

source code

object --+
         |
        XlsModerator

Helper class for excel data operations on excel spread sheet

Instance Methods [hide private]
 
__init__(self, path, isFirstRowHeader=True)
Constructor for class		 source code
 
xls2dict(self, sheet=None, isFirstRowHeader=True)
Convert excel data to dictionary (key for sheet name), the result will be stored in data attribute		 source code
 
get_sheet_data(self, sheet)
Get the excel sheet data on specific sheet		 source code

Inherited from object: __delattr__, __format__, __getattribute__, __hash__, __new__, __reduce__, __reduce_ex__, __repr__, __setattr__, __sizeof__, __str__, __subclasshook__

Class Variables [hide private]
  _data = {}
  _path = None
Properties [hide private]
  data
The excel data extracted from the file

Inherited from object: __class__

Method Details [hide private]

__init__(self, path, isFirstRowHeader=True)
(Constructor)

source code 

Constructor for class

Parameters:
  • path - path to the excel file
  • isFirstRowHeader - is the first row of the excel file a header row? If true, the return result for reach row will be dictionary, otherwise, it will be a list
Overrides: object.__init__

xls2dict(self, sheet=None, isFirstRowHeader=True)

source code 

Convert excel data to dictionary (key for sheet name), the result will be stored in data attribute

Parameters:
  • sheet - name of the specific sheet to fetch the data
  • isFirstRowHeader - is the first row of the excel file a header row? If true, the return result for reach row will be dictionary, otherwise, it will be a list

get_sheet_data(self, sheet)

source code 

Get the excel sheet data on specific sheet

Parameters:
  • sheet - name of the sheet to fetch the data
Returns:
a list of data from the specified sheet or empty list if no sheet found

Property Details [hide private]

data

The excel data extracted from the file

Get Method:
unreachable.data(self) - The excel data extracted from the file

   Home       Trees       Indices       Help   
Generated by Epydoc 3.0.1 on Tue Aug 26 11:35:12 2014 http://epydoc.sourceforge.net