Download Shareware and Freeware Software for Windows, Linux, Macintosh, PDA

line Home  |  About Us  |  Link To Us  |  FAQ  |  Contact

Serving Software Downloads in 976 Categories, Downloaded 31.339.997 Times

readfromexcel 1.0

  Date Added: August 18, 2013  |  Visits: 271


Report Broken Link
Printer Friendly Version

Product Homepage
Download (18 downloads)

VARARGOUT = READFROMEXCEL(FILELOC,VARARGIN) Uses ActiveX commands to read range(s) from an existing Excel spreadsheet. FILELOC: Enter a string representing the (absolute or relative) location of an Excel file. (Extension may be omitted, and will be assumed to be .xls.) Examples: 'c:brettmy archivestest1.xls' 'test1.xls' 'myarchive' SHEETNAME: (Optional): Any occurrence in the variable argument list of the strings 'sheetname' or 'sheet' prompts the function to change active sheets to the value in the following variable. That specifier must be a string argument matching exactly the name of an existing sheet in the opened file. If this argument is omitted, the function defaults to reading from the currently active sheet. RANGE SPECIFIER(S): Enter the range(s) to read. The values stored in these ranges will be returned in consecutive output arguments. Example: 'B1:B5' 'B1:B1' (or simply 'B1') 'B1:P4' 'B:B' or 'B' (Entire second column) '2:2' or '2' (Entire second row) 'ALL' (Entire sheet) (Additional ranges: Comma separated ranges in the same form as above; contents of archive will be returned in output arguments 2...n) OUTPUT: If specified range is 1 cell, variable returned is of the same class as cell contents. If the range spans more than 1 cell, the variables will be cell arrays. EXAMPLES:a = readfromexcel('c:brettmy archivestest1.xls','C1:C5'); reads from the currently active sheeta = readfromexcel('c:brettmy archivestest1.xls', 'ALL'); reads the entire used portion of the active sheeta = readfromexcel('c:brettmy archivestest1.xls', 'C'); reads column C of the used portion of the active sheet[a,b] = readfromexcel('c:brettmy archivestest1.xls','sheet','sheet2','C1:C5','C1:P3'); reads from sheet2[a,b,c] = readfromexcel('myarchive','C3:D5','sheet','mysheet','E4','sheet','sheet2','B3'); reads a from currently active sheet, switches to sheet 'mysheet' to read b, then to sheet 'sheet2' to read c. Written by Brett Shoelson, Ph.D.shoelson@helix.nih.govUpdate History:1/04. Version 1.2/2/04. Now allows multiple specifications of sheet name at the suggestion of R. Venkat), and support of relative paths (thanks to Urs Schwarz). Also, inclusion of the extension '.xls' is now superfluous.7/29/04. Implements try/catch structure for reading of ranges to avoid errors that leave open activex connections. (Response to Chris Paterson's CSSM query). Also, now accomodates reading of entire sheet, or of entire row/column. (Response to email queries by Kinan Rai and CSSM query by Xiong.)SEE ALSO: write2excel

Requirements: No special requirements
Platforms: Matlab
Keyword: 039c039 Archivestest Xls Archivestest Xls Sheet Sheet Brett Cont Entire History Mysheet Phdshoelsonhelixnihgovupdate Portion Readfromexcel Myarchive Sheet Mysheet Sheet Sheet Reads Sheet Sheet Abc Sheeta Sheetab Shoelson Switches Written
Users rating: 0/10

License: Freeware Size: 10 KB
Communication  -  Xls to Signal Builder 1.0
Each xls sheet is used to create a signal builder groupTime vector must be in the first column.Each sheet must contain the same signal type (name & number)as the first sheet.Use TestCases.xls for example
40.96 KB  
Windows Software  -  Bytescout XLS Viewer 2.10
Bytescout XLS Viewer is a safe way to view, print XLS (Excel 97-2003), XLSX (Excel 2007), ODS (Open Office) spreadsheets with MS Office or Open Office NOT REQUIRED. Based on Bytescout.XLS library for .NET .NET developers Export to HTML is...
366.54 KB  
File Restoration  -  XLS Repair Free 1.0
Excel File Repair Tool is a very powerful error detection and .xls file repair tool. You will not find Excel File Repair Tool in the shops - you can only download Excel File Repair Tool from our secure download site, which takes a few seconds and...
1.18 MB  
Network & Internet  -  IAM_XLS 1.0
IAM-XLS is a PHP class for generating an XLS file. Alternatively, it can be used for performing a query dump and sending it to the browser as an Excel File. It allows the user to enter text and numeric values into a Excel spreadsheet. It has...
62.46 KB  
Development Tools  -  libxls 0.0.1
libxls is a library and php extension for parsing XLS files. It allows you to easily manage your Excel files using a web browser in online applications. 
Multimedia & Graphics  -  InnerSoft CAD for AutoCAD 2011 1.9a
InnerSoft CAD is a add-on component for AutoCAD that allows you to Export the values of an Area/ Length property or coordinates to an Excel Sheet. Import the vertex coordinates for a set of 2D polylines or 3D polylines from an Excel Sheet (you...
Graphic Conversion Tools  -  DXF2papercraft 0.2
Papercraft models are 3D models built from paper or cardboard. They should not be confused with Origami. Though Origami also aims at producing 3D shapes from sheets of paper, papercraft models involve cutting a so-called cut-out sheet and...
2.41 MB  
Business  -  RAHP Sign On 1.3
To use the RAHP Sign On program you simply select your approved RAHP Sheet from the list, add the relevant staff details and capture their signatures in the designated writing field. All information is instantly uploaded into your company account...
1.1 MB  
Libraries  -  XLSperl 0.4
XLSperl module allows you to use Perl "one-liners" with Microsoft Excel files. SYNOPSYS XLSperl [options] -e ... file1.xls file2.xls ... fileX.xls cat file.txt | XLSperl [options] -e ... Perl "one-liners" have a great many uses for quick...
9.22 KB  
Multimedia & Graphics  -  Pencil Check Pro for Mac OS 1.0
The most flexible line testing software available in the industry. Developed for the most prestigious and demanding studios, Pencil Check Pro provides an extensive feature set designed around a user friendly interface. Pencil Check Pro is the...
276 MB  
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  -  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  
Development Tools  -  save2word 1.0
A simple function to copy figure from MATLAB into MS Word automatically. It is a modification of saveppt (a function in File exchange) that save figures to MS Powerpoint.
10 KB