Matlab Delimeter command corrupted Excel File
1 view (last 30 days)
Show older comments
I had a big issue with Matlab Delimeter Command recently. I applied delimeter command on my original thesis data file and I lost all my data. Can anyone out there help me regarding this? That excel file is not opening in excel now, shows error: file corrupted or extension changed. I tried opening Word and Notepad: It reflect : "d e l i m i t e r" text only on screen. Is there any solution in Matlab itself to get back my data? It's really urgent.
Thanks in Advance
2 Comments
Stephen23
on 3 Apr 2017
Edited: Stephen23
on 3 Apr 2017
MATLAB does not have a Delimeter command. Please show us the exact steps that you performed, and give us any relevant details of the data file (file format, size, number of worksheets, etc). If you want you could also upload the data file by clicking the paperclip button.
Accepted Answer
Jan
on 3 Apr 2017
You have overwritten the file's contents by the string 'd e l i m i t e r'. This can happen of a large number of different ways and we cannot guess how this has happened.
There is no way in Matlab to reconstruct the original contents. But you can restore the file from your backup. You do have a backup, don't you? If you are working in Windows, there is the "Recent Version" method in the Windows Explorer. If this does not work, the last chance is to dig in the contents of the hard disk - I had success with the freeware Recuva. But this can very time consuming.
If the file is important and solving this problem is really "urgent" for you, I really hope, that you have a backup. You know: "No backup, no mercy" :-(
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!