How to create a table for CSV-Output from an array and strings?

Hello,

I have an N x N matrix of numerical values. I would like to export them as a .csv-file in such a way, that the table is already "captioned"(?) with text and be automatically input to Latex.

In other words I have this table: '' Label 1 Label 2 Label 3 X 1 2 3 Y 20 30 40

And I would like to save it as a .csv-file. I don't want to create the table manually, but I rather want to have it created automatically based on the size of the (pure numerical) input matrix.

Does anyone know how to do that?

Answer 1

[Mohammad Abouali]

Let's say myArray is your NxN matrix and colNames is a cell array storing the labels, i.e. colNames={'Label1','Label2',...,'LabelN'}

T=Array2table(myArray,'VariableNames',colNames);
writetable(T,'filename.csv');

That would save it in CSV format.

Then you can use csvsimple in latex and use \csvreader{filename.csv}{} in your table to automatically import it in a Latex.

[Aaron]

Thanks!