Write matrix to a Tab-Delimited text file

83 次查看（过去 30 天）
Jake
Jake 2020-3-16
编辑： dpb 2020-3-17
Hello again,
I'm reading certain data from a csv file and I want to write some of the columns of the csv file to a tab delimited text file. So far, I have this;
[n, t, r] = xlsread('file.csv');
A = r(:,1);
L = r(:,5);
B = r(:,6);
M = [A, L, B];
And M is a 10×3 cell array. And it only contains numeric data.
I want to export this data to a tab delimited text file. Since I'm using MATLAB R2017a, I can't use writecell.
Any recommendations, documentations to refer of leads?
Thanks in advance!

请先登录，再回答此问题。

采纳的回答

Walter Roberson
Walter Roberson 2020-3-16
cell2mat(M) after which you can dlmwrite() with tab delimiter.

更多回答（1 个）

dpb
dpb 2020-3-16
  1. If are only numeric values in those three columns, then why not use the numeric return values from n instead? Depending on the structure of the spreadsheet, the column numbers may not be 1,5,6, but pick the ones needed instead.
  2. Use dlmwrite('youroutputfile.dat',cell2mat(M),'\t');
  3 个评论
显示 1更早的评论
dpb
dpb 2020-3-16
编辑：dpb 2020-3-17
xlsread will return only numeric columns in the first return argument w/o any text...
Jake
Jake 2020-3-17
That makes more sense now! I will try this to simplify things. Thank you!

请先登录，再进行评论。

类别

在 Help Center 和 File Exchange 中查找有关 Text Files 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by