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...

meer dan 9 jaar ago | 2

Solved

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...

meer dan 9 jaar ago

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...

meer dan 9 jaar ago | 1

| accepted

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 ...

bijna 10 jaar ago | 0

| accepted

Solved

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 ...

bijna 10 jaar ago

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,...

bijna 10 jaar ago | 0

| accepted

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...

bijna 10 jaar ago | 0

| accepted

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 =...

bijna 10 jaar ago | 1

| accepted

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...

bijna 10 jaar ago | 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 ...

bijna 10 jaar ago | 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...

bijna 10 jaar ago | 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...

bijna 10 jaar ago | 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...

bijna 10 jaar ago | 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...

ongeveer 10 jaar ago | 4

| accepted

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...

ongeveer 10 jaar ago | 2

| accepted

Solved

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

ongeveer 10 jaar ago

I think per isakson's answer is a bit simplistic. You should probably read up on the difference between Handle classes and Valu...

ongeveer 10 jaar ago | 0

Solved

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...

meer dan 10 jaar ago

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...

meer dan 10 jaar ago | 0

| accepted

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...

meer dan 10 jaar ago | 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...

meer dan 10 jaar ago | 5

| accepted

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

meer dan 10 jaar ago | 1

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...

meer dan 10 jaar ago | 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 ...

meer dan 10 jaar ago | 0

| accepted

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...

meer dan 10 jaar ago | 0

| accepted

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...

meer dan 10 jaar ago | 1

| accepted

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...

meer dan 10 jaar ago | 1

| accepted

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...

meer dan 10 jaar ago | 0

| accepted