清空筛选条件
清空筛选条件

convert .csv file to .xlsx?

63 次查看（过去 30 天）
ck
ck 2016-7-6
评论： Lev Vitkin 2023-6-29
How can I convert a .csv file to .xlsx file in matlab?
Thank you.

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

回答（2 个）

Walter Roberson
Walter Roberson 2016-7-6
You can use either csvread() or xlsread() to read the file, and then you can use xlswrite() to write the new file.
  3 个评论
显示 1更早的评论
Walter Roberson
Walter Roberson 2022-5-6
T = readcell(filename);
writecell(T, NewFileName)
Lev Vitkin
Lev Vitkin 2023-6-29
If some cells of the .csv table are empty, then T = readcell(filename) returns the cell array where the empty cells are replaced by 'missing'. And writecell(T, NewFileName) cannot process 'missing' cells.
Use the following instead:
T = readmatrix(filename,delimitedTextImportOptions('DataLines',[1,Inf]));
writecell(T, NewFileName);

请先登录，再进行评论。

Azzi Abdelmalek
Azzi Abdelmalek 2016-7-6
Look at this example
[~,~,a]=xlsread('your_file.csv')
b=regexp(a,',','split')
c=reshape([b{:}],numel(b{1}),[])'
xlswrite('new_file.xlsx',c)
  3 个评论
显示 1更早的评论
Carmen Ellenberg
Carmen Ellenberg 2022-5-6
Matlab always shows me a problem with the regexp funktion.
Does anybody have an idea?
Walter Roberson
Walter Roberson 2022-5-6
The third output of xlsread() is a cell array, and the entries in that cell can have different data types:
  • numeric
  • character vector
  • datetime object (not sure about this one)
The third output will not be pure character vectors, not unless the file contains only text and no empty cells.
regexp() can process the character vectors, but it cannot process numeric entries.
The regexp in that code would have limited value. All that it would change would be entries that were text in the file and had quoted commas, such as
3,5,"firefly, Oxford"
The other commas such as between the 3 and 5 would already have been used to figure out the cell boundaries for xlsread.
If you do have quoted commas then it is not obvious that you want them split.
That reshape is not doing anything useful compared to just using the [b{:}]
Overall I would recommend against using the suggested code.

请先登录，再进行评论。

类别

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

标签

Community Treasure Hunt

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

Start Hunting!

Translated by