devbox
盐析白兔
这个屌丝很懒，什么也没留下！
关注作者
热门标签
热门文章
当前位置:   article > 正文

qt5 windows Excel QAxObject导入导出_qt多表格输出qaxobject

作者：盐析白兔 | 2024-03-01 03:15:11

赞

踩

qt多表格输出qaxobject

1、点击导入按钮，弹出excel表格选择框，选择后读取内容：

  1. //在头文件中定义
  2. QScopedPointer<ExcelBase> m_xls;
  3. //下面是点击导入excel代码
  4. QString xlsFile = QFileDialog::getOpenFileName(this,QString(),QString(),"excel(*.xls*.xlsx)");
  5. qDebug()<<xlsFile;
  6. if(xlsFile.isEmpty()){
  7.     return;
  8. }
  9. QList< QList<QVariant> > m_datas;
  10. if(m_xls.isNull())
  11.      m_xls.reset(new ExcelBase);
  12. m_xls->open(xlsFile);
  13.  
  14. m_xls->setCurrentSheet(1);
  15. m_xls->readAll(m_datas);
  16. for (int j = 0; j < m_datas[i].size(); ++j) {
  17.     for (int j = 0; j < m_datas[i].size(); ++j) {
  18.           QString imei = m_datas[i][j].toString();
  19.            //这个imei就是第i行第j列读取出来的数据     
  20.     }      
  21.  }
  22. //这mxls中操作创建文件比较耗时，建议新建线程使用。

2、点击到处按钮，弹出选择保存excel的路径，然后存入数据。

  1. //头文件定义
  2. QScopedPointer<ExcelBase> m_xls;
  3.  
  4. //点击导出
  5. //生成导出数据
  6. QList< QList<QVariant> > m_datas;
  7. for(int i = 0;i < 1000;i++){
  8.     QList<QVariant> rows;
  9.     for(int j = 0; j < 8;j++){
  10.         rows<<"这里写入值";
  11.     }
  12.     m_datas<<rows;
  13. }   
  14. //保存文件名
  15. QString xlsFile = QFileDialog::getExistingDirectory(this);
  16.     if(xlsFile.isEmpty()){
  17.         return;
  18.     }
  19. QDateTime current_time = QDateTime::currentDateTime();
  20. //显示时间，格式为：年-月-日 时：分：秒 周几
  21. QString StrCurrentTime = current_time.toString("yyyy年MM月dd日_hh时mm分ss秒");
  22. xlsFile += "/xds_";
  23. xlsFile.append(StrCurrentTime).append(".xlsx");
  24.  
  25.  
  26.  if(m_xls.isNull())
  27.         m_xls.reset(new ExcelBase);
  28.  m_xls->create(xlsFile);
  29.  
  30.  m_xls->setCurrentSheet(1);
  31.  bool result = m_xls->writeCurrentSheet(m_datas);
  32.  m_xls->save();
  33.  m_xls.reset();
  34.  if(result){
  35.     //导出成功
  36.   }else{
  37.     //导出失败
  38. }
  39.  
  40.  
  41. //xls创建相关操作比较耗时，建议放在新线程中

3、别忘记pro文件中添加

QT += axcontainer

4、最后是一个别人写的工具类ExcelBase

