exlerve

A package to transfer numeric matrices from and to excel worksheets using activex server link.

A package to transfer numeric matrices from and to excel worksheets using activex server link. Tested for Matlab versions 5.2 and 5.3 on a PC under Win95 and Office97.

Normal mode uses Excel invisibly.

Using exl_getmat with too few arguments invokes the Excel worksheet to be visible and allows the user to work interactively.

Syntax:
1) C=exl_getmat(target,region,host)
2) conf=exl_setmat(A,target,region,host)

The output C is a cell array that may contain numeric and text data.

To convert a numeric cell array into a matrix use cell2num.m.

The output 'conf' is to confirm a successful transfer.

The input A is a numeric matrix or cell array.

MATLAB Version 5.3 allows strings in the cell array.

Target, region, host - is the address of the region of excel cells in the target file on the host computer (host is needed only on network).

More help and default values are listed in the help section of the functions.

Known problems:
Using exl_getmat in the interactive mode to manually insert values and ending without selecting a region may cause Matlab error leaving the link unclosed.