readfromexcel script download - readfromexcel readfromexcel returns values in multiple ranges of existing Excel file.

readfromexcel returns values in multiple ranges of existing Excel file. 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:rettmy archives est1.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:rettmy archives est1.xls','C1:C5');reads from the currently active sheeta = readfromexcel('c:rettmy archives est1.xls', 'ALL');reads the entire used portion of the active sheeta = readfromexcel('c:rettmy archives est1.xls', 'C');reads column C of the used portion of the active sheet[a,b] = readfromexcel('c:rettmy archives est1.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. Requirements: · MATLAB Release: R13

RECOMMENDED TOOLS

» read excel » scientific engineering » excel engineering

mat7to6 script      
mat7to6 mat7to6 makes MATLAB 7.x mat-files readable by MATLAB 6.x.
Price: Freeware$, Rating: 10, Downloads: 0

mat2hdf script      
mat2hdf mat2hdf - Convert MATLAB 6/7 MAT files to HDF 5.
Price: Freeware$, Rating: 10, Downloads: 0

generateXML script      
generateXML generateXML - Output the input variable as an XML string suited for import in
Price: Freeware$, Rating: 7, Downloads: 0

Manhattan Virtual Classroom script 3.2     
Manhattan Virtual Classroom Manhattan Virtual Classroom is a fast, stable and effective co
Price: GPL$, Rating: 10, Downloads: 0

date2julian script      
date2julian date2julian - Convert date to julian day.
Price: Freeware$, Rating: 7, Downloads: 0

SVG Reader script      
SVG Reader SVG Reader - Import and infinite area/pixel zoom on SVG file
Price: Freeware$, Rating: 7, Downloads: 0

Vector Canape mat-file converter script      
Vector Canape mat-file converter Vector Canape mat-file converter extends an exported mat-
Price: Freeware$, Rating: 8, Downloads: 0

nspread script      
nspread nspread reads .nsp format audio files as generated by Multispeech software.
Price: Freeware$, Rating: 8, Downloads: 0