Downloaded excel files corrupted

However, as it is currently, the file becomes corrupt when downloaded. When downloaded, it opens fine in OpenOffice and derivates, but throws a "File is Corrupt" error on Microsoft Excel, and asks if the user wants to recover as much as it can.

When Excel is prompted to recover the file, it does so successfully, and the recovered Excel has all rows and data that is expected for the Excel file. Comparing the recovered file against opening the file in OpenOffice and derivates evidence no outstanding differences. The concrete Excel I am trying to download is generated with Apache POI in a microservice, then passed to the main backend and finally served to the frontend for the user to download.

Both the backend and microservice are written in Java, through Spark Framework. I made some tests on the backends, and concluded the problem is not the report generation nor the data transfer:. Asking the microservice to save the generated Excel in a file within the server and then opening such file hereby file A in Excel shows that file A is not corrupted.

Asking the main backend server to save the Excel file that it receives from the microservice in a file within itself and then opening such file in Excel hereby file B shows that file B is not corrupted. Downloading both file A and file B through FileZilla from their respective servers yields completely uncorrupted files. As such, I believe it is safe to assume the Excel becomes corrupted somewhere between the time the file is received on the frontend and the time the user downloads such file.

Read this blog to find more details about the error, possible reasons behind it, and solutions to fix the error. In addition, the blog mentions about Stellar Repair for Excel software that can help fix the Excel error in a few clicks.

Download the software now and see free preview of the file. Microsoft Excel is a widely used spreadsheet application that comes bundled with MS Office. Users tend to update the application with new security patches and features. Solution 1: Changing Component Services Settings. Solution 2: Changing the Protected View Settings. Viruses attached to the Excel files can attack and infect your system.

Be careful before using this option. And so, changing the setting may help fix the error. For this, perform these steps:. Restart the application and try opening the Excel file again. To repair corrupt Excel files, you need to use advanced options like Stellar Repair for Excel tool.

It repairs the corrupt and damaged Excel files and helps in retrieving lost data. The process is simple, and even a novice can use the Excel file repair tool to repair Excel files with the help of following steps:. Step 2: Launch the software. Her special focuses are data recovery, disk partitioning, data space optimization, data backup and Mac OS.

By the way, she's an aviation fan! It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair. Store Download Support Live Chat.

Workable Solutions Step-by-step Troubleshooting Fix 1. Full steps Fix 2. Full steps Fix 3. Full steps Fix 4. Full steps Fix 5. Use Excel Repair Tool consider using some Excel repair programs Full steps. Was This Page Helpful? Asked 1 year, 2 months ago. Active 1 year, 1 month ago. Viewed times. Vaibhav Vaibhav 51 5 5 bronze badges. Add a comment.

Active Oldest Votes. But when it comes to the warning message that tells the file is corrupted and cannot be opened, many people do not know how to rescue the valuable data in MS Excel.

In this article, 3 possible ways are discussed below. It is said that when you upgrade the Microsoft Excel, the protected view settings will change automatically. And for this reason, the Excel file would be corrupt and cannot be opened. Thus, you need to disable the protected view option in trust center of MS Excel.

In no time, you can get the details for the Protected View.