91av视频/亚洲h视频/操亚洲美女/外国一级黄色毛片 - 国产三级三级三级三级

  • 大小: 13KB
    文件類型: .rar
    金幣: 2
    下載: 0 次
    發布日期: 2021-05-28
  • 語言: 其他
  • 標簽: qt??office??

資源簡介

qt操作office文件的示例程序 基本上可以拿來直接使用,簡單修改一下就可以了。

資源截圖

代碼片段和文件信息

#include?“excel.h“

#if?defined(Q_OS_WIN32)
Excel::Excel(QString?strXlsFile?Qobject?*parent)
{
????excelApplication?=?0;
????excelWorkBooks?=?0;
????excelWorkBook?=?0;
????excelSheets?=?0;
????excelSheet?=?0;
????fileName?=?strXlsFile;
????columnName?=?“?A“;

????try?{
????????excelApplication?=?new?QAxobject(“Excel.Application“?parent);

????????if?(excelApplication)?{
????????????excelApplication->setProperty(“DisplayAlerts“?false);//不顯示任何警告信息。
????????????excelWorkBooks?=?excelApplication->querySubobject(“Workbooks“);
????????????if?(excelWorkBooks)?{
????????????????QFile?file(strXlsFile);
????????????????if?(file.exists())
????????????????????excelWorkBook?=?excelWorkBooks->querySubobject(“Open(const?QString&)“?strXlsFile);
????????????}?else
????????????????QMessageBox::information(0?““?“初始化Excel錯誤可能沒有安裝Office組件!“);
????????}?else
????????????QMessageBox::information(0?““?“初始化Excel錯誤可能沒有安裝Office組件!“);
????}?catch?(...)?{}
}

Excel::~Excel()
{
????closeAll();

}

QAxobject?*Excel::setFileName(const?QString&?strXlsFile)
{
????fileName?=?strXlsFile;
????if?(excelWorkBooks)?{
????????delete?excelWorkBooks;
????????excelWorkBooks?=?excelApplication->querySubobject(“Workbooks“);
????}

????if?(excelWorkBooks)?{
????????QFile?file(fileName);
????????if?(file.exists())
????????????excelWorkBook?=?excelWorkBooks->querySubobject(“Open(const?QString&)“?fileName);
????????else?{
????????????excelWorkBook?=?excelWorkBooks->querySubobject(“Add()“);
????????}

????????if?(excelWorkBook)
????????????excelSheets?=?excelWorkBook->querySubobject(“Sheets“);
????????else
????????????QMessageBox::information(0?““?“QAxobject?workbook?fail!“);
????}
????return?excelWorkBook;
}

void?Excel::closeAll()
{
????if?(excelApplication)?{
????????try?{
????????????excelApplication->dynamicCall(“?Quit()“);
????????????delete?excelSheet;
????????????delete?excelSheets;
????????????delete?excelWorkBook;
????????????delete?excelWorkBooks;
????????????delete?excelApplication;
????????????excelApplication?=?0;
????????????excelWorkBooks?=?0;
????????????excelWorkBook?=?0;
????????????excelSheets?=?0;
????????????excelSheet?=?0;
????????}?catch?(...)?{}
????}
}

QAxobject?*Excel::getWorkBooks()
{
????return?excelWorkBooks;
}

QAxobject?*Excel::getWorkBook()
{
????return?excelWorkBook;

}

QAxobject?*Excel::getWorkSheets()
{
????return?excelSheets;
}

QAxobject?*Excel::getWorkSheet()
{
????return?excelSheet;

}
bool?Excel::lockUpdate()
{
????try?{
????????if?(!excelApplication)
????????????return?false;
????????excelApplication->dynamicCall(“?SetScreenUpdating(bool)“?false);
????}?catch?(...)?{}

????return?true;
}

bool?Excel::unlockUpdate()
{
????try?{
????????if?(!excelApplication)
????????????return?false;
????????excelApplication->dynamicCall(“?SetScreenUpdating(bool)“?true);
????}?catch?(...)?{}
????return?true;
}

QAxobject?*Excel::selectSh

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

?????文件??????17495??2014-06-20?16:36??qt_office\excel.cpp

?????文件???????2451??2014-06-20?16:36??qt_office\excel.h

?????文件??????13824??2014-07-10?17:10??qt_office\Excel.xls

?????文件????????483??2014-07-11?10:40??qt_office\main.cpp

?????文件???????1745??2014-07-11?10:44??qt_office\mainwindow.cpp

?????文件????????422??2014-07-11?10:26??qt_office\mainwindow.h

?????文件???????2799??2014-07-11?10:33??qt_office\mainwindow.ui

?????文件????????468??2014-07-11?10:27??qt_office\qt_office.pro

?????文件??????17198??2014-07-11?10:46??qt_office\qt_office.pro.user

?????文件???????1725??2014-07-10?09:41??qt_office\word.cpp

?????文件??????19968??2014-07-10?16:57??qt_office\Word.doc

?????文件????????450??2014-07-10?09:42??qt_office\word.h

?????目錄??????????0??2014-07-11?10:46??qt_office

-----------?---------??----------?-----??----

????????????????79028????????????????????13


評論

共有 條評論