perl生成excel文档的格式设置

概述#生成excel文档my $workbook = Spreadsheet::WriteExcel->new('/home/loganalysis/data/hudong/docSoSearch/statKeywordsTop100.xls');#各种数据的展现格式my $normalFormat = $workbook->add_format(border => 1,align =>

#生成excel文档my $workbook = Spreadsheet::WriteExcel->new('/home/loganalysis/data/hudong/docSoSearch/statKeywordstop100.xls');#各种数据的展现格式my $normalFormat = $workbook->add_format(border => 1,align => "center",size=>12);my $TitleFormat = $workbook->add_format(bg_color => "yellow",border => 1,align=>"center",size=>12);my $numFormat = $workbook->add_format(num_format=>'#,##0.00',align=>"left");my $percentFormat = $workbook->add_format(num_format=>'#,##0.00%',align=>"center");my $urlFormat = $workbook->add_format(border => 1,align => "left",size=>12);

my $normalFormat = $workbook->add_format(border => 1,size=>12);my $TitleFormat = $workbook->add_format(border => 1,size=>12);my $numFormat = $workbook->add_format(bg_color => "27",align=>"right",size=>12);my $tuchuFormat = $workbook->add_format(border => 1,align=>"left",size=>12);$tuchuFormat->set_bg_color('27');$tuchuFormat->set_bold();my $normalrightFormat = $workbook->add_format(border => 1,align => "right",size=>12);

#生成excel表

my $worksheet = $workbook->add_worksheet(T("百科"));my($row,$col)=(0,0);#初始化表头行$worksheet->write($row,$coL++,T("分类"),$TitleFormat);$worksheet->write($row,T("PV"),T("IP"),$TitleFormat);$row++;$col=0;$worksheet->write($row,T("某类总量"),$tuchuFormat);$worksheet->write($row,$a,$numFormat);$worksheet->write($row,$b,$numFormat);$row++;$col=0;

$worksheet->set_column(0,40);#设置列表的宽度，第0列宽40$worksheet->set_column(1,3,30);#设置列表的宽度，第1,2列宽30$workbook->close();

总结

以上是内存溢出为你收集整理的perl生成excel文档的格式设置全部内容，希望文章能够帮你解决perl生成excel文档的格式设置所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。