当我尝试使用拼音和win32ole使用以下代码设置较长的工作表名称时:
require "win32ole"
excel = WIN32OLE.new('Excel.Application')
excel.Visible = 1
puts excel.version
workbook = excel.Workbooks.Add
worksheet1 = workbook.Worksheets.Add
worksheet1.Name = "Pseudopseudohypoparathyroidism" #Length 30, fine
worksheet2 = workbook.Worksheets.Add
worksheet2.Name = "Supercalifragilisticexpialidocious" #Length 34, not fine
我得到了以下信息:
12.0
-:9:in `method_missing': (in setting property `Name': ) (WIN32OLERuntimeError)
OLE error code:800A03EC in Microsoft Office Excel
You typed an invalid name for a sheet or chart. Make sure that:
The name that you type does not exceed 31 characters.
The name does not contain any of the following characters: : \ / ? * [ or ]
You did not leave the name blank.
HRESULT error code:0x80020009
Exception occurred.
from -:9:in `<main>'
版本12.0表明我运行的是Excel2007,但它抱怨工作表名称太长。我看过this related answer中提到的Excel 2007 specifications and limits,但我找不到它提到任何这样的限制。(但是,尝试手动重命名工作表表明可能存在这样的限制)
是否有限制?是硬限制还是可以通过更改Excel的配置来更改?
https://stackoverflow.com/questions/3681868
复制相似问题