Workbook

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...

ANALYSEEXCELFORMULAS Extracts formulas from an Excel workbook and lists them in several different ways to aid analysis. AnalyseExcelFormulas collects all the formulas and values from all the worksheets in an Excel file. It then creates a new Excel file with 2N+1 sheets in it (where N is the...

Creates new Excel file (or opens it if file exists) and name the sheets as listed in (sheetnames) and saves the workbook as (filename).xlsheets(sheetnames,filename)xlsheets(sheetnames)sheetnames: List of sheet names (cell array).filename: Name of excel file.NOTE: Follow the following rules when...


Platforms: Matlab

Reads all rough data from Excel spreadsheet file in a data structureUses xlsread to read each 'Sheet' in the 'Workbook' separately.All numeric data and text data is saved in separate fields.M-file is quickly prototyped. It is documented for others to improve the code.


Platforms: Matlab

Excel::Template is a Perl module used for templating Excel files. Its genesis came from the need to use the same datastructure as HTML::Template, but provide Excel files instead. The existing modules don't do the trick, as they require replication of logic that's already been done within...


Platforms: *nix

Excel Merger is a handy free Excel file and workbook merging utility for Windows. It enables users to merge Excel XLS/XLSX and ODS/CSV/XML files into one single workbook file without installing Office or MS Excel. Excel Merger supports a variety of common worksheet output formats like XLSX...


Platforms: Windows, Windows 7

XLCalendar is a calendar generator for Microsoft Excel that outputs calendars in Microsoft Excel spreadsheet format. Using XLCalendar, you can easily make various kinds of perpetual calendars, and custom calendars in your own language, holidays and styles. Main features: * Outputting...


Platforms: Windows

If you need a free utility to manage defined names in your workbooks, this one is a must-have. List all names in your active workbook. Filter them using 13 filters including "With external references," "With errors," "Hidden," and "Visible." Show only names that contain a substring. Show only...


Platforms: Windows

This Utility will split your Access datasets into separate Access Tables, Excel workbooks or separate Excel tabs based on criteria you define. You can create a separate workbook for each Employee in your dataset or each City, or State, or --- etc. All this with one click! There is a Macromedia...


Platforms: Windows

Do all the different types of mortgages and loans confuse you, if so, you're not alone. Vertex42 offers a collection of 11 Excel Workbook spreadsheets that are related to mortgages. For example, the Home Equity Loan Calculator will calculate the monthly payment and create a payment schedule, with...


Platforms: Excel

Four freeware add-ins for Microsoft Excell. Formula Mapper - Graphical representation of formula relationships. Name Box Extender - Increases the width of the ‘name' drop down box. Formula Indenter - Allows formulae to be viewed as little discrete pieces of program code by indenting the...


Platforms: Windows

WindowSwitcher is an application that allows you to quickly switch between all open documents, workbooks, and/or presentations using the Windows TaskBar and Microsoft Word, Excel, and/or PowerPoint. If WindowSwitcher is enabled, and you have more than one document, workbook, or presentation open,...


Platforms: Windows

This Utility will split your Access datasets into separate Access Tables, Excel workbooks or separate Excel tabs based on criteria you define. You can create a separate workbook for each Employee in your dataset or each City, or State, or --- etc. All this with one click! There is a Macromedia...


Platforms: Windows

POLE is a portable C++ library to access structured storage. It is designed to be compatible with Microsoft structured storage, also sometimes known as OLE Compound Document. A structured storage is normally used to store files inside another file; you can even have complex directory tree...


Platforms: *nix

Spreadsheet::WriteExcel module is can be used to create native Excel binary files. Formatted text and numbers can be written to multiple worksheets in a workbook. Formulas and functions are also supported. It is 100% Perl and doesnt require any Windows libraries or a copy of Excel. It will...


Platforms: *nix

Spreadsheet::WriteExcelXML is a Perl module that can create an Excel file in XML format. SYNOPSIS To write a string, a formatted string, a number and a formula to the first worksheet in an Excel XML spreadsheet called perl.xls: use Spreadsheet::WriteExcelXML; # Create a new Excel workbook...


Platforms: *nix

SM2DGraphView framework provides an NSView subclass which draws pie charts or graphs of lines and/or bars including axis labels.The SM2DGraphView class acts very much like an NSTableView or NSBrowser; SM2DGraphView takes responsibility for all of the drawing code but relies on a data source...


Platforms: Mac

Free Office Tabs - Tabbed Browsing, Editing and Managing for Microsoft Office 2003, 2007 and 2010. Works with all editions of Office: Enterprise, Ultimate, Professional Plus, Professional, Standard, Home and Business, Home and Student... Unlike web browsers -- Internet Explorer 8, Firefox or...


Platforms: Windows

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 Service Invoice Template is for intended for...


Platforms: Windows

Risk matters to anyone who intends to start up with a new business project, whether it be a hot dog stand, a garage or an airplane factory. Your gut feeling is of the greatest relevance. But sometimes helpers have a different perspective than you and want something more tangible to decide on...


Platforms: Windows, *nix, Windows 7, Other