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 29.984.861 Times

ExcelFileSummary 1.0

  Date Added: July 30, 2013  |  Visits: 213

ExcelFileSummary

Report Broken Link
Printer Friendly Version


Product Homepage
Download (18 downloads)

[FILESTATS, RANGES] = EXCELFILESUMMARY(FILELOC)FILELOC: Enter the absolute path/name to the file you want to examineFILESTATS: output argument will be a structure describing the fileRANGES: If this optional output variable is provided, the function will also return a structure containing the entire used range of each sheet.Example:[filestats, contents] = excelfilesummary('C:Documents and SettingsShoelsonBMy Documentstest0046')FILESTATS decription:filename: name of filelocation: absolute pathnumber_of_sheets: number of sheetsactive_sheet: index of currently active sheetsheetnames: sequential sheet labelsblocksize: number of rows and columns currently used, by sheetusedrange: Excel address of used range (Ex: {['A1', 'F21']})usedcolrow: Column/row indices corresponding to usedrange (Ex: {[1,6],[1,21]}) ALSO: structures containing more information than you ever wanted to know about the application (Application_Info), the workbook (Workbook_Info), the individual sheets (sheet_properties), and the usedrange in each sheet (usedrange_properties)CONTENTS:Output: structure containing a cell array of spreadsheet contents for each sheet in the fileWritten by Brett Shoelson, PhDshoelson@helix.nih.gov8/12/04

Requirements: No special requirements
Platforms: Matlab
Keyword: 039a1039 Address Array Columnrow Columns Excel Indices Information Labelsblocksize Sequential Sheet Sheetusedrange Spreadsheet Structures Usedcolrow Usedrange Usedrange Propertiescontentsoutput Wanted
Users rating: 0/10

License: Freeware Size: 10 KB
EXCELFILESUMMARY RELATED
Development Tools  -  xlsgraph 1.0
xlsgraph(xtitle,ytitle,chartype,chart_title,filename,sheetname) xlsgraph : creates an Excel graph by searching specified sheet for selected columns headers.xtitle: title(s) of column to be x-axis (picked from titles).ytitle: title(s) of column to...
10 KB  
Utilities  -  A1 GPS Lite 1.1
A1 GPS is a tool for displaying address data about your actual location. Just turn it on and walk or ride along the streets. Actual address is displayed as a main information from your GPS. NOW YOU NEVER MISS THE PLACE! Honestly, do...
614.4 KB  
Social Networking  -  Gm3aty application 1.0.0.0
Application, which provides all the information about all the private universities in Egypt Application provides Lots of info such as the details of the university, such as the address and phones numbers and other information And also...
2 MB  
Travel  -  NFCGeoTag 1.1.0.0
NFC GeoTag allows you to write your favor location to a tag, retrieve address and store the location geo information. You can choose different type of tag scheme, the tag can be used to touch and launch the navigation map client from a NFC...
4 MB  
Personal Information Managers  -  Plaxo Contacts 8.0.26
Plaxo Contacts allows you to keep your address book up-to-date in an easy, secure, and automated way through a transparent plug-in to Microsoft Outlook, and via the web. You can use Plaxo to request updated contact information from your...
500 KB  
Modules  -  WP Mass Mail 2.45
Help you send bulk email messages to multiple address on your comment database. This plugin uses webmail php mail() function so you can determine the name of your address (ex:anyname@yourdomain.com)You can also set the reply-to header so when the...
20.48 KB  
Database Tools  -  tables2csv 1.0
tables2csv offers the programmer a simple, fast and effective method to collect table information from the local ODBC driver and output it to comma separated values. The csv output can be redirected to provide command line batch or script...
68 KB  
Database Tools  -  odbc2csv 1.0
odbc2csv offers the programmer a simple, fast and effective method to collect DSN information from the local ODBC driver and output it to comma separated values. The csv output can be redirected to provide command line batch or script processing...
44 KB  
Finance  -  Service Invoice Template 1.0
Service Invoice Template is an Excel workbook file which provides an easy to use, neat and simple invoice form for small businesses who provides service to their clients and don't have a need to ship physical products. The invoice format in this...
34.73 KB  
Modules  -  What is my IP Address 1.0.2
This simple mod will allow members to view their own IP. An essential tool for those who always ask how they can find out what their IP address is. Also provides detailed Whois information as well
 
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  -  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