Array Operations Excel

Java library that easily converts a Json array to Excel or CSV Platforms: Windows, Mac, Linux

Fawlty Language is an IDL 7.0 (Interactive Data Language) compatible compiler (IDL is a registered trademark of ITT Visual Information Solutions). FL binaries can be freely used. Current stable version is FL 0.79a, released on Sep 3, 2009. (Changelog) Features: all language elements are... Platforms: *nix

bops stands for boolean array operations. bops uses numpy to do boolean operations on numpy.ndarrays. This module is meant to simpifiy boolean operations on lists and arrays. This module also allows for combining boolean arrays to get the logical AND, as well as the OR, for multiple boolean... Platforms: *nix

This script has the next actions: finds the set of elements in input_array that are closest to elements in target_array and records the indices of the elements in target_array that are within tolerance, tol, of their closest match. Also it records the indices of the elements in target_array... Platforms: Windows, Mac, *nix, Python, BSD Solaris

JavaArray is a tied extension for Java arrays from Java.pm SYNOPSIS use Java; # Set up Java.pm to always return tied array references to me my $java = new Java(use_tied_arrays => 1); my $tied_array = $java->create_array("java.lang.String",5); OR # Roll my own tied arrays my... Platforms: *nix

Gtk2 has a powerful, but complex MVC (Model, View, Controller) system used to implement list and tree widgets. The Gtk2::Ex::Simple::Tree Perl module automates the complex setup work and allows you to treat the tree model as a more natural list of hash refs. After creating a new... Platforms: *nix

COPE is a CORBA implemented in Perl. This documents describes the steps you take when writing a CORBA application in Perl using COPE. First the basics: the laguage binding used. Scalar types char The char type is represented as a 1-character perl string, like a. octet octet is... Platforms: *nix

SpeedyGA is a vectorized implementation of a genetic algorithm in the Matlab programming language. Without bells and whistles, it faithfully implements the specification for a Simple GA given on pgs 10, 11 of M. Mitchell's GA book. See comments in code for details.This script has played a crucial... Platforms: Matlab

XLSCOLSTR2NUM takes in a cellular array of characters and returns a array of numbers of the same size with elements corresponding to Excel column numbers.See Also XLSCOLNUM2STR Platforms: Matlab

A module of additional array methods, including slice operations, numerical calculations, cloning and concatenation, and more. Platforms: Mac

Accepts a 1-dimensional struct array (in the format 1xn) and converts it into a cell array. The first row of the cell array has the struct's field names in each column; the data from each of those fields for each entry in the struct array appears in subsequent rows. The idea is to make it easy to... Platforms: Matlab

ADODB SQL 2 Excel can be used to generate Excel files in the XLS format from database query results.This is an altered version of of the SQL 2 Excel class that uses ADODB API instead of MySQL. It extends the GeraExcel class to generate Excel files from the results of execution of an SQL... Platforms: PHP

Database Operations is a MySQL database access wrapper that can be used to manipulate records of a MySQL table.Functions of Database Operations:- Connect to a given MySQL database- Retrieve the fields of a given table- Retrieve the number of records in a table- Execute a SELECT query and retrieve... Platforms: PHP

This free add-in for Microsoft Excel 2000, Excel XP (2002) and Excel 2003 enhances the built-in Special Cells dialog and simplifies access to other functionality of Microsoft Excel. Cells containing conditional formats, formulas, comments, values can be found and selected with a click on the... Platforms: Windows

Viobo MSSQL to Excel Data Migrator is the simplest data-migrator between MSSQL and Excel currently. It migrates data between MSSQL and Excel database system accurately and perfectly, with NO database administrator experience required. The tool is compatible with most major versions of MSSQL and... Platforms: Windows

Viobo MySQL to Excel Data Migrator is the most efficacious data-migrator between MySQL and Excel currently. It migrates data from MySQL to Excel accurately and perfectly, and with NO database administrator experience required. The data migrator is compatible with all versions of MySQL and Excel,... Platforms: Windows

Viobo Access to Excel Data Migrator is the simplest data-migrator between Access and Excel currently. It migrates data between Access and Excel database system accurately and perfectly, with NO database administrator experience required. The tool is compatible with most major versions of Access... Platforms: Windows

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... Platforms: Matlab

XLSRANGENAMES Returns a list of named ranges in an excel workbook RangeNames = XLSRangeNames(filename) RangeNames is a (n x 2) cell array with the name of the named range in the first column and the value (aka location) in the second column The value is an excel formula similar to: '=Sheet1!$A$1'... Platforms: Matlab

Complete Excel Names is a COM add-in that allows you to set the width of the Name Box in Excel. Platforms: Windows