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

關注