回答済み
Delete selected worksheet from Excel
You don't seem to be following the path I laid out but reinventing the wheel and changing coding styles... The thread <Excel Ut...

3年以上前 | 0

回答済み
R-squared analysis of scatter plot resulting in NaN
'Pends on how you did it -- show your code for exact answer to that direction, but -- If you have the Statistics TB, then use ...

3年以上前 | 1

回答済み
merge six columns with zeros step by step end of each one
It would be far easier to write code if you would use cell array for the existing data instead of a bunch of named variables -- ...

3年以上前 | 0

| 採用済み

回答済み
How do I run the function for each value in array?
clear global Tth1 Tth2 A B data= ... Therein lies your problem -- you wrote a script instead of a function -- get rid of th...

3年以上前 | 0

| 採用済み

回答済み
how to copy sheet from one excel to another sheet of excel.
OK, here's a barebones routine that works to duplicate the given sheet, placing it after the copied one and names it to the requ...

3年以上前 | 0

| 採用済み

回答済み
How can I edit code so only bottom graph is displayed.
W/o the data and w/o knowing what didn't work, the simplest way to just get the second plot alone by itself would be to just dra...

3年以上前 | 0

回答済み
How to Extract ROI on a signal with additional rows before and after threshold
It's gotten too convoluted -- yes, the original answer does, as noted in the last comment, only return the first/last -- your or...

3年以上前 | 1

| 採用済み

回答済み
How to remove one single quote at the beginning of a string?
The MATLAB function to retrieve the extension and filename is fileparts and to rebuild a new one is fullfile But, in this case...

3年以上前 | 0

回答済み
Multi Colors and Legend for each bar
Slightly different, using a colorbar is nice alternative; legend is somewhat problematical owing to design of bar in that it's o...

3年以上前 | 0

| 採用済み

回答済み
how to copy sheet from one excel to another sheet of excel.
Had a few minutes so poked around a little as explained above... Excel = actxserver('Excel.Application') excelFullFileName=ful...

3年以上前 | 0

回答済み
Change value based on the values of another column
If there's always at least one zero before the new -ive value excepting the initial element, then ix=find(diff(sign([0;x]))==-1...

3年以上前 | 0

回答済み
Creating vector of labels
pics_ds = ones(size(pics_ds)); words_ds = -ones(size(words_ds)); MATLAB reallocates the LHS variable when not subscripted to ...

3年以上前 | 0

回答済み
How and when to apply calibration to my pressure measurements (calibration factor is available)?
Calibrate/convert the time signal to pressure units as the very first step.

3年以上前 | 0

| 採用済み

回答済み
Saving Each Table Within a Structure as its Own Entity
"I want to split this table into N=4 smaller tables:..." Again, that's the wrongheaded approach -- it can (and should) be done ...

3年以上前 | 0

| 採用済み

回答済み
How do you write a loop for a variable that will list 6 rows but you want the equation to apply for those 6 rows and 30 rows after each of them
nAddLines=30; for i=1:numel(RA4) ix1=RA4(i); ix2=ix1+nAddLines; XError(?)=abs(COMArray(ix1:ix2,1))-abs(New_COM(ix1:ix2...

3年以上前 | 0

回答済み
How to Extract ROI on a signal with additional rows before and after threshold
Revised to match the figure and new understanding of intent to isolate one transient and select ROI around it -- the second trac...

3年以上前 | 0

回答済み
Reading a set of numeric values from 100s of .txt files inside a folder
Alternatively, just as an experiment, wonder how it would work using some of the more recently introduced features -- foldernam...

3年以上前 | 0

回答済み
How to build up linear functions in MATLAB and plot the?
% the lookup table/interpolant function... y=[0 0.25 0.30 0.55 0.6 1]; x=[0 0.05-eps(0.05) 0.05 0.25-eps(0.25) 0.25 0.6]; %...

3年以上前 | 1

回答済み
How to insert both value and percentage in pie chart?
That's another terrible user interface/oversight to go along with bar -- hadn't ever used it in MATLAB before; pie charts just a...

3年以上前 | 0

| 採用済み

回答済み
combine two cell into one string
opt=detectImportOptions('SummaryResult - Copy.xlsx'); opt.VariableTypes(1:2)={'char'}; tG=readtable('SummaryResult - Copy.xlsx...

3年以上前 | 1

回答済み
How to import multiple variable starting the same from excel?
Guessing from the above code snippet, try something like W1_data= readtable(waffer1); isDrainVar=startsWith(W1_data.Properties...

3年以上前 | 1

回答済み
Set one common Xaxis for a sublot with rows = 1 and columns = 2
I overlooked the labels in the original Q? body and thought was to have a combination axis itself of some sort based on title --...

3年以上前 | 0

| 採用済み

回答済み
regstats The design matrix has more predictor variables than observations.
The problem is NOT that there are NaN or Inf in the data (although that could also be a cause since they're treated as missing v...

3年以上前 | 0

回答済み
how to plot using surf function?
osmotisk_data = readtable("tester_tabeller.xlsx"); x = osmotisk_data{:,3}; y = osmotisk_data{:,1}; z = osmotisk_data{:,2}...

3年以上前 | 0

回答済み
How do I change the tick label rotation on my colorbar?
They've hidden some of the ruler properties -- you have to use/access the underlying numeric ruler properties -- cb.Ruler.TickL...

3年以上前 | 2

| 採用済み

回答済み
Output argument 'ENA' is not assigned on some execution paths
1, You don't have an else clause so it is possible to select a set of inputs the combination of which will not satisfy any of t...

3年以上前 | 0

回答済み
How to ensure that MATLAB reads the first column as a column in a table?
rownames are table metadata; they are NOT a variable which is why the column variable heading doesn't show up for them -- the ta...

3年以上前 | 0

回答済み
dividing a distance double by a duration time to get rate
A datenum is a double; you must mean a datetime -- subtracting them does create a duration type/class, yes. There are some wart...

3年以上前 | 0

| 採用済み

回答済み
How to detect and manage occurrencies in a large .csv file?
Start perhaps with something like >> tAst=readtable('table.csv'); tAst.S_C=categorical(tAst.S_C); tAst.Sol_inters=categorical...

3年以上前 | 0

| 採用済み

回答済み
How to map one array elements to another array elements?
>> awardCoef=[-10,50]; >> conc=polyval(awardCoef,feederNum) conc = 40 30 30 10 20 40 >> More genericall...

3年以上前 | 0