回帖：/**
* 向Excel中插入新的Sheet(追加到末尾)
* @return true/false
*/
bool ExcelBase::addSheet(void)
{
bool ret = false;
#if defined(Q_OS_WIN)
Q_D(ExcelBase);
if (d->excel != NULL && !d->excel->isNull())
{
TC_FREE(d->sheet);
int count = d->sheets->property("Count").toInt();
QAxObject * last = d->sheets->querySubObject("Item(int)", count);
d->sheets->dynamicCall("Add(QVariant)", last->asVariant());
d->sheet = d->sheets->querySubObject("Item(int)", count);
ret = d->sheet != NULL && !d->sheet->isNull();
if(ret)
{
last->dynamicCall("Move(QVariant)", d->sheet->asVariant());
}
}
#endif // Q_OS_WIN
return ret;
}
/**
* 向Excel中插入新的Sheet(追加到末尾)
* @return true/false
*/
bool ExcelBase::addSheet(const QString& sheetName)
{
bool ret = false;
#if defined(Q_OS_WIN)
Q_D(ExcelBase);
if (d->excel != NULL && !d->excel->isNull())
{
TC_FREE(d->sheet);
int count = d->sheets->property("Count").toInt();
QAxObject * last = d->sheets->querySubObject("Item(int)", count);
d->sheets->dynamicCall("Add(QVariant)", last->asVariant());
d->sheet = d->sheets->querySubObject("Item(int)", count);
ret = d->sheet != NULL && !d->sheet->isNull();
if(ret)
{
d->sheet->setProperty("Name", sheetName);
last->dynamicCall("Move(QVariant)", d->sheet->asVariant());
}
}
#endif // Q_OS_WIN
return ret;
}