How to print ( ) in mathlab

6 views (last 30 days)
dav
dav on 24 Apr 2014
Commented: dav on 25 Apr 2014
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.

Accepted Answer

dpb
dpb on 24 Apr 2014
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 Comments
Walter Roberson
Walter Roberson on 25 Apr 2014
cov = {val1;pnt1;val2;pnt3;val3;pnt5};
len = {val4;pnt2;val5;pnt4;val6;pnt6};
dav
dav on 25 Apr 2014
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'

Sign in to comment.

More Answers (0)

Categories

Find more on MATLAB Functions in Microsoft Excel in Help Center and File Exchange

Community Treasure Hunt

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

Start Hunting!