How to write a table of into a binary file

Hi,

I have a table of many rows full of strings. How to write the table into a binary file by fwrite. I know how to write if it is numbers, but not if it is full of strings.

Thanks,

Jennifer

[Campion Loong]

Hi Jennifer,

Have you tried writetable?

Answer 1

[Walter Roberson]

Download http://www.mathworks.com/matlabcentral/fileexchange/34564-fast-serialize-deserialize

fid = fopen('YourOutputFile', 'w');  %not 'wt' !!
fwrite(fid, hlp_serialize(YourTable) );
fclose(fid);

Note: this answer assumes that you have given up your requirement from your previous question that the data be readable from Excel VBA code. Tables are a MATLAB object-oriented data structure that has no direct Excel equivalent, so if you needed the table to be readable from Excel VBA you would need to define the set of properties that need to be preserved and you would need to define limits on the varieties of MATLAB Tables that need to be represented.

[JFz]

Thank you so much! I will I will download. But I do need to read from an Excel file. I want to save the table into a binary file, then read it into an Excel file.

[Walter Roberson]

You need to define the set of properties that need to be preserved and you need to define limits on the varieties of MATLAB Tables that need to be represented.

You also need to investigate on the VBA side what you need to do to create the table structure that you need for whatever processing you are planning to do.

For my future reference: http://www.jkp-ads.com/Articles/Excel2007TablesVBA.asp