.mat to .xls conversion?

Question

how to convert .mat file into .xls format.

I tried xlswrite command in matlab but it does not work.

Answer 1

How to Convert MAT to XLS

http://www.ehow.com/how_6818858_convert-mat-xls.html



and :

http://www.mathworks.in/help/matlab/ref/xlswrite.html

Answer 2

A .mat file is a Matlab file. You cannot convert it directly to .xls.



- Read the .mat file.

- Locate exactly the variables (matrices, vectors) within Matlab

- Use function xlswrite to write to Excel.



As an experiment, create a short vector in Matlab and write it to an Excel file.

Later, create a matrix and write it to Excel.

Do something easy to understand the concept.

Then, add the step of reading the .mat file.

Answer 3

For the best answers, search on this site https://shorturl.im/av0cs



If the original mechanism is written in VB then you can simply use the Excel library for VB and convert the CSV file to an XLS file type and protect it to the extent needed. If the original mechanism isn't written in VB, then you'd likely need to write a separate program to do the file conversion. Another alternative would be to take an Excel file and use Data Import feature to create a link to the CSV file - and simply use the data source to update the content of the new Excel file any time the CSV file is regenerated.

Answer 4

Mat To Csv

Answer 5

Based on what you've said here it seems to me that the optimal solution would be to import the .csv data into a database, then use whatever reporting methodology you prefer to query. If the client has explicitly stated that using a DB is out of the question, or that final output is to be in excel format, you may consider using some excel VBA to massage the data into the required shape, handle what is and isn't viewable, etc.

Answer 6

save as csv in matlab and then load in excel