Yes, Anthony I'll do as you said. Thanks once again. On Tuesday, November 18, 2014 12:06:31 PM UTC+5:30, T.R.Rajkumar wrote: > > form_upload = SQLFORM.factory(Field('your_excel_file', 'upload', > uploadfolder='helloworld/uploads')) > if form_upload.process().accepted: > session.your_excel_file = form.vars.your_excel_file > > def import_from_excel(): > workbook = xlrd.open_workbook(session.your_excel_file) > > > When import_from_excel() is called gives rise to the below error. > How to access excel file stored in session? > > File "F:/trr/web2py/web2py/applications/helloworld/controllers/cms_meas.py" > <http://127.0.0.1:8000/admin/default/edit/helloworld/controllers/cms_meas.py>, > line 255, in import_from_excel > workbook = xlrd.open_workbook(session.your_excel_file) > File "D:\Python\lib\site-packages\xlrd\__init__.py", line 366, in > open_workbook > formatting_info=formatting_info, > File "D:\Python\lib\site-packages\xlrd\__init__.py", line 725, in __init__ > f = open(filename, open_mode) > TypeError: coercing to Unicode: need string or buffer, NoneType found > > > > >
-- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) - https://code.google.com/p/web2py/issues/list (Report Issues) --- You received this message because you are subscribed to the Google Groups "web2py-users" group. To unsubscribe from this group and stop receiving emails from it, send an email to web2py+unsubscr...@googlegroups.com. For more options, visit https://groups.google.com/d/optout.