Operate on handles that represent the Excel application, workbooks, and worksheets. One suggestion I have for improvement is to convert this into a class, instead of a suite of functions. The editor will highlight the same variables, so you can In fact, if you open the files in the MATLAB Editor, you can place the cursorĪt one of the handle variables to see how they are used or created. How the functions are related to each other. Each of these functions take in various handles (Excel application, workbook, or worksheet) as inputs, so it's easy to understand He uses intuitive function names, such as XConnect, XOpenBook, and XAddSheet. I chose to highlight Yvan's X Collection, because he provides a suite of functions for performing various simple tasks withinĮxcel, using ActiveX. Sure enough, I found quite a few entries, including this one (and many others) by our very own Brett Shoelson. I started browsing the File Exchange in hopes for finding additional examples that I could point people to for using actxserver with Excel. The reference page for actxserver has an example for connecting to Excel. Once connected to Excel, he can use the various APIs that are provided by Excel to customize. I pointed him to theįunction actxserver, which provides a way to connect to Windows® applications using ActiveX. Specifically, he wanted to change the width of a column and some of the cell colors. The person wanted the ability to control the formatting of cells, which xlswrite does not provide. In the training, we talk about functions like xlsread and xlswrite. Recently during my MATLAB Fundamentals training course, I received a few questions regarding how to exchange data between They feel comfortable in applying the tools in their day-to-day work. I get to take people who have never used MATLAB or Simulink to the point where My day job is a customer training engineer. Click here for MATLAB Online Training.Jiro's pick this week is The X Collection by Yvan Lengwiler. This training can be used by beginning users, as well as those looking for more in-depth training. Need help getting started? Check out MATLAB Onramp to learn MATLAB is under 2 hours.ĬCSU's MATLAB site license gives all students, faculty, and staff access to hands-on learning through Online Training Courses (at no extra cost). MATLAB is also available in two places on the Remote Application Server ( ) - directly on the Apps tab, as well as, on the Desktops tab, go to the General Lab folder which will log you directly into a campus computer. Complete the form click Review & Submit confirm the information and click Submit.Search for "Software Installation" and select the Software Installation Request for Classrooms and Labs form.Login with your CCSU email address and password.How to Request and Access:Ĭlick here for instructions on how to download and install on personally-owned computers.Ĭampus Classrooms and Labs: Installation can be requested via the Service Request form: The license provides access for all CCSU students, faculty, and staff on all university-owned, as well as, personally-owned, computers. It allows for matrix manipulations, plotting of functions and data, implementation of algorithms, and creation of user interfaces.ĬCSU currently has a campus-wide license available for MATLAB (Windows and Mac). MATLAB Software is a multi-paradigm computing environment.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |