Perl2.处理工作表
示例
#Get the active Worksheet
my $Book = $Excel->Activewindow;
my $Sheet = $Book->Activesheet;
#List of Worksheet names
my @list_Sheet = map { $_->{'Name'} } (in $Book->{Worksheets});
#Access a given Worksheet
my $Sheet = $Book->Worksheets($list_Sheet[0]);
#Add new Worksheet
$Book->Worksheets->Add({After => $workbook->Worksheets($workbook->Worksheets->{Count})});
#Change Worksheet Name
$Sheet->{Name} = "Name of Worksheet";
#Freeze Pane
$Excel -> ActiveWindow -> {FreezePanes} = "True";
#Delete Sheet
$Sheet -> Delete;
热门推荐
1 简短元宵节祝福语
10 六一祝福语简短十六字
11 新郎朋友祝福语简短大气
12 圣诞祝福语简短给师姐
13 物业小区高考祝福语简短
14 卖奶茶开张祝福语简短
15 王凯结婚祝福语简短
16 私房进火祝福语简短
17 升班祝福语简短10字
18 生日奥特曼可爱祝福语简短