Excel控件使用之怪现象,请DX们诊断诊断
小小程序:Form一个,上有TExcelApplication,TExcelWorkbook,TExcelWorksheet,TButton,TSaveDialog各一个,点击button候向ExcelWorksheet写记录,然后存盘, 代码如下:
void __fastcall TForm1::Button1Click(TObject *Sender)
{
wchar_t pp[200];
if (SaveDialog1->Execute())
{ ExcelApplication1->Connect();
ExcelApplication1->Workbooks->Add(1,0);
ExcelWorkbook1->ConnectTo(ExcelApplication1->Workbooks->get_Item(1));
ExcelWorksheet1->ConnectTo(ExcelWorkbook1->Worksheets->get_Item(1));
ExcelWorksheet1->Cells->set_Item(1,1,"人命");
ExcelWorksheet1->Cells->set_Item(1,2,"成绩");
ExcelWorksheet1->SaveAs(StringToWideChar(SaveDialog1->FileName,pp,198));
ExcelWorksheet1->Disconnect();
ExcelWorkbook1->Disconnect();
ExcelApplication1->Disconnect();
ExcelApplication1->Quit();
};
}
现象:点击后弹出保存对话框,敲入文件名,点保存,结果又弹出一个对话框
询问workbook1已经更改,是否么保存,点击之后又弹出对话框(很明显是excel的)
这是保存才有效? 功能相同类似代码的在Delphi5下已经编译运行通过,可在Builder下死活不行,已经好几天了,还有不能多次保存,否则退出程序时报错:
“0x77a62aef”指令引用的“0x001585e8”内存。该内存不能为“read”
被折磨两天了,请DX们指点指点,50分送上