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

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

ongeveer 11 jaar ago

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

ongeveer 11 jaar ago | 1

| accepted

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

meer dan 11 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 ...

meer dan 11 jaar ago

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

meer dan 11 jaar ago | 0

| accepted

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

meer dan 11 jaar ago | 0

| accepted

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

meer dan 11 jaar ago | 1

| accepted

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

meer dan 11 jaar ago | 0

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

meer dan 11 jaar ago | 0

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

meer dan 11 jaar ago | 1

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

meer dan 11 jaar ago | 7

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

meer dan 11 jaar ago | 0

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

meer dan 11 jaar ago | 4

| accepted

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

meer dan 11 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...

bijna 12 jaar ago

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

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

bijna 12 jaar ago

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

bijna 12 jaar ago | 0

| accepted

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

bijna 12 jaar ago | 0

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

bijna 12 jaar ago | 6

| accepted

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

ongeveer 12 jaar ago | 1

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

ongeveer 12 jaar ago | 0

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

ongeveer 12 jaar ago | 0

| accepted

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

ongeveer 12 jaar ago | 0

| accepted

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

ongeveer 12 jaar ago | 1

| accepted

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

ongeveer 12 jaar ago | 1

| accepted

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

ongeveer 12 jaar ago | 0

| accepted

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

ongeveer 12 jaar ago | 0

| accepted

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

ongeveer 12 jaar ago | 1