Re: [web2py] Read an excel file without uploading it

Here a primer to xlrd : http://scienceoss.com/read-excel-files-from-python/ And a documentation ressource : http://www.simplistix.co.uk/presentations/python-excel.pdf I think that you will need to upload the excel file repeatedly (until it pass validate_and_insert) except if you build your own v

Re: [web2py] Read an excel file without uploading it

I need to do something very similar, but didn't have time to work on it... But my search on the question bring me to discover : validate_and_insert, validate_and_update http://web2py.com/books/default/chapter/29/6?#validate_and_insert,-validate_and_update So you process the rows contained in you

[web2py] Read an excel file without uploading it

I want to import data from excel sheets to the database in web2py. I wish to validate the excel sheet before importing data from it.My table structure is similar to db.define_table('xlsheets',Field('name'),Field('xl','upload'),Field('filename')) >From this table, i will obtain the filename field