MATLAB: Writting different length arrays in a CSV file

.csv filecell arraysvariable length

Hi All,

I have one variable with 19 cell arrays consists of different lengths (such as 1*26,1*30 etc). Now, I want to save them in a CSV or XLS or any other text format. But, I don't know how to save them as they have different lengths. Please kindly let me know, if is it possible? Or If I have to append NaN at the end of the lower lengths array. If So, How Can do that?

Please kindly give an example as I am not good with cell arrays.

Thanks

Best Answer

fid = fopen('YourOutputFile.txt', 'wt');
for K = 1 : length(YourCellArray)
   this_row = YourCellArray{K}:
   fprintf(fid, '%f,', this_row(1:end-1));
   fprintf(fid, '%f\n', this_row(end) );
end
fclose(fid);

Related Solutions

MATLAB: Reading a textfile without removing leading zeros

If you want to retain the leading zeros, you have to read them in as strings:

filename = 'NWISMapperExport.txt';
fidi = fopen(filename, 'rt');
D = textscan(fidi, '%s%s', 'CollectOutput',1);
Look = D{:}(1:5,2)                              % Check First Five Rows, Second Column
Look =
    5×1 cell array
      {'00152020'}
      {'00500460'}
      {'00501860'}
      {'02380002'}
      {'02380003'}

MATLAB: Writing to a CSV file

Possibly you just need to use cell array indexing:

   fid = fopen('Masonry.csv', 'wt');
   for n = 1:numel(numberRows)
      fprintf(fid, '%s', NameofTypeMasonry{n});
      fprintf(fid, '%s', CountryofTypeMasonry{n});
      fprintf(fid, '%s', CityofTypeMasonry{n});
      fprintf(fid, '%d', HeightofTypeMasonry{n});
   end
   fclose(fid)

Best Answer

Related Solutions

MATLAB: Reading a textfile without removing leading zeros

MATLAB: Writing to a CSV file

Related Question