I'm uploading files using boto:
self.s3_client.upload_file(filename, self.bucket_name, key)
I then generate url:
url = self.s3_client.generate_presigned_url(ClientMethod='get_object',
Params={'Bucket': bucket,
'Key': filename},
ExpiresIn=expires_seconds)
This URL is then passed to the users. I am having problems with XLSX files. After downloaded, either using the generated url, or directly downloaded from AWS S3 website, when I try to open the file with excel, I get this message:
Clicking No just abandons the attempt of opening the file, so I click Yes, and then it says it was able to open the file by repairing or removing the unreadable content and it gives me the following report:
Repair Result to mcx-x_4ede8f96-e381-11eb-a788-3a54d470f35a1.xmlErrors were detected in file '/mcx-x_4ede8f96-e381-11eb-a788-3a54d470f35a.xlsx'Removed Records: Formula from /xl/worksheets/sheet2.xml part
The file was generated by xlsxwriter, and it has just numbers, text, and dates. No formulas. Also, there should be no sheet named sheet2.
This doesn't look good for my application, and also I'm worried that maybe some data is getting lost, and the users will not get all the data they request.
What could be causing this problem?
Are there specific characters in the text that could be problematic?
What can I do?