Upload Excel using web.py

Question

I have tried the following code by slightly modifying the example in documentation

class Upload():
  def POST(self):
    web.header('enctype','multipart/form-data')
    print strftime("%Y-%m-%d %H:%M:%S", gmtime())
    x = web.input(file={})
    filedir = '/DiginUploads' # change this to the directory you want to store the file in.
    if 'file' in x: # to check if the file-object is created
        filepath=x.file.filename.replace('\\','/') # replaces the windows-style slashes with linux ones.
        filename=filepath.split('/')[-1] # splits the and chooses the last part (the filename with extension)
        fout = open(filedir +'/'+ filename,'w') # creates the file where the uploaded file should be stored
        fout.write(x.file.file.read()) # writes the uploaded file to the newly created file.
        fout.close() # closes the file, upload complete.

But this works only for csv and txt documents. For Excel/pdf etc file gets created but it can't be opened (corrupted). What should I do to handle this scenario?

I saw this but it is about printing the content which does not address my matter.

alecxe · Accepted Answer · 2016-04-05 15:43:53Z

1

+50

You need to use wb (binary) mode when opening the file:

fout = open(filedir +'/'+ filename, 'wb')

answered Apr 5, 2016 at 15:43

alecxe

476k127 gold badges1.1k silver badges1.2k bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Marlon Abeykoon Over a year ago

Thanks it worked.. will you be able to explain further?

alecxe Over a year ago

@MarlonAbeykoon if you would use the w, on windows, you would get corrupted files when writing the uploaded content since the end-of-line characters are handled differently, see stackoverflow.com/questions/2665866/…. Hope that helps.

Collectives™ on Stack Overflow

Upload Excel using web.py

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related