Forum Discussion

Flya's avatar
Flya
Explorer | Level 4
8 years ago
Solved

Malformed file when uploading excel file with python sdk

Hi there,

I get a malformed file when I try upload a simple excel file with python sdk

my code looks like:

xls = 'Path\\xxxxx.xlsx'		
	try:
		with open(xls, 'r') as upxls:
			dbx.files_upload(upxlsx.read(),'/test.xlsx', mode=dropbox.files.WriteMode("overwrite"))
     except Exception as e:
	    print e	

Is there a bug in my code or the dropbox python module?

  • You probably need to use open(xls, 'rb') instead of open(xls, 'r'). (Note the 'b' in the mode.) Try that out and let me know if it doesn't help.
  • Greg-DB's avatar
    Greg-DB
    Icon for Dropbox Staff rankDropbox Staff
    You probably need to use open(xls, 'rb') instead of open(xls, 'r'). (Note the 'b' in the mode.) Try that out and let me know if it doesn't help.
    • LiamGM's avatar
      LiamGM
      New member | Level 2

      Having the same issue, using the same code OP uses and I tried open(xls,'rb') but it's still coming out as corrupted. Any ideas how to sort it?

About Dropbox API Support & Feedback

Node avatar for Dropbox API Support & Feedback
Find help with the Dropbox API from other developers.5,941 PostsLatest Activity: 2 hours ago
350 Following

If you need more help you can view your support options (expected response time for an email or ticket is 24 hours), or contact us on X or Facebook.

For more info on available support options for your Dropbox plan, see this article.

If you found the answer to your question in this Community thread, please 'like' the post to say thanks and to let us know it was useful!