{
    "info": {
        "author": "Chandler Huang, Xander Li",
        "author_email": "previa@gmail.com",
        "bugtrack_url": null,
        "classifiers": [
            "Programming Language :: Python :: 2.6",
            "Programming Language :: Python :: 2.7",
            "Programming Language :: Python :: 3.0",
            "Programming Language :: Python :: 3.1",
            "Programming Language :: Python :: 3.2",
            "Programming Language :: Python :: 3.3",
            "Programming Language :: Python :: 3.4",
            "Programming Language :: Python :: 3.5"
        ],
        "description": "Dictsheet - Easy to use Google Spreadsheets Python API\n======================================================\n\nManage your spreadsheets in dict way. A easy to use Google spreadsheets Python API. Manage information in the sheet in rows. Based on gspread\n\nFeatures:\n\n- Manage the spreadsheet in dict way\n- Get/Set sheet mapping\n- Update a row or element(s) in a row.\n- Iterate rows in a spreadsheet.\n\nRequirements\n------------\n\n- Python 2.6+ or Python 3+, gspread\n\nInstall\n-------\n\n``pip install dictsheet``\n\nBasic Usage\n-----------\n\n1. [Obtain OAuth2 credentials from Google Developers Console](http://gspread.readthedocs.org/en/latest/oauth2.html)\n2. Obtain the sheet title.\n3. Start using dictsheet\n\nSample Code\n-----------\n\n::\n  \n    import gspread\n    from oauth2client.service_account import ServiceAccountCredentials\n    from dictsheet import DictSheet\n\n    # The Credential file obtained from Google\n    CREDENTIAL_FILE = 'My Projecthah-xxxxxxx.json'\n    #Title of the sheet\n    SHEET_NAME = u'titleOfTheSheet'\n\n    # Create credentials\n    scope = ['https://spreadsheets.google.com/feeds']\n    credentials = ServiceAccountCredentials.from_json_keyfile_name(CREDENTIAL_FILE, scope)\n    # Use gspread to connect to Google Spread Sheet\n    gc = gspread.authorize(credentials)\n    sh = gc.open(SHEET_NAME)\n    wks = sh.get_worksheet(0)\n\n    # Initialize dictsheet\n    dict_wks = DictSheet(wks=wks)\n\n    # Basic usage\n    # Get mapping\n    print dick_wks.mapping\n\n    # Set mapping\n    map = {\"name\":1, \"phone\":2, \"address\":3}\n    dict_wks.mapping = map\n    \n    # Appending\n    dict_wks.append({\"name\": \"Chandler Huang\",\"phone\": 987654321})\n\n    # Updating (2 is the row number)\n    dict_wks.update({2: {\"name\": \"Kelly\"}, 6:{\"phone\": 12345}})\n\n    # Iterating\n    for idx, dict_data in dict_wks.items():\n    print idx, ' : ',dict_data\n\n    # Clearing a row\n    dict_wks[4].clear()\n\n\n\nContributors\n------------\nChandler Huang, Xander Li\n\nContact\n-------\n\nprevia@gmail.com, x@xanderli.com",
        "description_content_type": "",
        "docs_url": null,
        "download_url": "",
        "downloads": {
            "last_day": -1,
            "last_month": -1,
            "last_week": -1
        },
        "home_page": "https://github.com/previa/dictsheet",
        "keywords": "dictsheet,spreadsheet,gspread",
        "license": "MIT License",
        "maintainer": "",
        "maintainer_email": "",
        "name": "dictsheet",
        "package_url": "https://pypi.org/project/dictsheet/",
        "platform": "any",
        "project_url": "https://pypi.org/project/dictsheet/",
        "project_urls": {
            "Homepage": "https://github.com/previa/dictsheet"
        },
        "release_url": "https://pypi.org/project/dictsheet/0.0.11/",
        "requires_dist": null,
        "requires_python": "",
        "summary": "Dict wrapper for google spreadsheet",
        "version": "0.0.11"
    },
    "last_serial": 5603657,
    "releases": {
        "0.0.10": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "9743a9f858558b33c837b4acbba3208d",
                    "sha256": "1c8d21201cb57e0e26f37712d2e7ae9512806417050071bc79e605311f877290"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.10.tar.gz",
                "has_sig": false,
                "md5_digest": "9743a9f858558b33c837b4acbba3208d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6299,
                "upload_time": "2016-08-26T14:45:37",
                "url": "https://files.pythonhosted.org/packages/a0/12/6443e24c3afaf390fc8063ec3ac60036e36df48713b84988a55a507fcdfa/dictsheet-0.0.10.tar.gz"
            }
        ],
        "0.0.11": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "898038759634d931af5cf9f4ef86390e",
                    "sha256": "a9295188303afff2979c773e98a3ec08cfefb119338995d9cdb5c4d2826ee93d"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.11.tar.gz",
                "has_sig": false,
                "md5_digest": "898038759634d931af5cf9f4ef86390e",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 6683,
                "upload_time": "2019-07-30T04:43:52",
                "url": "https://files.pythonhosted.org/packages/27/d4/8e45dd97c6565f7cfa7a1d7e4440c233592ac7aa0edf8ad2aa3c1807f572/dictsheet-0.0.11.tar.gz"
            }
        ],
        "0.0.3": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "16462e2f3ed72a260352ac240317a74b",
                    "sha256": "2295e3fc3269e4e1044a19f6f6c3c561f258ea3962ec73f4547ee5660b84d4d8"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.3.tar.gz",
                "has_sig": false,
                "md5_digest": "16462e2f3ed72a260352ac240317a74b",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 927,
                "upload_time": "2016-08-23T09:23:45",
                "url": "https://files.pythonhosted.org/packages/a3/8d/e340dcf4991e8b3d9f59a06261a45a9ad0da586ad121c3784df881d7053c/dictsheet-0.0.3.tar.gz"
            }
        ],
        "0.0.4": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "bd46b0d396050573658a66e60f706f30",
                    "sha256": "7ba756b0e524f19f77eccf41158137321e2ebc84a15447c312c662f91d9594b5"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.4.tar.gz",
                "has_sig": false,
                "md5_digest": "bd46b0d396050573658a66e60f706f30",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5459,
                "upload_time": "2016-08-23T16:10:33",
                "url": "https://files.pythonhosted.org/packages/9b/64/727018c7aae2f2f72734b3cef5f399b401581b377ff256946f778c00d85d/dictsheet-0.0.4.tar.gz"
            }
        ],
        "0.0.5": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "95228f78ddc4eee7c1539dce8bfe62ad",
                    "sha256": "6e70b5ae43090fb4364c34d27bf32ceeaf3127af69d5cbfa0b0cb857479f874a"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.5.tar.gz",
                "has_sig": false,
                "md5_digest": "95228f78ddc4eee7c1539dce8bfe62ad",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5673,
                "upload_time": "2016-08-23T16:14:48",
                "url": "https://files.pythonhosted.org/packages/1c/73/87d48a9b6e1a1fbe14e22e5eccd265690cd50f5343e20c07ead9aa740dc3/dictsheet-0.0.5.tar.gz"
            }
        ],
        "0.0.6": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "ae25ca2bfe56d63ef7946a67d635e05d",
                    "sha256": "df3acbcbb95c0beab8fda73e0088ed5a5e6e081009016f41e0e56dd4941b8495"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.6.tar.gz",
                "has_sig": false,
                "md5_digest": "ae25ca2bfe56d63ef7946a67d635e05d",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5672,
                "upload_time": "2016-08-23T16:16:57",
                "url": "https://files.pythonhosted.org/packages/77/5c/bc3e1b4ea3a1140c6b25a93715b86b2534e99c8b15fb4bb1b5b2a5d4c397/dictsheet-0.0.6.tar.gz"
            }
        ],
        "0.0.7": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "4b512ce699296473b26d0529317889ef",
                    "sha256": "a9053fda60164ff29191eab7a2370f3fd462db6b4ca2fad91ae2366bb59374da"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.7.tar.gz",
                "has_sig": false,
                "md5_digest": "4b512ce699296473b26d0529317889ef",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5668,
                "upload_time": "2016-08-23T16:19:05",
                "url": "https://files.pythonhosted.org/packages/a3/57/606cda06480085c80df7de4320654ce3f8a885895334bad0d8ec78cdf6e9/dictsheet-0.0.7.tar.gz"
            }
        ],
        "0.0.8": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "afbd63040156d7a838dbed0b2b1e4346",
                    "sha256": "f543775f5cda98e79ddd876e792d1e3d70929b23753500a6d5fb29225426b228"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.8.tar.gz",
                "has_sig": false,
                "md5_digest": "afbd63040156d7a838dbed0b2b1e4346",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 5695,
                "upload_time": "2016-08-23T16:27:59",
                "url": "https://files.pythonhosted.org/packages/28/24/94e537d06e660a107d5bc3ae0d7334000041aa97cf989a5435619cdfba33/dictsheet-0.0.8.tar.gz"
            }
        ],
        "0.0.9": [
            {
                "comment_text": "",
                "digests": {
                    "md5": "8f9566ecafa066df45bbf45e8d1b52d5",
                    "sha256": "45dd6533771aaedc00d4cdb9035c12faf8c0f5ae132c358a81e05394aa7ca2d0"
                },
                "downloads": -1,
                "filename": "dictsheet-0.0.9.tar.gz",
                "has_sig": false,
                "md5_digest": "8f9566ecafa066df45bbf45e8d1b52d5",
                "packagetype": "sdist",
                "python_version": "source",
                "requires_python": null,
                "size": 7208,
                "upload_time": "2016-08-23T16:37:24",
                "url": "https://files.pythonhosted.org/packages/a4/3d/4fd9bfa3feba6fb97927927d6c24a637ea1187fe06dcce71ddb6acc13f40/dictsheet-0.0.9.tar.gz"
            }
        ]
    },
    "urls": [
        {
            "comment_text": "",
            "digests": {
                "md5": "898038759634d931af5cf9f4ef86390e",
                "sha256": "a9295188303afff2979c773e98a3ec08cfefb119338995d9cdb5c4d2826ee93d"
            },
            "downloads": -1,
            "filename": "dictsheet-0.0.11.tar.gz",
            "has_sig": false,
            "md5_digest": "898038759634d931af5cf9f4ef86390e",
            "packagetype": "sdist",
            "python_version": "source",
            "requires_python": null,
            "size": 6683,
            "upload_time": "2019-07-30T04:43:52",
            "url": "https://files.pythonhosted.org/packages/27/d4/8e45dd97c6565f7cfa7a1d7e4440c233592ac7aa0edf8ad2aa3c1807f572/dictsheet-0.0.11.tar.gz"
        }
    ]
}