16,216
社区成员
发帖
与我相关
我的任务
分享
QAxObject excelObj(Excel.Application);
QAxObject* work_books = excelObj.querySubObject(Workbooks);
work_books->dynamicCall("Open(const QString&)", "E:\\data.xlsx");
QAxObject* work_book = excelObj.querySubObject("ActiveWorkBook");
QAxObject* work_sheets = work_book->querySubObject("WorkSheets");
QAxObject* work_sheet = work_book->querySubObject("Sheets(int)", 1);
QAxObject* cells = work_sheet->querySubObject("Range(QVariant,QVariant).Select", "A1", "J10");
QVariant vals = cells->property("Value");
QAxObject* cellsBorders = cells->querySubObject("Borders");
QVariant style = cellsBorders->property("LineStyle");