Batch Replacer for MS Excel is an utility which helps to make a multi-replacement operations in MS Excel files with the help of the MS Excel list. It can really save a great deal of time: no need to open each file and make the replacement and then open the other file and so on. All can be done in few seconds and as many files as you want may be involved.
The Java Excel Connector product allows Java developers to read, create or modify Excel documents. The library handles Excel workbooks, worksheets, cells and charts.
Using automation the connector allows an easy Microsoft Excel...
This is the power prediction analysis demo that was used in the "MATLAB for Excel Users" webinar. You can view the webinar at:
This demo requires only MATLAB, Statistics Toolbox,...
This is a demo of MATLAB Excel Builder. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder. This demo compiles a MATLAB code that depicts Univariate Interpolation into an Excel based COM...
XLSCOLSTR2NUM takes in a cellular array of characters and returns a array of numbers of the same size with elements corresponding to Excel column numbers.
See Also XLSCOLNUM2STR
This is a demo of MATLAB Builder for Excel. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder and use the same in Excel VBA. This demo compiles a MATLAB code that depicts a curve...
XLSRANGENAMES Returns a list of named ranges in an excel workbook
RangeNames = XLSRangeNames(filename)
RangeNames is a (n x 2) cell array with the name of the named range in
the first column and the value (aka location) in the...
This is a demo for MATLAB Excel Builder. This demo explains how one can compile MATLAB code into an Excel based COM component using MATLAB Excel Builder and use the same in Excel VBA. This demo compiles a MATLAB code that does basic matrix...
This is a MATLAB Excel Builder demo. This demo shows how you can compile a MATLAB code into an Excel based COM component and use the same in an Excel Visal Basic environment. The example used in this demo is the simulation of a bouncing ball using...
Attached report presents a brief overview of Excel Link.
This is a video demonstration tutorial
to be as an introduction to use MATLAB Excel Builder.
The attached file contains three m-file programs and
video file to show you how to make these programs active
into excel by...
The ZIP file contains the demo files used in the "MATLAB for Excel Users in Academia" Webinar recorded on May 25, 2007.
The demo is on Energy Usage Forecasting by performing basic descriptive statistics on historical energy...
A Simple GUI that pops up a selected sheet of excel.
1) save files in matlab path.
2) run test1.m.
heck if a particular excel file is currently open, if it is then maximize it to notify the user. this simple function can be used inside a more complex function to check the excel workbooks that are currently running, if they are not do something...
Rather simple tool to read all data from all sheets in an excel file. Output is a structure with organization:
Data.Sheet_Name.num - The numerical value content
Data.Sheet_Name.txt - The text in the sheet
Data.Sheet_Name.cel - Raw...
This function translates an index to the Excel A1 notation that is used in xlswrite.
function a1String = idx2A1(idx)
alphabet = 'ABCDEFGHIJKLMNOPQRSTUVWXYZ';
if idx < 27
This Function takes the current Matlab figure (gcf) and paste it into an existing Excel File.
PHP Dynamic Word/Excel Generator is an ultra easy-to-use php code for creating dynamic MS Word OR Excel files from a MySQL database query. Suitable for beginners to use.
MYSQL-LOGIN.PHP script allows you to make PHP generated web content available only to you.
This function was derived from a PHP code used on the administrative portion of a database driven site.
isLogged() returns true if...
SimpleModal Login provides a modal Ajax login for WordPress and utilizes jQuery and the SimpleModal jQuery plugin.
SimpleModal Login allows you to create your own custom themes. See the FAQ for details.