How to export cell array of strings and doubles in Excel?
    5 visualizzazioni (ultimi 30 giorni)
  
       Mostra commenti meno recenti
    
I am trying to export a cell array which contains both double and string elements with the xlswrite() function.

All the double elements were exported, but many string elements are missing. For instance, column 3 is supposed to have string elements and the empty cells between aaa and bbb should contain strings too. The size of the array I tried to export through the xlswrite() function is 723 x 25, so I was curious to know what is causing this error. I tested the same function on a smaller sized array m = {1, 'a', 'b';2, 'c', 'd';3, 'e', 'f';4, 'g', 'h'} and all the cell elements were exported in Excel. Is this error related to the size of array?
3 Commenti
  dpb
      
      
 il 20 Set 2018
				As G says, it's owing to the array structure.
>> help xlswrite
  xlswrite Write to Microsoft Excel spreadsheet file.
    xlswrite(FILE,ARRAY) writes ARRAY to the first worksheet in the 
    Excel file named FILE, starting at cell A1.
    ...   
    ...
    Input Arguments:
      FILE    Name of the file to write. ...
      ARRAY   Two-dimensional numeric or character array or, if each cell 
              contains a single element, a cell array.
      ...
NB: the last restriction on the output ARRAY
Risposte (0)
Vedere anche
Categorie
				Scopri di più su Spreadsheets in Help Center e File Exchange
			
	Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!

