0x800a03ec {SaveAs方法的Workbook类失败}在TCOM / TCL中错误 [英] 0x800a03ec {SaveAs method of Workbook class failed} error in TCOM/TCL

问题描述

我试图从TCL写一些数据到CSV文件，但我得到0x800a03ec {WorkAs类的SaveAs方法失败}执行时。任何想法为什么这是发生？

I'm trying to write some data from TCL to a CSV file, but i get the 0x800a03ec {SaveAs method of Workbook class failed} when executing it. Any idea why this is happening?

set application [::tcom::ref createobject "Excel.Application"]
$application Visible 1

set workbooks [$application Workbooks]
set workbook [$workbooks Add]
set worksheets [$workbook Worksheets]
set worksheet [$worksheets Item [expr 1]]
#set worksheet [$worksheets Item "Sheet1"]
set cells [$worksheet Cells]

set rows [array size atten]
for {set row 1} {$row <= $rows} {incr row} {
    $cells Item $row "B" $atten($row)
}

$workbook SaveAs Filename {c:\tst.csv}
$application Quit

推荐答案

问题出现在您的SaveAs行中。应该读

The problem is in your SaveAs line. It should read

$workbook SaveAs {c:\tst.csv}

此外，您可能要将位置从C：\更改为通常不是可写位置。

Also you may want to change the location from C:\ as that is often not a writable location,.

这篇关于0x800a03ec {SaveAs方法的Workbook类失败}在TCOM / TCL中错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！