怎样控制删除EEXCEL表的数据？

[felix007]

void CompareDataSetToExcel(TCustomADODataSet *ADataSet,String CFileName,String StartLine)
{
if (!ADataSet->Active) return;
Variant ExcelApp = Variant::CreateObject("Excel.Application");
Variant ExcelBook = ExcelApp.OlePropertyGet("WorkBooks").OleFunction("Open",CFileName.c_str());
Variant ExcelSheet = ExcelBook.OlePropertyGet("Sheets").OlePropertyGet("Item", 1);
Variant QueryTables = ExcelSheet.OlePropertyGet("QueryTables");
Variant Range = ExcelSheet.OlePropertyGet("Range",StartLine.c_str());


// ExcelApp.OlePropertyGet("ActiveSheet").OleProcedure("Delete"，Range);
这句可以实现吗？格式怎样？我查了帮助看到一头雾水
Variant Table = QueryTables.OleFunction("Add", ADataSet->Recordset, Range);
Table.OlePropertySet("FieldNames", false);
Table.OleProcedure("Refresh", true);
Variant myworkbook=ExcelApp.OlePropertyGet("ActiveWorkbook");
myworkbook.OleProcedure("Save");
ExcelApp.Exec(PropertySet("Visible")<<true);
ExcelApp.Exec(Procedure("Quit"));
}


我想把一个execl表已经有的数据（除了标题）删除然后在添加，因为我的excel格式要固定，如果在cb设置太麻烦

[felix007]

能有dx帮忙吗？我明天就要交啦！！是毕业设计阿！！救命～～～