用Qt和QAxObject从Excel模板中导出PDF文件

QAxObject excel("Excel.Application");
excel.setProperty("Visible", false);
QAxObject *workbooks = excel.querySubObject("Workbooks");
QAxObject *workbook = workbooks->querySubObject("Open(const QString&)", "path/to/template.xlsx");

QAxObject *worksheets = workbook->querySubObject("Worksheets");
QAxObject *worksheet = worksheets->querySubObject("Item(int)", 1); // 第一个工作表
QAxObject *usedRange = worksheet->querySubObject("UsedRange");
QAxObject *rows = usedRange->querySubObject("Rows");
QAxObject *columns = usedRange->querySubObject("Columns");
int rowCount = rows->property("Count").toInt();
int columnCount = columns->property("Count").toInt();

QTableWidget table(rowCount, columnCount);
for (int row = 1; row <= rowCount; ++row) {
    for (int column = 1; column <= columnCount; ++column) {
        QAxObject *cell = worksheet->querySubObject("Cells(int,int)", row, column);
        QVariant value = cell->property("Value");
        table.setItem(row - 1, column - 1, new QTableWidgetItem(value.toString()));
        cell->dynamicCall("Release()");
    }
}

workbook->dynamicCall("Close()");
excel.dynamicCall("Quit()");

QPrinter printer(QPrinter::HighResolution);
printer.setOutputFormat(QPrinter::PdfFormat);
printer.setOutputFileName("path/to/output.pdf");
table.render(&printer);