Community Profile


Richard de Garis

9 total contributions since 2011

Professional Interests: hedge fund investment and risk


Richard de Garis's Badges

  • Personal Best Downloads Level 1
  • First Review
  • 5-Star Galaxy Level 3
  • First Submission
  • Knowledgeable Level 1
  • First Answer

View details...

Contributions in
View by


Modification of the Matlab PIE function to account for label overlaps

5 years ago | 7 downloads |



Calculate Excel Range
Calculates full target range in Excel A1 notation.

7 years ago | 2 downloads |


Which GUI Building method for deploying a standalone application
Hi, Can a GUI created with GUIDE be compiled into a standalone application? If so, then do I include both the .m and .fig fi...

8 years ago | 1 answer | 0



How do you set the dimensions of an excel plot using activex from MATLAB?
I'm going from memory here but for sizing, you might try: Chart.ChartArea.Height = 100; % units are points, I think Char...

9 years ago | 0

How to find the first column without values in excel?
You can try the Excel Range.End property, starting with a cell in a range beyond your data that you know is empty and look back ...

9 years ago | 0

| accepted

Problem Deploying Excel Add-in using Builder EX: missing DLL files.
Thanks for your response. I've just spent a very frustrating day trying to get this to work, ultimately with no joy. Quest...

10 years ago | 0


Problem Deploying Excel Add-in using Builder EX: missing DLL files.
I'm very new to using the Builder EX toolbox and I'm finding the deployment not to be as straightforward as the User Guide sugge...

10 years ago | 2 answers | 0



How can I use use the index in a FOR loop in a string?
The above solutions are elegantly simple and will serve your current need perfectly. If in the future you require to iterate ...

10 years ago | 0

How do I generate the range of data to be written to in an excel sheet dynamically when using XLSWRITE in a loop in MATLAB 7.9 (R2009b) ?
If it helps, I just published a function on the File Exchange that will enable you to calculate Excel ranges if you know your st...

10 years ago | 0