perl WIN32::OLE - HowTo move Excel Worksheet (or change position)

Question

In the article List of Perl commands to manipulate Windows Excel with Win32::OLE module it is mentioned how to add an Excel WorkSheet before or after an existing WorkSheet!

I want to move, so change the position of an existing WorkSheet, before or after an other WorkSheet. How can I achieve this? Is it just to replace the add in $Book->Worksheets->Add({After => $workbook->Worksheets($workbook->Worksheets->{Count})}); by move (or copy if I want to copy)?

thank you for your hints! Regards Laurent

score 1 · Accepted Answer · answered Oct 27 '17 at 10:27

1

You need to use the Worksheet.Move method with the After attribute

I am not a perl specialist, but the syntax should be:

$Book->Worksheets("Sheet1")->Move({After => $workbook->Worksheets($workbook->Worksheets("Sheet2"))});

answered Oct 27 '17 at 10:27

xMRi

14,982
3
26
59

Sorry for no comment! I have to try this! I did not get the chance until now... I keep you informed – Laurent Zotto Oct 29 '17 at 09:30
Hello The "Move" method works as you described it.. Thank you for the hint! – Laurent Zotto Oct 31 '17 at 08:06

perl WIN32::OLE - HowTo move Excel Worksheet (or change position)

1 Answers1