h文件如下：

  1. #ifndef EXCELREADER_H
  2. #define EXCELREADER_H
  3. #include <QObject>
  4. #include <QAxObject>
  5. #include <QString>
  6. #include <QStringList>
  7. #include <QVariant>
  8.  
  9. class ExcelBasePrivate;
  10. ///
  11. /// \brief win下excel快速读取类
  12. /// 参考天池项目源码，天池源码地址：https://github.com/qtcn/tianchi/blob/v0.0.2-build20130701/include/tianchi/file/tcmsexcel.h
  13. ///
  14. class ExcelBase : public QObject
  15. {
  16. public:
  17.     ExcelBase(QObject* par=NULL);
  18.     ~ExcelBase();
  19. private:
  20.     Q_DISABLE_COPY(ExcelBase)
  21.     Q_DECLARE_PRIVATE(ExcelBase)
  22.     ExcelBasePrivate* const d_ptr;
  23. public:
  24.     /// @brief 设置方向的常数
  25.     enum Alignment
  26.     {
  27.         xlTop    = -4160, ///< 靠上
  28.         xlLeft   = -4131, ///< 靠左
  29.         xlRight  = -4152, ///< 靠右
  30.         xlCenter = -4108, ///< 居中
  31.         xlBottom = -4107  ///< 靠下
  32.     };
  33.  
  34.     /// @brief 创建一个Microsoft Excel文件
  35.     bool create(const QString& filename = QString());
  36.     /// @brief 打开一个Microsoft Excel文件
  37.     bool open(const QString& filename = QString());
  38.     /// @brief 另存Microsoft Excel文件
  39.     void saveAs(const QString& filename);
  40.     void save();
  41.     /// @brief 关闭Microsoft Excel文件
  42.     void close();
  43.     /// @brief 踢出当前打开的 Microsoft Excel<br>
  44.     /// @brief 放弃此对象对该 Excel 的控制权<br>
  45.     /// @brief Excel 文件仍保持打开，但丧失了控制权
  46.     void kick();
  47.  
  48.     /// @brief 设置当前打开的 Excel 是否可见
  49.     void setVisible(bool value);
  50.     /// @brief 设置 Excel 文档的标题
  51.     void setCaption(const QString& value);
  52.  
  53.     /// @brief 新建一本 Excel 文档
  54.     bool addBook();
  55.  
  56.     /// @brief 返回当前 Excel 的 Sheet 数量
  57.     int sheetCount();
  58.  
  59.     /// @brief 返回当前打开的 Excel 全部 Sheet 名
  60.     QStringList sheetNames();
  61.  
  62.     /// @brief 返回当前 Sheet.
  63.     bool currentSheet();
  64.  
  65.     /// @brief 设置并指定当前 Sheet.
  66.     /// @param [in] 当前 Sheet 索引，从 1 开始
  67.     bool setCurrentSheet(int index);
  68.  
  69.     /// @brief 当前打开的 Excel 的 Sheet 名
  70.     QString currentSheetName();
  71.  
  72.     /// @brief 读取单元格 Sheet 的内容
  73.     /// @param [in] row 行号，从 1 开始
  74.     /// @param [in] col 列号，从 1 开始
  75.     /// @return 返回指定单元格的内容
  76.     QVariant read(int row, int col);
  77.  
  78.     /// @brief 读取单元格 Sheet 的内容
  79.     /// @param [in] row 行号，从 1 开始
  80.     /// @param [in] col 列号，从 1 开始
  81.     /// @return 返回指定单元格的内容
  82.     inline QVariant cell(int row, int col) { return read(row, col); }
  83.  
  84.     /// @brief 写入单元格 Sheet 的内容
  85.     /// @param [in] row 行号，从 1 开始
  86.     /// @param [in] col 列号，从 1 开始
  87.     /// @param [in] value 准备写入的内容
  88.     void write(int row, int col, const QVariant& value);
  89.  
  90.     void cellFormat(int row, int col, const QString& format);
  91.     void cellAlign(int row, int col, Alignment hAlign, Alignment vAlign);
  92.  
  93.     /// @brief 获取有效区域信息
  94.     /// @see rowStart() const
  95.     /// @see rowEnd() const
  96.     /// @see colStart() const
  97.     /// @see colEnd() const
  98.     bool usedRange(int& rowStart, int& colStart, int &rowEnd, int &colEnd);
  99.  
  100.     QVariant readAll();
  101.     void readAll(QList<QList<QVariant> > &cells);
  102.     bool writeCurrentSheet(const QList<QList<QVariant> > &cells);
  103.  
  104.     static void convertToColName(int data, QString &res);
  105.     static QString to26AlphabetString(int data);
  106.     static void castListListVariant2Variant(const QList<QList<QVariant> > &cells, QVariant &res);
  107.     static void castVariant2ListListVariant(const QVariant& var,QList<QList<QVariant> > &res);
  108. };
  109.  
  110. #endif // EXCELREADER_H

