MATLAB Answers

creat a excel file from matlab

조회 수: 298(최근 30일)
Cordelle
Cordelle 1 Jul 2013
I have data that I want to put in a excel file from matlab. the data is coming from a text file that I read in using textscan, here is my sample code:
fileID = fopen('passReport.EO1_2013_107_193146');
c = textscan(fileID, '%s')
fclose(fileID);
data = celldisp(c);
I want to take the data in the variable "data" and create a excel file with it

  댓글 수: 0

Sign in to comment.

채택된 답변

Evan
Evan 1 Jul 2013
편집: Evan 1 Jul 2013
The "xlswrite" command should do what you need:
help xlswrite
xlswrite allows you to control the file to which your data is written, the sheet within that file to which your data is written, and the specific cells to which your data is written. If a file with the name you provide does not already exist, a new one is created. Very handy function.

  댓글 수: 14

표시 이전 댓글 수: 11
Cordelle
Cordelle 2 Jul 2013
nevermind, it works. thank you
Evan
Evan 2 Jul 2013
The row/column limit for recent versions of excel is much higher than 852 rows, so I don't think excel would be the cause of your problem. Also, I had no trouble writing a random cell array of size 1000x200 to an excel file using xlswrite, so I don't think xlswrite would be the culprit. It sounds like it has something to do with your text file or the way you're reading it in, but I really can't say for sure.
Evan
Evan 3 Jul 2013
Oops, it looks like I either missed your last comment or we both posted at around the same time. Glad you have it working!

Sign in to comment.

추가 답변(1개)

Image Analyst
Image Analyst 2 Jul 2013
You can't send c into xlswrite or else it will put one character per Excel cell. You have to put the string into a cell first.
fileID = fopen('passReport.EO1_2013_107_193146');
c = textscan(fileID, '%s')
fclose(fileID);
caC = {c}; % Stick string into a single cell.
xlswrite(XLFileName, caC, 'A1');

  댓글 수: 1

Cordelle
Cordelle 2 Jul 2013
Thanks for the help, but a error message still occurred:
Error using xlswrite (line 220)
Error: Object returned error code: 0x800A03EC
Error in Untitled (line 14)
xlswrite(filename, caC, 'A1');
the data in the file is numeric data, do you think its not transferring to the excel file because we are trying to read a string?

Sign in to comment.


Translated by