Perl LanguagePerl 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

ParametersDetails
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

Color Table

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