Calculate Excel Range 1.0

Date Added: August 11, 2013 | Visits: 507

Report Broken Link
Printer Friendly Version

Product Homepage
Download (49 downloads)

XLCALCRANGE(REFCELL,R,C,M,N) returns the full target range XLRANGE in Excel A1 notation to cover an array of size M rows & N columns and starting from an offset of R rows & C columns from REFCELL.Any workbookworksheet prefix is removed from REFCELL, as are any absolute '$' markers prior to range calculation.i.e.REFCELL = 'C:directorypath[filename.xlsm]worksheet1'!$P$6:$AC$91becomes:REFCELL = P6:AC91REFCELL can also be an Excel named range, but requires Matlab to already have the Excel workbook open in an actxserver process.Note: this file makes use of 2 functions: dec2base27.m & base27dec.m that were sourced from inside of Mathwork's function, xlswrite.mPlease let me know of any bugs

Requirements: No special requirements

Platforms: Matlab

Keyword: Actxserver, Base Decm, Calculationierefcell, Cdirectorypathfilenamexlsmworksheet Becomesrefcell, Dec Base, Function, Functions, Inside, Makes, Mathwork, Matlab, Named, Prior, Processnote, Refcell, Requires, Sourced, Workbook, Xlswritemplease

Users rating: 0/10

License: Freeware

Size: 10 KB

USER REVIEWS

More Reviews or Write Review

CALCULATE EXCEL RANGE RELATED

Miscellaneous - Pure PHP Spell Check 1.0 This package perform spell checking of text using only base PHP functions, thus without using specific spell check PHP extensions such as aspell or pspell. The class uses a dictionary that is implemented as an array-based binary search table. The...
Development Tools - Right ascension/declination to azimuth/elevation 1.0 Calculates azimuth and elevation angle in the local horizon system for a sky position given in equatorial coordinates (RA Dec J2000).Function Call: [Az El] = RADec2AzEl(350,58, '2008/02/18 13:10:00',60,15,0)Input:RA - Right ascension (J2000) of...	10 KB
Utilities - SCZ 1.7 SCZ application is a simple set of compression routines for compressing and decompressing arbitrary data. The initial set of routines implement new lossless compression algorithms. Restoration (decompression) is perfect. It is called SCZ, for...	14.34 KB
Utilities - PTM 0.5.0 Beta PTM is a Perl/HTML hybrid. An inline development language for those that need a bit more power behind the scenes. But more than that, it allows developers to harness Perls ability to manipulate strings of text and iterate loops many times faster...	35.84 KB
Libraries - Curses 1.15 Curses is a terminal screen handling and optimization. SYNOPSIS use Curses; initscr; ... endwin; Curses::supports_function($function); Curses::supports_contsant($constant); Curses is the interface between Perl and your systems...	81.92 KB
Desktop Utilities - Garmin BaseCamp for Mac OS 3.2.1 Features: View 24K or 100K topographic maps and other topographic data. Displays maps in 2-D or 3-D, including elevation profiles. View and rotate maps at any angle. Create waypoints and routes on your computer and transfer maps, waypoints,...	51 MB
Finance - Expressions 3.7.4 B1130 The filter module "Expressions" for data loggers is an interpreter for quick and easy evaluation of expressions. It is a smart tool easy in use. Supports different data types (string, date, time, decimal, float and boolean), arithmetic and boolean...
Finance - Expressions 3.7.7 Build 214 The filter module "Expressions" for data loggers is an interpreter for quick and easy evaluation of expressions. It is a smart tool easy in use. Supports different data types (string, date, time, decimal, float and boolean), arithmetic and boolean...
Development Tools - MATLAB/Simulink Unit Test Framework 1.0 Unit testing is a very powerful tool for maintaining high quality code. My code base consists of a mixture of matlab and simulink and this toolkit is an attempt to create a unified unit testing framework for my code. Unfortunately, the simulink...	10 KB
Modules - Power Menu 6.x-1.1-beta3 This module takes a similar aproach as does the menutrails module, but with a different UI. Power Menu takes the Drupal Core menu as base navigation. The user should be able to handle all navigation stuff from there without having to go to all...	20.48 KB

NEW DOWNLOADS IN SCRIPTS, DEVELOPMENT TOOLS

Scripts - Free Ecommerce website creator 1.2 Free Ecommerce website creator is a free PHP shop creating script. This allows you to put a online shop on your own website. Create your own free ecommerce website for Your Business. Create an online shop using easyGUI online shop creator. The...	1.44 KB
Scripts - MochiGames PHP Script ZDR 1.00 MochiGames PHP Script ZDR is web site, ready for use, for flash games. These flash games are downloaded automatically by "MochiGames PHP Script ZDR" from MochiGames media. The use of the games is free, you can use your own Mochi Publisher ID and...	368.54 KB
Scripts - Php Chat 2.0 Add a free php site, single sign-on and multiple skins, 100% free 1. Server Modes: The chat server has paid mode and free mode. If the free chat mode, a free chat room will be assigned to your website with your domain as the room name. 2....	938.87 KB
Scripts - Nibbleblog 3.0.1 Nibbleblog it's a powerful engine for creation and manipulation of BLOG's completely free. Very simple to install and configure (Only 1 step). The database used is based on XML files and this way it is not necessary to use MySQL or similar DBMS....	371.09 KB
Scripts - PHP File Manager \| CloudOsys 2.9b8 CloudOsys is a PHP file manager, a tool that allows your visitors upload files such as media content directly to your website. Your visitors will upload files directly to your website, where they can share and comment on them. Through cloud...	1.41 MB
Development Tools - Aml2CHM 3.50 Those who use the popular Aml Pages text editor might be looking out for a way of generating help files from their text and notes. Aml2CHM is a plug-in that was developed to offer people a quick and efficient way of converting Aml Pages documents...	549.99 KB
Development Tools - VMP Viewer 1.0 This is a very rudimentary tool to visualize the VMP files generated by BrainVoyager. Useful to share files with people who do not have BV.	10 KB
Development Tools - 7-Zip for Script 4.42 7-Zip is a file archiver with a high compression ratio.Features:- High compression ratio in new 7z format with LZMA compression- Supported formats:- Packing / unpacking: 7z, ZIP, GZIP, BZIP2 and TAR- Unpacking only: RAR, CAB, ISO, ARJ, LZH, CHM,...	624.64 KB
Development Tools - PHP Docbook Displayer for Scripts 1.0b PHP Docbook Displayer provides XSL and CSS stylesheets, and PHP scripts, to generate easily and dynamically websites from Docbook files.It aims at simplifying to the max the web publication process : simply drop the docbook file under the site root !	102.4 KB
Development Tools - WP Translate 1.0 This simple language translation plugin allows your users to quickly translate your webpages, through a widget on your blog.You have the option to select the title of the Widget, which will be displayed above the language translation form. Users...	10 KB

Windows Software	BeOS Software
Macintosh Software	Linux Software
PDA Software	OS/2 Software
Mobile Software	Scripts