cpp文件如下：

  1. #include "ExcelBase.h"
  2. #include <QFile>
  3.  
  4. #include <QList>
  5. #include <QDebug>
  6. #if defined(Q_OS_WIN)
  7. #include <ActiveQt/QAxObject>
  8. #endif // Q_OS_WIN
  9.  
  10.  
  11.  
  12. #define TC_FREE(x)  {delete x; x=NULL;}
  13.  
  14. class ExcelBasePrivate
  15. {
  16.     Q_DECLARE_PUBLIC(ExcelBase)
  17. public:
  18.     explicit ExcelBasePrivate(ExcelBase* qptr);
  19.     ~ExcelBasePrivate();
  20.  
  21.     void construct();
  22.     void destory();
  23.  
  24.     ExcelBase* const q_ptr;
  25.  
  26. #if defined(Q_OS_WIN)
  27.     QAxObject*  excel;
  28.     QAxObject*  books;
  29.     QAxObject*  book;
  30.     QAxObject*  sheets;
  31.     QAxObject*  sheet;
  32. #endif
  33.     QString     filename;
  34.     QString     sheetName;
  35. };
  36.  
  37. ExcelBasePrivate::ExcelBasePrivate(ExcelBase *qptr)
  38.     : q_ptr(qptr)
  39. #if defined(Q_OS_WIN)
  40.     , excel(NULL)
  41.     , books(NULL)
  42.     , book(NULL)
  43.     , sheets(NULL)
  44.     , sheet(NULL)
  45. #endif // Q_OS_WIN
  46. {
  47. }
  48.  
  49. ExcelBasePrivate::~ExcelBasePrivate()
  50. {
  51. #if defined(Q_OS_WIN)
  52.     if(excel)
  53.     {
  54.         if (!excel->isNull())
  55.         {
  56.             excel->dynamicCall("Quit()");
  57.         }
  58.     }
  59.     TC_FREE(sheet );
  60.     TC_FREE(sheets);
  61.     TC_FREE(book  );
  62.     TC_FREE(books );
  63.     TC_FREE(excel );
  64. #endif // Q_OS_WIN
  65. }
  66.  
  67. void ExcelBasePrivate::construct()
  68. {
  69. #if defined(Q_OS_WIN)
  70.     destory();
  71.     excel = new QAxObject(q_ptr);
  72.     excel->setControl("Excel.Application");
  73.     excel->setProperty("Visible",false);
  74.     if (excel->isNull())
  75.     {
  76.         excel->setControl("ET.Application");
  77.     }
  78.     if (!excel->isNull())
  79.     {
  80.         books = excel->querySubObject("Workbooks");
  81.     }
  82. #endif // Q_OS_WIN
  83. }
  84.  
  85. void ExcelBasePrivate::destory()
  86. {
  87. #if defined(Q_OS_WIN)
  88.     TC_FREE(sheet );
  89.     TC_FREE(sheets);
  90.     if (book != NULL && ! book->isNull())
  91.     {
  92.         book->dynamicCall("Close(Boolean)", false);
  93.     }
  94.     TC_FREE(book );
  95.     TC_FREE(books);
  96.     if (excel != NULL && !excel->isNull())
  97.     {
  98.         excel->dynamicCall("Quit()");
  99.     }
  100.     TC_FREE(excel);
  101.     filename  = "";
  102.     sheetName = "";
  103. #endif // Q_OS_WIN
  104. }
  105.  
  106.  
  107. ExcelBase::ExcelBase(QObject* par):QObject(par)
  108.     ,d_ptr(new ExcelBasePrivate(this))
  109. {
  110. }
  111.  
  112. ExcelBase::~ExcelBase()
  113. {
  114.     close();
  115.     delete d_ptr;
  116. }
  117.  
  118. bool ExcelBase::create(const QString& filename)
  119. {
  120.     bool ret = false;
  121. #if defined(Q_OS_WIN)
  122.     Q_D(ExcelBase);
  123.     d->construct();
  124.     if (d->books != NULL && ! d->books->isNull())
  125.     {
  126.         d->books->dynamicCall("Add");
  127.         d->book   = d->excel->querySubObject("ActiveWorkBook");
  128.         d->sheets = d->book ->querySubObject("WorkSheets"    );
  129.         currentSheet();
  130.         d->filename = filename;
  131.         ret = true;
  132.     }
  133. #else
  134.     Q_UNUSED(filename)
  135. #endif // Q_OS_WIN
  136.     return ret;
  137. }
  138.  
  139. bool ExcelBase::open(const QString& filename)
  140. {
  141.     bool ret = false;
  142. #if defined(Q_OS_WIN)
  143.     Q_D(ExcelBase);
  144.     d->construct();
  145.     if ( d->books != NULL && ! d->books->isNull() )
  146.     {
  147.         d->book = d->books->querySubObject("Open(QString, QVariant)", filename, 0);
  148.         ret = d->book != NULL && ! d->book->isNull();
  149.         if ( ret )
  150.         {
  151.             d->sheets = d->book->querySubObject("WorkSheets");
  152.             d->filename = filename;
  153.             currentSheet();
  154.         }
  155.     }
  156. #else
  157.     Q_UNUSED(filename)
  158. #endif // Q_OS_WIN
  159.     return ret;
  160. }
  161.  
  162. void ExcelBase::saveAs(const QString& filename)
  163. {
  164. #if defined(Q_OS_WIN)
  165.     Q_D(ExcelBase);
  166.     if ( d->book != NULL && ! d->book->isNull() )
  167.     {
  168.         d->filename = filename;
  169.         QString strPath = d->filename;
  170.         strPath = strPath.replace('/','\\');
  171.         qDebug()<<strPath;
  172.         d->book->dynamicCall("SaveAs(const QString&,int,const QString&,const QString&,bool,bool)", strPath
  173.                              ,56,QString(""),QString(""),false,false);
  174.     }
  175. #else
  176.     Q_UNUSED(filename)
  177. #endif // Q_OS_WIN
  178. }
  179. ///
  180. /// \brief 保存excel
  181. ///
  182. void ExcelBase::save()
  183. {
  184. #if defined(Q_OS_WIN)
  185.     Q_D(ExcelBase);
  186.     if(d->filename.isEmpty())
  187.         return;
  188.     saveAs(d->filename);
  189. #else
  190.     Q_UNUSED(filename)
  191. #endif // Q_OS_WIN
  192. }
  193.  
  194. void ExcelBase::close()
  195. {
  196. #if defined(Q_OS_WIN)
  197.     Q_D(ExcelBase);
  198.     d->destory();
  199. #endif // Q_OS_WIN
  200. }
  201.  
  202. void ExcelBase::kick()
  203. {
  204. #if defined(Q_OS_WIN)
  205.     Q_D(ExcelBase);
  206.  
  207.     if (d->excel != NULL && !d->excel->isNull())
  208.     {
  209.         d->excel->setProperty("Visible", true);
  210.     }
  211.     TC_FREE(d->sheet );
  212.     TC_FREE(d->sheets);
  213.     TC_FREE(d->book  );
  214.     TC_FREE(d->books );
  215.     TC_FREE(d->excel );
  216.     d->destory();
  217. #endif // Q_OS_WIN
  218. }
  219.  
  220. QStringList ExcelBase::sheetNames()
  221. {
  222.     QStringList ret;
  223. #if defined(Q_OS_WIN)
  224.     Q_D(ExcelBase);
  225.     if (d->sheets != NULL && !d->sheets->isNull())
  226.     {
  227.         int sheetCount = d->sheets->property("Count").toInt();
  228.         for (int i = 1; i <= sheetCount; i++)
  229.         {
  230.             QAxObject* sheet = d->sheets->querySubObject("Item(int)", i);
  231.             if(NULL == sheet || sheet->isNull())
  232.                 continue;
  233.             ret.append(sheet->property("Name").toString());
  234.             delete sheet;
  235.         }
  236.     }
  237. #endif // Q_OS_WIN
  238.     return ret;
  239. }
  240.  
  241. QString ExcelBase::currentSheetName()
  242. {
  243.     Q_D(ExcelBase);
  244.     return d->sheetName;
  245. }
  246.  
  247. void ExcelBase::setVisible(bool value)
  248. {
  249. #if defined(Q_OS_WIN)
  250.     Q_D(ExcelBase);
  251.     if (d->excel != NULL && !d->excel->isNull())
  252.     {
  253.         d->excel->setProperty("Visible", value);
  254.     }
  255. #else
  256.     Q_UNUSED(value)
  257. #endif // Q_OS_WIN
  258. }
  259.  
  260. void ExcelBase::setCaption(const QString& value)
  261. {
  262. #if defined(Q_OS_WIN)
  263.     Q_D(ExcelBase);
  264.     if (d->excel != NULL && !d->excel->isNull())
  265.     {
  266.         d->excel->setProperty("Caption", value);
  267.     }
  268. #else
  269.     Q_UNUSED(value)
  270. #endif // Q_OS_WIN
  271. }
  272.  
  273. bool ExcelBase::addBook()
  274. {
  275.     bool ret = false;
  276. #if defined(Q_OS_WIN)
  277.     Q_D(ExcelBase);
  278.     if (d->excel != NULL && !d->excel->isNull())
  279.     {
  280.         TC_FREE(d->sheet );
  281.         TC_FREE(d->sheets);
  282.         TC_FREE(d->book  );
  283.         TC_FREE(d->books );
  284.         d->books = d->excel->querySubObject("WorkBooks");
  285.         ret = d->books != NULL && !d->books->isNull();
  286.     }
  287. #endif // Q_OS_WIN
  288.     return ret;
  289. }
  290.  
  291. bool ExcelBase::currentSheet()
  292. {
  293.     bool ret = false;
  294. #if defined(Q_OS_WIN)
  295.     Q_D(ExcelBase);
  296.     TC_FREE(d->sheet);
  297.     if (d->excel != NULL && !d->excel->isNull())
  298.     {
  299.         TC_FREE(d->sheet);
  300.         d->sheet = d->excel->querySubObject("ActiveWorkBook");
  301.         ret = d->sheet != NULL && !d->sheet->isNull();
  302.         d->sheetName = ret ? d->sheet->property("Name").toString() : "";
  303.     }
  304. #endif // Q_OS_WIN
  305.     return ret;
  306. }
  307.  
  308. bool ExcelBase::setCurrentSheet(int index)
  309. {
  310.     bool ret = false;
  311. #if defined(Q_OS_WIN)
  312.     Q_D(ExcelBase);
  313.     if (d->sheets != NULL && !d->sheets->isNull())
  314.     {
  315.         TC_FREE(d->sheet);
  316.         d->sheet = d->sheets->querySubObject("Item(int)", index);
  317.         ret = d->sheet != NULL && ! d->sheet->isNull();
  318.         if(ret)
  319.         {
  320.             d->sheet->dynamicCall("Activate(void)");
  321.         }
  322.         d->sheetName = ret ? d->sheet->property("Name").toString() : "";
  323.     }
  324. #else
  325.     Q_UNUSED(index)
  326. #endif // Q_OS_WIN
  327.     return ret;
  328. }
  329.  
  330. int ExcelBase::sheetCount()
  331. {
  332.     int ret = 0;
  333. #if defined(Q_OS_WIN)
  334.     Q_D(ExcelBase);
  335.     if (d->sheets != NULL && ! d->sheets->isNull())
  336.     {
  337.         ret = d->sheets->property("Count").toInt();
  338.     }
  339. #endif // Q_OS_WIN
  340.     return ret;
  341. }
  342.  
  343. void ExcelBase::cellFormat(int row, int col, const QString& format)
  344. {
  345. #if defined(Q_OS_WIN)
  346.     Q_D(ExcelBase);
  347.     if (d->sheet != NULL && ! d->sheet->isNull())
  348.     {
  349.         QAxObject* range = d->sheet->querySubObject("Cells(int, int)", row, col);
  350.         range->setProperty("NumberFormatLocal", format);
  351.         delete range;
  352.     }
  353. #else
  354.     Q_UNUSED(row)
  355.     Q_UNUSED(col)
  356.     Q_UNUSED(format)
  357. #endif // Q_OS_WIN
  358. }
  359.  
  360. void ExcelBase::cellAlign(int row, int col, Alignment hAlign, Alignment vAlign)
  361. {
  362. #if defined(Q_OS_WIN)
  363.     Q_D(ExcelBase);
  364.     if (d->sheet != NULL && !d->sheet->isNull())
  365.     {
  366.         QAxObject* range = d->sheet->querySubObject("Cells(int, int)", row, col);
  367.         range->setProperty("HorizontalAlignment", hAlign);
  368.         range->setProperty("VerticalAlignment",   vAlign);
  369.         delete range;
  370.     }
  371. #else
  372.     Q_UNUSED(row)
  373.     Q_UNUSED(col)
  374.     Q_UNUSED(hAlign)
  375.     Q_UNUSED(vAlign)
  376. #endif // Q_OS_WIN
  377. }
  378.  
  379. QVariant ExcelBase::read(int row, int col)
  380. {
  381.     QVariant ret;
  382. #if defined(Q_OS_WIN)
  383.     Q_D(ExcelBase);
  384.     if (d->sheet != NULL && ! d->sheet->isNull())
  385.     {
  386.         QAxObject* range = d->sheet->querySubObject("Cells(int, int)", row, col);
  387.         //ret = range->property("Value");
  388.         ret = range->dynamicCall("Value()");
  389.         delete range;
  390.     }
  391. #else
  392.     Q_UNUSED(row)
  393.     Q_UNUSED(col)
  394. #endif // Q_OS_WIN
  395.     return ret;
  396. }
  397.  
  398. void ExcelBase::write(int row, int col, const QVariant& value)
  399. {
  400. #if defined(Q_OS_WIN)
  401.     Q_D(ExcelBase);
  402.     if (d->sheet != NULL && ! d->sheet->isNull())
  403.     {
  404.         QAxObject* range = d->sheet->querySubObject("Cells(int, int)", row, col);
  405. //        range->setProperty("Value", value);
  406.         range->setProperty("Value2", value);//这里不能用Value他只能在office中写入，不能写入wps。  Value2两个都可以写入
  407.         delete range;
  408.     }
  409. #else
  410.     Q_UNUSED(row)
  411.     Q_UNUSED(col)
  412.     Q_UNUSED(value)
  413. #endif // Q_OS_WIN
  414. }
  415.  
  416. bool ExcelBase::usedRange(int& rowStart, int& colStart, int& rowEnd, int& colEnd)
  417. {
  418.     bool ret = false;
  419. #if defined(Q_OS_WIN)
  420.     Q_D(ExcelBase);
  421.     if (d->sheet != NULL && ! d->sheet->isNull())
  422.     {
  423.         QAxObject* urange  = d->sheet->querySubObject("UsedRange");
  424.         rowStart = urange->property("Row"   ).toInt();
  425.         colStart = urange->property("Column").toInt();
  426.         rowEnd   = urange->querySubObject("Rows"   )->property("Count").toInt();
  427.         colEnd   = urange->querySubObject("Columns")->property("Count").toInt();
  428.         delete urange;
  429.         ret = true;
  430.     }
  431. #else
  432.     Q_UNUSED(rowStart)
  433.     Q_UNUSED(colStart)
  434.     Q_UNUSED(rowEnd)
  435.     Q_UNUSED(colEnd)
  436. #endif // Q_OS_WIN
  437.     return ret;
  438. }
  439. ///
  440. /// \brief 读取整个sheet
  441. /// \return
  442. ///
  443. QVariant ExcelBase::readAll()
  444. {
  445.     QVariant var;
  446. #if defined(Q_OS_WIN)
  447.     Q_D(ExcelBase);
  448.     if (d->sheet != NULL && ! d->sheet->isNull())
  449.     {
  450.         QAxObject *usedRange = d->sheet->querySubObject("UsedRange");
  451.         if(NULL == usedRange || usedRange->isNull())
  452.         {
  453.             return var;
  454.         }
  455.         var = usedRange->dynamicCall("Value");
  456.         delete usedRange;
  457.     }
  458. #endif
  459.     return var;
  460. }
  461. ///
  462. /// \brief 读取整个sheet的数据，并放置到cells中
  463. /// \param cells
  464. ///
  465. void ExcelBase::readAll(QList<QList<QVariant> > &cells)
  466. {
  467. #if defined(Q_OS_WIN)
  468.     castVariant2ListListVariant(readAll(),cells);
  469. #else
  470.     Q_UNUSED(cells);
  471. #endif
  472.  
  473. }
  474.  
  475. ///
  476. /// \brief 写入一个表格内容
  477. /// \param cells
  478. /// \return 成功写入返回true
  479. /// \see readAllSheet
  480. ///
  481. bool ExcelBase::writeCurrentSheet(const QList<QList<QVariant> > &cells)
  482. {
  483. #if defined(Q_OS_WIN)
  484.     Q_D(ExcelBase);
  485.     if(cells.size() <= 0)
  486.         return false;
  487.     if(NULL == d->sheet || d->sheet->isNull())
  488.         return false;
  489.     int row = cells.size();
  490.     int col = cells.at(0).size();
  491.     QString rangStr;
  492.     convertToColName(col,rangStr);
  493.     rangStr += QString::number(row);
  494.     rangStr = "A1:" + rangStr;
  495.     qDebug()<<rangStr;
  496. //    QAxObject *range = d->sheet->querySubObject("Range(const QString&)",rangStr);
  497.     QVariantList params;
  498.     params<<"A1"<<rangStr;
  499.     QAxObject *range = d->sheet->querySubObject("Range(QVariant,QVariant)",params);
  500.     range->setProperty("ColumnWidth",25);
  501.     if(NULL == range || range->isNull())
  502.     {
  503.         return false;
  504.     }
  505.     bool succ = false;
  506.     QVariant var;
  507.     castListListVariant2Variant(cells,var);
  508.     succ = range->setProperty("Value2", var);//这里不能用Value他只能在office中写入，不能写入wps。  Value2两个都可以写入
  509.     delete range;
  510.     return succ;
  511. #else
  512.     return true;
  513. #endif
  514. }
  515. ///
  516. /// \brief 把列数转换为excel的字母列号
  517. /// \param data 大于0的数
  518. /// \return 字母列号，如1->A 26->Z 27 AA
  519. ///
  520. void ExcelBase::convertToColName(int data, QString &res)
  521. {
  522.     Q_ASSERT(data>0 && data<65535);
  523.     int tempData = data / 26;
  524.     if(tempData > 0)
  525.     {
  526.         int mode = data % 26;
  527.         convertToColName(mode,res);
  528.         convertToColName(tempData,res);
  529.     }
  530.     else
  531.     {
  532.         res=(to26AlphabetString(data)+res);
  533.     }
  534. }
  535. ///
  536. /// \brief 数字转换为26字母
  537. ///
  538. /// 1->A 26->Z
  539. /// \param data
  540. /// \return
  541. ///
  542. QString ExcelBase::to26AlphabetString(int data)
  543. {
  544.     QChar ch = data + 0x40;//A对应0x41
  545.     return QString(ch);
  546. }
  547. ///
  548. /// \brief QList<QList<QVariant> >转换为QVariant
  549. /// \param cells
  550. /// \return
  551. ///
  552. void ExcelBase::castListListVariant2Variant(const QList<QList<QVariant> > &cells, QVariant &res)
  553. {
  554.     QVariantList vars;
  555.     const int rows = cells.size();
  556.     for(int i=0;i<rows;++i)
  557.     {
  558.         vars.append(QVariant(cells[i]));
  559.     }
  560.     res = QVariant(vars);
  561. }
  562. ///
  563. /// \brief 把QVariant转为QList<QList<QVariant> >
  564. /// \param var
  565. /// \param res
  566. ///
  567. void ExcelBase::castVariant2ListListVariant(const QVariant &var, QList<QList<QVariant> > &res)
  568. {
  569.     QVariantList varRows = var.toList();
  570.     if(varRows.isEmpty())
  571.     {
  572.         return;
  573.     }
  574.     const int rowCount = varRows.size();
  575.     QVariantList rowData;
  576.     for(int i=0;i<rowCount;++i)
  577.     {
  578.         rowData = varRows[i].toList();
  579.         res.push_back(rowData);
  580.     }
  581. }

 

声明：本文内容由网友自发贡献，不代表【wpsshop博客】立场，版权归原作者所有，本站不承担相应法律责任。如您发现有侵权的内容，请联系我们。转载请注明出处：https://www.wpsshop.cn/w/盐析白兔/article/detail/170591?site
推荐阅读
相关标签

Copyright © 2003-2013 www.wpsshop.cn 版权所有，并保留所有权利。

  

闽ICP备14008679号