perl操作excel如何设置成文本格式

magnet2008

用Spreadsheet::WriteExcel生成excel时，如果是000002这样的格式，生成的excel会变成2，
如何设置format避免这种问题？或者说有别的解决办法？？

兰花仙子

perl -le '$x=sprintf("%05d",2);print $x'
00002

dugu072_cu

lz 说的是，excel 如何不自动格式化……

可以如此：value = "'00002"，注意，就是利用了 vbs 的 ' 为注释符号，这样子，就不会给你格式化了！

socyno

在 perldoc 文档中有找到这么一段描述，似乎比较符合你遇到的问题：
One problem with the write() method is that occasionally data looks like a number but you don't want it treated as a number. For example, zip codes or ID numbers often start with a leading zero. If you write this data as a number then the leading zero(s) will be stripped. You can change this default behaviour by using the keep_leading_zeros() method. While this property is in place any integers with leading zeros will be treated as strings and the zeros will be preserved. See the keep_leading_zeros() section for a full discussion of this issue.

magnet2008

$worksheet->keep_leading_zeros();对于一个工作表设置一下即可，多谢三位的回复。

yybmsrs

关注