Explore MATLAB source code curated for "excel" with clean implementations, documentation, and examples.
Implementation of Excel data manipulation capabilities including reading, deletion, addition, and modification functions using MATLAB development, with integration to Excel embedded in Word documents
This powerful MATLAB implementation demonstrates seamless integration with Microsoft Word and Excel through various practical examples, leveraging ActiveX/COM automation for enhanced productivity.
Source code for reading Excel spreadsheet data in MATLAB with comprehensive code implementation examples and detailed explanations.
Implementation of signal detrending using least squares method, including MATLAB code for data extraction from Excel files with real measurement data examples.
A MATLAB GUI application featuring file browsing capability for opening Excel files. The program utilizes listbox, edit, and button controls to extract data from Excel files and display it in separate name and score windows. Users can select single or multiple names in the name window to compare corresponding scores. The interface includes a file browser dialog for convenient file selection. This example specifically handles score.xls files structured with columns for name, Chinese, math, English, and multiple subject scores.
Hybrid programming between Excel and MATLAB using Exlink to implement regression and simulation analysis, along with several interpolation calculation mini-programs including Lagrange interpolation, Newton interpolation, and cubic spline interpolation methods.
This case study demonstrates how to use MATLAB for establishing measured natural gas operation rights in power plant portfolios, with risk assessment applications for New England power plants. The implementation involves MATLAB integration with Excel for comprehensive interface analysis. The application enables users to specify characteristics for 7 plant types, including capacity, heat rate, variable operations/maintenance costs, and minimum runtime parameters. Portfolio profitability and unit operation history can be backtested using simple dispatch strategies against historical natural gas and electricity prices. Risk metrics are computed through simulations implemented in MATLAB using gas and hybrid models, which simulate market prices for each dispatch scenario and calculate cash flows generated from plant operations based on projected electricity prices.
A comprehensive guide to exporting matrices from MATLAB to Excel files using built-in functions, featuring implementation examples for different scenarios and version-specific recommendations.