求助一段win32::ole写入excel的代码，工作需要

feiying00917

现在要往一个已经存在并有数据的excel表格中写入数据，因为表格已经有数据，所以需要在这些数据之后插入数据，能不能用win32:le写段代码，工作需要，求大侠帮忙！
比如 %work={'name'=>'jack',
                     'project'=>'venus',
                     'pid'=>'R0629"
                     'add'=>'shanghai'}
需要插入到一个excel.xls文件中，使用win32:le,需要知道excel已经存在数据的行截至数，然后紧接着下一行插入%work中的值(键不需要存入,依次按列插入哈希值，每个cell存入一个值即可)，求一段完整代码，谢谢！

stanley_tam

偶试试{:3_193:}

1. #!perl
   
2. package Xls;
   
3. 
   
4. use strict;
   
5. use Win32::OLE;
   
6. 
   
7. sub new {
   
8.     my ($class) = @_;
   
9.     my $self = +{};
   
10.     bless $self, $class;
    
11.     return $self;
    
12. }
    
13. 
    
14. sub open_excel {
    
15.     my $self   = shift;
    
16.     my $xl_doc = shift;
    
17.     my $excel = Win32::OLE->new('Excel.Application') or
    
18.         die "Excel application is not installed:\n";
    
19.     my $workbooks;
    
20.    
    
21.     # make excel visible
    
22.     $excel->{Visible} = 1;
    
23. 
    
24.     $workbooks = $excel->Workbooks->Open($xl_doc);
    
25.     return $workbooks;
    
26. }
    
27. 
    
28. sub get_worksheet {
    
29.     my ($self, $workbooks, $num) = @_;
    
30.     my $sheet = $workbooks->Worksheets($num);
    
31.     return $sheet;
    
32. }
    
33. 
    
34. sub get_cell_value {
    
35.     my ($self, $sheet, $row, $col) = @_;
    
36.     my $cell_obj = $sheet->Cells($row, $col);
    
37.     my $value = q{};
    
38.    
    
39.     if ($cell_obj){
    
40.         $value = $sheet->Cells($row, $col)->{Value};
    
41.     }
    
42.     $value ||= q{};
    
43.    
    
44.     return $value;
    
45. }
    
46. 
    
47. sub set_cell_value {
    
48.     my ($self, $sheet, $row, $col, $value) = @_;
    
49.     my $cell_obj = $sheet->Cells($row, $col);
    
50.     $value ||= q{};
    
51.    
    
52.     if ($cell_obj){
    
53.         $sheet->Cells($row, $col)->{Value} = $value;
    
54.     }
    
55. }
    
56. 
    
57. 1;
    
58. 
    
59. package main;
    
60. use strict;
    
61. 
    
62. my $xls_name = '/full/path/to/your/excel.xls';
    
63. 
    
64. # parse the first worksheet
    
65. my $worksheet_number = 1;
    
66. 
    
67. # data to write
    
68. my %work = (
    
69.     name   =>'jack',
    
70.     project=>'venus',
    
71.     pid    =>'R0629',
    
72.     add    =>'shanghai',
    
73. );
    
74. 
    
75. my $pm = Xls->new();
    
76. my $workbooks = $pm->open_excel($xls_name);
    
77. my $worksheet = $pm->get_worksheet($workbooks, $worksheet_number);
    
78. 
    
79. # frist cell
    
80. my $col = 1;
    
81. my $row = 1;
    
82. 
    
83. # get the cell in column one that has no value within
    
84. while (1) {
    
85.     my $cell_value = $pm->get_cell_value($worksheet, $row, $col);
    
86.     last if !$cell_value;
    
87.     $row++;
    
88. }
    
89. 
    
90. # write data in ordered sequences
    
91. for my $key ('name', 'project', 'pid', 'add'){
    
92.     $pm->set_cell_value($worksheet, $row, $col, $work{$key});
    
93.     $col++;
    
94. }
    
95. 
    
96. # close
    
97. $workbooks->Close
    
98. __END__

复制代码

wenbinsan

回复 2# stanley_tam

学习了，bless