populating the cells of a 10*1 column vector cell array

I wish to populate the above cell array where each cell is a 50*1 double

At the moment I hold the values of the ten 50*1 doubles in an excel spreadsheet

It has 10 rows and 50 columns

How do I populate the cells of my cell array ?

Bob M

Answer 1

[Voss]

You can try this, where filename is the (absolute or relative) path to your spreadsheet file:

M = readmatrix(filename); % M: 10x50 double (expected)

C = num2cell(M.',1).';    % C: 10x1 cell array; each cell contains a 50x1 double

Example:

M = reshape(1:500,10,[])

M = 10×50

1 11 21 31 41 51 61 71 81 91 101 111 121 131 141 151 161 171 181 191 201 211 221 231 241 251 261 271 281 291 2 12 22 32 42 52 62 72 82 92 102 112 122 132 142 152 162 172 182 192 202 212 222 232 242 252 262 272 282 292 3 13 23 33 43 53 63 73 83 93 103 113 123 133 143 153 163 173 183 193 203 213 223 233 243 253 263 273 283 293 4 14 24 34 44 54 64 74 84 94 104 114 124 134 144 154 164 174 184 194 204 214 224 234 244 254 264 274 284 294 5 15 25 35 45 55 65 75 85 95 105 115 125 135 145 155 165 175 185 195 205 215 225 235 245 255 265 275 285 295 6 16 26 36 46 56 66 76 86 96 106 116 126 136 146 156 166 176 186 196 206 216 226 236 246 256 266 276 286 296 7 17 27 37 47 57 67 77 87 97 107 117 127 137 147 157 167 177 187 197 207 217 227 237 247 257 267 277 287 297 8 18 28 38 48 58 68 78 88 98 108 118 128 138 148 158 168 178 188 198 208 218 228 238 248 258 268 278 288 298 9 19 29 39 49 59 69 79 89 99 109 119 129 139 149 159 169 179 189 199 209 219 229 239 249 259 269 279 289 299 10 20 30 40 50 60 70 80 90 100 110 120 130 140 150 160 170 180 190 200 210 220 230 240 250 260 270 280 290 300

C = num2cell(M.',1).'

C = 10×1 cell array
    {50×1 double}
    {50×1 double}
    {50×1 double}
    {50×1 double}
    {50×1 double}
    {50×1 double}
    {50×1 double}
    {50×1 double}
    {50×1 double}
    {50×1 double}

C{1}

ans = 50×1

1 11 21 31 41 51 61 71 81 91

C{2}

ans = 50×1

2 12 22 32 42 52 62 72 82 92