回答済み
Conditional Formatting in Excel 2010
It's not clear what formatting you're trying to set. Also, you don't state how you used the Modify() method to generate the err...

約11年前 | 2

解決済み

Geometry: Find Circle given 3 Non-Colinear Points
*This Challenge is to determine the center and radius of a circle given three non-colinear points.* *Input:* Points *Outpu...

約11年前

回答済み
Problems with importing date and time from Excel to Matlab
xlsread seems to work fine, at least with small files. That seems to contradict your problem description. I created a simple t...

11年以上前 | 1

| 採用済み

回答済み
How can I set landscape and margins in word using matlab activex
wdOrientLandscape is part of an enumeration. It's value is actually 1. The proper usage for CentimetersToPoints should be ...

11年以上前 | 0

| 採用済み

解決済み

R2012b atan in Degrees
Return in degrees the atan result of inputs for all four quadrants. *Examples:* [x, y] Degrees 1 0 0 1 1 ...

11年以上前

回答済み
Insert multiple plots to excel sheets using ActiveX
First create as many sheets as you want (using Sheets.Add()). Then loop through your plots, calling Sheet1 = get(Sheets,...

11年以上前 | 0

| 採用済み

回答済み
speeding up a gaussian fitting....
I don't have time to work this in detail now, but here are my thoughts: 1. One way to speed the optimization would be to cal...

11年以上前 | 0

| 採用済み

回答済み
How can I add multiple charts in excel with activex
Here's how you can get the linear fit parameters (in Excel) without reading text strings from the trendline labels: K>> V =...

11年以上前 | 1

| 採用済み

回答済み
Get subpixel resolution images of a high resolution image
Here's what I would do. Assume |img| is your image. kernel = ones(N,N)/N^2;%Try N = 2, 3, or 4 all_imgs = conv2(img, ke...

11年以上前 | 0

回答済み
Custom Classes in Standalone Applications?
What's MRC? Perhaps you mean MCR? I've compiled some large GUIs that use a variety of my custom classes. My custom classes ...

11年以上前 | 0

回答済み
Experiences with release 2012b
I've done my share of complaining, so here are a few things I do like: 1. The new "Go to" dialog is great. I used to use th...

11年以上前 | 1

回答済み
Experiences with release 2012b
My biggest gripe with the ribbon interface is the enormous amount of screen space it wastes. But the ability to hide it and put...

11年以上前 | 7

回答済み
Error message with xlswrite after migrating to Windows 7
A couple thoughts: 1. I think the problem is you have not specified a path for your filename. My guess is that Excel is try...

11年以上前 | 0

回答済み
Read certain range of csv file
There are several ways to do this: 1. Using csvread: data = csvread('file.csv',251,0,'A252..D5352'); 2. Using dlm...

11年以上前 | 4

| 採用済み

回答済み
Retrieve a specific folder in outlook
You need to be aware of two things: 1. olFolderInbox should be the integer 6. 2. Indexing into VBA collections such as F...

11年以上前 | 2

| 採用済み

解決済み

Weighted average
Given two lists of numbers, determine the weighted average. Example [1 2 3] and [10 15 20] should result in 33.333...

12年弱前

回答済み
Help with class methods please
I think per isakson's answer is a bit simplistic. You should probably read up on the difference between Handle classes and Valu...

12年弱前 | 0

解決済み

Return the first and last character of a string
Return the first and last character of a string, concatenated together. If there is only one character in the string, the functi...

12年弱前

回答済み
Embed external files in published files
I don't know a lot about Matlab's built-in publishing capabilities, but I'd be surprised if what you are looking for is possible...

12年弱前 | 0

| 採用済み

回答済み
Plotting a function of 3 variables ?
See the documentation for scatter3. <http://www.mathworks.com/help/techdoc/ref/scatter3.html>) The last input argument lets you...

12年弱前 | 0

回答済み
spherical aberration and Chromatic aberration
The following code lets you simulate the PSF associated with spherical aberration (as well as diffraction). You need to specify...

約12年前 | 6

| 採用済み

回答済み
xlsread error
I would try using the Excel COM interface directly to see where Excel is struggling. It's interesting that it seems to be faili...

約12年前 | 1

回答済み
Read .mat file in android?
Here's another possibility: when saving the MAT file, use the -v7.3 option. Then the MAT file is actually an HDF5 file. You c...

約12年前 | 0

回答済み
OOP: matlab class as a property of another class
I think the following should work for setting this property from the Constructor function. The following assumes that you have ...

約12年前 | 0

| 採用済み

回答済み
Simple data extration from notepad
Here's an approach I would try: 1. Use csvread() to read in only the first two columns, the dates and times. 2. Use the da...

約12年前 | 0

| 採用済み

回答済み
program skills about Microsoft Excel, Word and so on
I'm assuming that by "moving around", you're looking to use Matlab to control which cells are selected. Something like the foll...

約12年前 | 1

| 採用済み

回答済み
Creating errorbars in excel
You're on the right track. Here's how to set all of the error bars to 5: [xlY, xlBoth, xlFixedValue] = deal(1); eC.Seri...

約12年前 | 1

| 採用済み

回答済み
word automation - adding / editing tables from matlab
I believe Columns is a Collection and that you need to do the following to access individual columns: newtable.Columns.Item...

約12年前 | 0

| 採用済み

回答済み
Print Figure to Word Document with Current Figure Size
I print figures to Word in a different way. First print the figure to a temporary file using something like temp_fname = [...

約12年前 | 0

| 採用済み

回答済み
Could you help me with FUNCTION syntax
I'm not entirely sure what you want this function to do. How about something like this? From the Matlab command prompt: x...

約12年前 | 1