Perl Language Perl commands for Windows Excel with Win32::OLE module
Introduction
These examples introduce the most used commands of Perl to manipulate Excel via Win32::OLE module.
Syntax
- $Sheet->Range(Cell1,[Cell2]) #Select a cell or a range of cells
- $Sheet->Cells(rowIndex, columnIndex) #Select a cell by index of row and column
Parameters
| Parameters | Details |
|---|---|
| Cell1 (required) | The name of the range. This must be an A1-style reference in the language of the macro. It can include the range operator (a colon), the intersection operator (a space), or the union operator (a comma). |
| Cell2 (optional) | If specified, Cell1 corresponds to the upper-left corner of the range and Cell2 corresponds to the lower-right corner of the range |
Remarks
Link for information about Colors on Excel: http://dmcritchie.mvps.org/excel/colors.htm
Link for information about Excel constants: http://msdn.microsoft.com/en-us/library/aa221100%28office.11%29.aspx
Links from Win32::OLE module: http://search.cpan.org/~jdb/Win32-OLE-0.1712/lib/Win32/OLE.pm#EXAMPLES
Useful information about usage of Excel can be found at this address
