Matlab Delimeter command corrupted Excel File

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

[Stephen23]

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.

[JAGRITI SAINI]

Matlab has Delimiter a command, I also got information about it in Matlab Help. I was just following a tutorial related to K-means classifier where they used delimiter command.

• My file was in excel format with extension.xlsx and it was containing features of EEG data in numerical form with manual entries in 4500 cells (300x15) with two additonal text assignment in rows and columns. However, i don't remember the exact file size but it must be around 3 MB with this much entries.

Answer 1

[Jan]

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" :-(

[JAGRITI SAINI]

Thanks for your kind response. unfortunately, I don't have a backup. So now I have decided to work on it again. That is the only option left. Anyway Thanks A lot.