Can I "export", "write" or "save" a table to eg Excel ?

I want to write my table variable in eg .TXT file of a .XLSX . Can I do that ?

Answer 1

[Azzi Abdelmalek]

Use xlswrite

doc xlswrite
oc xlsread

[Michaël]

I've tried that ...

>> C = table(A,B)

C =

    A    B
    _    _

    1    4
    2    5
    3    6

>> xlswrite('test.xls',C) Error using xlswrite (line 166) Input data must be a numeric, cell, or logical array.

[Azzi Abdelmalek]

C={'A' 'B';1 4;2 5;3 6}
xlswrite('test.xls',C)

Answer 2

[Image Analyst]

You can use fprintf() if you want to write out a simple text file. See the help for an example. You can use xlswrite() as long as you aren't going to do it over and over again in a loop, which would be very slow. In that case use ActiveX (let me know if you want a demo).

[Michaël]

I would like a demo, because with a TABLE-variable it doesn't work without conversion to eg. a dataset-variable or a cell-array

[Image Analyst]

See attached file.