Hello,
I am running a matlab code which writes output to an excel file.
I would like to write * each output value inside a parenthesis * . Is there an easy way to do this?
Code I use:
results = zeros(5,10);
for i = 1:10
results(1,i)= avxt(i);
results(2,i)= stdxt(i);
results(3,i)= avxtl(i);
results(4,i)= stdxtl(i);
results(5,i)= afxtPI(i);
end
xlswrite('output.xlxs', results, 'sheet1', 'A1:H5'
Thanks.

 採用された回答

dpb
dpb 2014 年 4 月 24 日

1 投票

results = zeros(5,10);
results(1,:)= avxt;
...
etc., etc., ...
You will need a .' to transpose if they're column rather than row vectors, of course.
What sort of precision do you want/need in the spreadsheet? Writing the values as numeric stores the full precision automagically whereas if you convert to string to show the parens you'll have to select some formatting.
Then place the result to a cell array after using sprintf() to output the desired format.
>> sprintf('(%.3f)',pi)
ans =
(3.142)
>>
doc sprintf % for details.
NB you will have to write each element to a cell. cellfun should be useful here

3 件のコメント

dav
dav 2014 年 4 月 25 日
Thanks. Well I tried the following code to do a table in matlab and it gave me the given error: Is there anyway to correct it please?
results = zeros(5,h);
for i = 1:h
results(1,i)= avxt(i);
results(2,i)= stdxt(i);
results(3,i)= avxtl(i);
results(4,i)= stdxtl(i);
results(5,i)= afxtPI(i);
end
results
pnt1 = sprintf('(%.4f)',results(2,1));
pnt2 = sprintf('(%.4f)',results(4,1));
pnt3 = sprintf('(%.4f)',results(2,10));
pnt4 = sprintf('(%.4f)',results(4,10));
pnt5 = sprintf('(%.4f)',results(2,20));
pnt6 = sprintf('(%.4f)',results(4,20));
cov = [val1;pnt1;val2;pnt3;val3;pnt5];
len = [val4;pnt2;val5;pnt4;val6;pnt6];
Tbl = table(cov,len)
Error:
Error using vertcat
CAT arguments dimensions are not consistent.
Error in prnt (line 470)
cov = [val1;pnt1;val2;pnt3;val3;pnt5];
Walter Roberson
Walter Roberson 2014 年 4 月 25 日
cov = {val1;pnt1;val2;pnt3;val3;pnt5};
len = {val4;pnt2;val5;pnt4;val6;pnt6};
dav
dav 2014 年 4 月 25 日
thanks. I think it worked. However I got the following error. am i not using it correct?
Error:
Undefined function 'table' for input arguments of type 'cell'

サインインしてコメントする。

その他の回答 (0 件)

質問済み:

dav
2014 年 4 月 24 日

コメント済み:

dav
2014 年 4 月 25 日

Community Treasure Hunt

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

Start Hunting!

Translated by