Metadata-Version: 1.1
Name: dictsheet
Version: 0.0.11
Summary: Dict wrapper for google spreadsheet
Home-page: https://github.com/previa/dictsheet
Author: Chandler Huang, Xander Li
Author-email: previa@gmail.com
License: MIT License
Description: Dictsheet - Easy to use Google Spreadsheets Python API
        ======================================================
        
        Manage your spreadsheets in dict way. A easy to use Google spreadsheets Python API. Manage information in the sheet in rows. Based on gspread
        
        Features:
        
        - Manage the spreadsheet in dict way
        - Get/Set sheet mapping
        - Update a row or element(s) in a row.
        - Iterate rows in a spreadsheet.
        
        Requirements
        ------------
        
        - Python 2.6+ or Python 3+, gspread
        
        Install
        -------
        
        ``pip install dictsheet``
        
        Basic Usage
        -----------
        
        1. [Obtain OAuth2 credentials from Google Developers Console](http://gspread.readthedocs.org/en/latest/oauth2.html)
        2. Obtain the sheet title.
        3. Start using dictsheet
        
        Sample Code
        -----------
        
        ::
          
            import gspread
            from oauth2client.service_account import ServiceAccountCredentials
            from dictsheet import DictSheet
        
            # The Credential file obtained from Google
            CREDENTIAL_FILE = 'My Projecthah-xxxxxxx.json'
            #Title of the sheet
            SHEET_NAME = u'titleOfTheSheet'
        
            # Create credentials
            scope = ['https://spreadsheets.google.com/feeds']
            credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIAL_FILE, scope)
            # Use gspread to connect to Google Spread Sheet
            gc = gspread.authorize(credentials)
            sh = gc.open(SHEET_NAME)
            wks = sh.get_worksheet(0)
        
            # Initialize dictsheet
            dict_wks = DictSheet(wks=wks)
        
            # Basic usage
            # Get mapping
            print dick_wks.mapping
        
            # Set mapping
            map = {"name":1, "phone":2, "address":3}
            dict_wks.mapping = map
            
            # Appending
            dict_wks.append({"name": "Chandler Huang","phone": 987654321})
        
            # Updating (2 is the row number)
            dict_wks.update({2: {"name": "Kelly"}, 6:{"phone": 12345}})
        
            # Iterating
            for idx, dict_data in dict_wks.items():
            print idx, ' : ',dict_data
        
            # Clearing a row
            dict_wks[4].clear()
        
        
        
        Contributors
        ------------
        Chandler Huang, Xander Li
        
        Contact
        -------
        
        previa@gmail.com, x@xanderli.com
        
        
Keywords: dictsheet,spreadsheet,gspread
Platform: any
Classifier: Programming Language :: Python :: 2.6
Classifier: Programming Language :: Python :: 2.7
Classifier: Programming Language :: Python :: 3.0
Classifier: Programming Language :: Python :: 3.1
Classifier: Programming Language :: Python :: 3.2
Classifier: Programming Language :: Python :: 3.3
Classifier: Programming Language :: Python :: 3.4
Classifier: Programming Language :: Python :: 3.5
