Perl Language Perl commands for Windows Excel with Win32::OLE module

30% OFF - 9th Anniversary discount on Entity Framework Extensions until December 15 with code: ZZZANNIVERSARY9


These examples introduce the most used commands of Perl to manipulate Excel via Win32::OLE module.


  • $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


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


Link for information about Colors on Excel:

Color Table

Link for information about Excel constants:

Links from Win32::OLE module:

Useful information about usage of Excel can be found at this address

Got any Perl Language Question?