HJHgui.zip

#include "importfile.h" #include <ActiveQt/QAxObject> importFiles::importFiles() { } importFiles::~importFiles() { } int importFiles::GetFileContent(QString filename) { QString Text; //fileContent.clear(); QAxObject* excel = new QAxObject(); if (!excel->setControl("Excel.Application"))//判断是否成功连接excel文件 { delete excel; excel = NULL; return -2; } excel->setProperty("Visible", false); QAxObject* work_books = excel->querySubObject("WorkBooks"); work_books->dynamicCall("Open (const QString&)", filename); if (work_books == NULL) { excel->dynamicCall("Quit(void)"); //退出 delete excel; excel = NULL; return -1; } QAxObject *work_book = excel->querySubObject("ActiveworkBook"); if (work_book == NULL) { work_books->dynamicCall("Close(Boolean)", false); //关闭文件 excel->dynamicCall("Quit(void)"); //退出 delete work_books; work_books = NULL; delete excel; excel = NULL; return -1; } QAxObject* work_sheets = work_book->querySubObject("Worksheets(int)", 1); //Sheets也可换用WorkSheets QAxObject *work_sheet = work_book->querySubObject("Sheets(int)", 1); QAxObject *used_range = work_sheet->querySubObject("UsedRange"); QAxObject *rows = used_range->querySubObject("Rows"); QAxObject *columns = used_range->querySubObject("Columns"); int row_count = rows->property("Count").toInt(); //获取行数 int col_count = columns->property("Count").toInt(); //获取列数 for (int i = 1; i < row_count; i++) { for (int j = 0; j < col_count; j++) { Text = work_sheet->querySubObject("Cells(int,int)",i+1,j+1)->dynamicCall("Value").toString(); qDebug() <<Text; } } work_books->dynamicCall("Close(Boolean)", false); excel->dynamicCall("Quit(void)"); //退出 delete work_books; work_books = NULL; delete excel; excel = NULL; return 1; }