Answered
ActiveX -- Saving Excel File
Does this give any errors or warnings? FileName='Test.xlsx'; %open Excel e = actxserver('Excel.Application'); ...

12 years ago | 0

Answered
calculate tangent of 1e100
Given that eps(1e100) = 1.9427e+84 it won't be that accurate. For what it's worth, sin(1e100)/cos(1e100) gives the ...

12 years ago | 0

| accepted

Answered
creating dummies from a cell vector of string variables
B=str2num(cellfun(@(x) x(end),A))

12 years ago | 0

Answered
Process Cells from Excel File
I think this is what you're after, but I'm not totally sure. A=[0 45 87 0 7 8 1 65 68 0 ...

12 years ago | 0

Answered
Finding the number of values bigger than a certain number in an array?
x=50*rand(7); a= x > 21; numel(a(a>0))

12 years ago | 0

| accepted

Answered
Can a popup-menu on GUI get an excel file sheet name to use as string?
[~,Sheets]=xlsfinfo(FileName) set(PopUpHandle,'String',Sheets)

12 years ago | 0

| accepted

Answered
Ascii to number/decimal
str2double(s) or str2num(s)

12 years ago | 0

| accepted

Answered
What's missing from MATLAB Central...
Aside from a spell checker, I find it a bit weird that the profiles aren't linked together, i.e. a user's Answers profile is sep...

12 years ago | 0

Answered
Neumann boundary condition in a first order PDE
In this case you want to set pr = 0; qr = -1/v; %to cancel out f

12 years ago | 0

Answered
array: concatenate two columns of integers to one colum
A=[1 2 3;3 5 7]; B=[7 8 9;4 5 6]; % C=[A B]; w=size(C,2); D=10.^(w-1:-1:0); Out=sum(bsxfun(@times,D,[A B]),2)

12 years ago | 0

Answered
How to apply a formula (autofill) on a range of cells in Excel using MATLAB COM activeX?
From your active worksheet: %data: DataRange = e.Activesheet.get('Range','A1:B1'); DataRange.Value=[1 2]; %equation: ...

12 years ago | 0

Answered
My reversed vector is outputting on five different lines in the command window. How can I output to just one line?
The '\n' is creating a new line each time there is a digit: fprintf('%d%d%d%d%d\n', C) should work.

12 years ago | 0

| accepted

Answered
How to read the value of a cell one-by-one?
I'm not completely sure what you mean, but to access the induvidual characters in each cell you just had to index within that ce...

12 years ago | 0

| accepted

Answered
reading data using textscan: how to record empty rows with muliple columns?
This is probably not too robust, and the numbers are still strings not numerics, but it picks up the empty spaces: str=filer...

12 years ago | 0

Answered
How to create a cell of strings from a vector?
Based on Sean De Wolski's answer: cellstr(num2str(x','%-0.0f'))

12 years ago | 1

Answered
I want to read a text file having strings and numeric data. Is there any better function than textscan?
This is quite scrappy but it gives you the data quite clearly in a cell array: n=5; %lines to skip A=fileread('TLETest.t...

12 years ago | 1

Answered
subplot with number on top of bar
You can use the annotation function to do this, there are a few ways to choose how to position the text. AX=zeros(4,1); for...

12 years ago | 0

Answered
I want to read a text file having strings and numeric data. Is there any better function than textscan?
What format do you want the data in? Using importdata gives you all the data as strings- you can convert the numeric data and sp...

12 years ago | 1

Answered
GUI axes size?
You could store the original axes size somewhere and reinstate that when required. For example, when the GUI loads you could sto...

12 years ago | 0

Answered
save workspace does not save some variables
I believe it is- try saying as a version 7.3 file. To do that you just add '-v7.3' when you are sending to the save function, se...

12 years ago | 0

| accepted

Answered
retrieve mat-file version
type(FileName) should work fine, where FileName is a string containing the file name, e.g. FileName='myfile.mat'

12 years ago | 2

Answered
problem with repeating index values
This avoids using a loop, but it might be more limited than what you require. I extended the indexing array so you can a bit mo...

12 years ago | 0

Answered
problem with repeating index values
I'm not 100% sure what you're trying to do, but is this what you're after? a = [0 0 0 0]; Index=[1 1 2 2 2]; for n=1:numel...

12 years ago | 0

Answered
How can I incorporate a user input variable as part of a variable name?
You can just concatenate the strings: importdata([XY,'_left_ribs_1.txt'])

12 years ago | 2

| accepted

Answered
Why pause(eps) takes much time?
It's just a limitation of the function- see the pause documentation: <http://www.mathworks.com/help/techdoc/ref/pause.html?nocoo...

12 years ago | 1

Answered
Remove Image Titles in GUI
You need to reset the axes: cla('reset') or better for a GUI: cla(axes_handle,'reset')

12 years ago | 0

| accepted

Question

Semi-repeatable Cellfun Error
I'm quite thrown by this problem: I have a line which crops up in a few functions within a program, which uses cellfun to conver...

12 years ago | 1 answer | 0

1

answer

Answered
Enable datacursor for certain axes
The datatip won't show up if you hide the axes handle,e.g. AX(1)=subplot(2,1,1); plot(rand(10,1)) AX(2)=subplot(2,1,2); ...

12 years ago | 1

Answered
Why is the autocolor green of plot not the same as plotting 'g'?
I have no idea why, but you can set the colour manually: plot(x,y,'color',[0 0.5 0]) or, for that matter, use any 1x3 ve...

12 years ago | 1

| accepted

Answered
How to split string with numbers?
Str='1,2,3,4;5,6,7,8;9,10,11,12'; Num=str2double(regexp(Str,'\d*','match')')

12 years ago | 1

| accepted