Borrar filtros
Borrar filtros

Save variables (vector) to a tabulated text file

32 visualizaciones (últimos 30 días)
Bill White
Bill White el 13 de Sept. de 2024 a las 15:05
Comentada: Ive J el 13 de Sept. de 2024 a las 16:58
I have several vectors of data in my workspace, say A,B,C,D.....
Is it possible to save / export these vectors in a single tabulated text file that can be opened in a spreadsheet (such as excel) in columns?
I would like the colums to have headers, with the name of the vector (A, B, C, D etc.), and if possible, the file to have a name that I can choose.
regards
W

Respuesta aceptada

Ive J
Ive J el 13 de Sept. de 2024 a las 15:11
A = randn(10, 1); B = randn(10, 1);
tab = array2table([A, B], VariableNames=["A", "B"]); % as a table
writetable(tab, "mytab.xlsx") % write to an Excel file
  2 comentarios
Steven Lord
Steven Lord el 13 de Sept. de 2024 a las 15:47
You're assuming that A and B have types that are compatible for concatenation. Instead I'd simply call table rather than concatenating and calling array2table. That doesn't assume or require that the types be concatenatable.
A = randn(5, 1);
B = randn(5, 1);
dt = datetime(2024, 9, randi(30, 5, 1));
tab1 = table(A, B, dt)
tab1 = 5x3 table
A B dt ________ ________ ___________ -0.83673 -0.15659 24-Sep-2024 0.40262 0.72619 08-Sep-2024 1.0433 -0.65305 03-Sep-2024 -0.51102 0.44775 01-Sep-2024 -1.5063 -0.46296 11-Sep-2024
tab2 = array2table([A, B, dt], VariableNames = ["A", "B", "dt"]) % won't work
Error using datetime/horzcat (line 715)
All inputs must be datetimes or date/time character vectors or date/time strings.
Ive J
Ive J el 13 de Sept. de 2024 a las 16:58
@Steven Lord fair point!

Iniciar sesión para comentar.

Más respuestas (0)

Categorías

Más información sobre Tables en Help Center y File Exchange.

Productos


Versión

R2024b

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by