Qt读取Excel 一

最新推荐文章于 2024-09-09 11:37:32 发布

转载最新推荐文章于 2024-09-09 11:37:32 发布 · 1.6k 阅读

文章标签：

头文件：

01#ifndef TEXCELREADER_H

02#define TEXCELREADER_H

03  

04#include <QObject>

05#include <QAxObject>

06#include <QList>

07  

08classTExcelReader;

09classTExcelSheet

10{ 

11public:

12    TExcelSheet(QAxObject* sheet)

13    {

14        Clear();

15  

16        if(0 == sheet)

17            return;

18        QAxObject * usedrange = sheet->querySubObject("UsedRange");

19        if(0 == usedrange)

20        {

21            Clear();

22            return;

23        }

24        QAxObject * rows = usedrange->querySubObject("Rows");

25        if(0 == rows)

26        {

27            Clear();

28            return;

29        }

30        QAxObject * columns = usedrange->querySubObject("Columns");

31        if(0 == columns)

32        {

33            Clear();

34            return;

35        }

36  

37        mStartRow = usedrange->property("Row").toInt();

38        mStartCol = usedrange->property("Column").toInt();

39        mColCount = columns->property("Count").toInt();

40        mRowCount = rows->property("Count").toInt();

41    }

42  

43    virtual~TExcelSheet()

44    {

45    }

46  

47private:

48    voidClear()

49    {

50        mStartRow = mStartCol = mRowCount = mColCount = 0;

51    }

52  

53private:

54    int mStartRow;

55    int mStartCol;

56    int mRowCount;

57    int mColCount;

58  

59    friendclassTExcelReader;

60}; 

61  

62  

63classTExcelReader :
publicQObject

64{ 

65    Q_OBJECT

66  

67public:

68    TExcelReader(QString excelName, QObject *parent = 0);

69    virtual~TExcelReader();

70  

71    intGetExcelSheetCount()
const; 

72  

73    intGetSheetUseColStart(intsheetIndex)
const;

74    intGetSheetUseColCount(intsheetIndex)
const;

75    intGetSheetUseRowStart(intsheetIndex)
const;

76    intGetSheetUseRowCount(intsheetIndex)
const;

77  

78    QString GetData(intsheetIndex,
introw,
intcol);

79  

80private:

81    voidClear();

82  

83private:

84    QList<TExcelSheet>        mListSheet;

85  

86    QAxObject*      mExcelObj;

87    QAxObject*      mWorkBooks;

88    QAxObject*      mWorkBook;

89    QAxObject*      mSheets;

90}; 

91  

92#endif // TEXCELREADER_H

实现文件：

001#include "TExcelReader.h"

002  

003TExcelReader::TExcelReader(QString excelName, QObject *parent)

004    : QObject(parent)

005    , mExcelObj(0)

006    , mWorkBooks(0)

007    , mWorkBook(0)

008    , mSheets(0)

009{ 

010    mExcelObj =new
QAxObject( "Excel.Application");

011    mWorkBooks = mExcelObj->querySubObject("Workbooks"
); //得到Workbooks集合的指针

012    if(0 == mWorkBooks)

013        return;

014    mWorkBook = mWorkBooks->querySubObject("Open(const QString&)", excelName);//open
 xls

015    if(0 == mWorkBook)

016        return;

017    mSheets = mWorkBook->querySubObject("Sheets"
); //得到Sheets对象的指针

018    if(0 == mSheets)

019        return;

020  

021    intiSheetCount = mSheets->property("Count").toInt();

022    for(intindex=1;
 index<=iSheetCount; ++index)

023    {

024        QAxObject* sheetObj = mWorkBook->querySubObject("Worksheets(int)", index);

025        if(0 == sheetObj)

026        {

027            Clear();

028            return;

029        }

030  

031        mListSheet.append(TExcelSheet(sheetObj));

032    }

033} 

034  

035TExcelReader::~TExcelReader()

036{ 

037    Clear();

038} 

039  

040voidTExcelReader::Clear()

041{ 

042    mListSheet.clear();

043  

044    mWorkBook->dynamicCall("Close (Boolean)",false);

045    mExcelObj->dynamicCall("Quit(void)");

046  

047    mSheets = 0;

048    mWorkBook = 0;

049    mWorkBooks = 0;

050  

051    deletemExcelObj;

052    mExcelObj = 0;

053} 

054  

055intTExcelReader::GetExcelSheetCount()const

056{ 

057    returnmListSheet.size();

058} 

059  

060intTExcelReader::GetSheetUseColStart(intsheetIndex)
const

061{ 

062    if(sheetIndex < 1 || sheetIndex > mListSheet.size())

063        return-1;

064  

065    returnmListSheet[sheetIndex-1].mStartCol;

066} 

067  

068intTExcelReader::GetSheetUseColCount(intsheetIndex)
const

069{ 

070    if(sheetIndex < 1 || sheetIndex > mListSheet.size())

071        return-1;

072  

073    returnmListSheet[sheetIndex-1].mColCount;

074} 

075  

076intTExcelReader::GetSheetUseRowStart(intsheetIndex)
const

077{ 

078    if(sheetIndex < 1 || sheetIndex > mListSheet.size())

079        return-1;

080  

081    returnmListSheet[sheetIndex-1].mStartRow;

082} 

083  

084intTExcelReader::GetSheetUseRowCount(intsheetIndex)
const

085{ 

086    if(sheetIndex < 1 || sheetIndex > mListSheet.size())

087        return-1;

088  

089    returnmListSheet[sheetIndex-1].mRowCount;

090} 

091  

092QString TExcelReader::GetData(intsheetIndex,
introw,
intcol)

093{ 

094    if(sheetIndex < 1 || sheetIndex > mListSheet.size())

095        returnQString();

096    TExcelSheet sh = mListSheet[sheetIndex-1];

097    if(row < sh.mStartRow || row >= sh.mStartRow + sh.mRowCount)

098        returnQString();

099    if(col < sh.mStartCol || col >= sh.mStartCol + sh.mColCount)

100        returnQString();

101  

102    QAxObject* sheetObj = mWorkBook->querySubObject("Worksheets(int)", sheetIndex);

103    if(0 == sheetObj)

104        returnQString();

105    QAxObject* range    = sheetObj->querySubObject("Cells(int,int)", row, col);

106    if(0 == range)

107        returnQString();

108  

109    QVariant var = range->property("Value");

110    if(var.type() == QVariant::Invalid)

111        returnQString();

112  

113    returnvar.toString();

114}