C++ 读取xls 文件数据

LanComer

已于 2023-09-09 22:18:13 修改

阅读量325

点赞数

文章标签： c++ 开发语言算法

于 2023-09-09 18:41:36 首次发布

本文链接：https://blog.csdn.net/u012586487/article/details/132780810

版权

接入第三方库引Read Excel file in C++

具体配置，参考帖子：

https://blog.csdn.net/u012586487/article/details/132782611?spm=1001.2014.3001.5502

Reading data

This example reads data from all cells of sheet, detects type of cells and prints theirs values.

#include <iostream>
#include "libxl.h"

using namespace libxl;

int main() 
{
   Book* book = xlCreateBook();

   if(book->load(L"input.xls"))
   {
      Sheet* sheet = book->getSheet(0);
      if(sheet)
      {
         for(int row = sheet->firstRow(); row < sheet->lastRow(); ++row)
         {
            for(int col = sheet->firstCol(); col < sheet->lastCol(); ++col)
            {
               CellType cellType = sheet->cellType(row, col);
               std::wcout << "(" << row << ", " << col << ") = ";
               if(sheet->isFormula(row, col))
               {
                  const wchar_t* s = sheet->readFormula(row, col);
                  std::wcout << (s ? s : L"null") << " [formula]";
               }
               else
               {
                  switch(cellType)
                  {
                     case CELLTYPE_EMPTY: std::wcout << "[empty]"; break;
                     case CELLTYPE_NUMBER:
                     {
                        double d = sheet->readNum(row, col);
                        std::wcout << d << " [number]";
                        break;
                     }
                     case CELLTYPE_STRING:
                     {
                        const wchar_t* s = sheet->readStr(row, col);
                        std::wcout << (s ? s : L"null") << " [string]";
                        break;        
                     }
                     case CELLTYPE_BOOLEAN:
                     {
                        bool b = sheet->readBool(row, col);
                        std::wcout << (b ? "true" : "false") << " [boolean]";
                        break;
                     }
                     case CELLTYPE_BLANK: std::wcout << "[blank]"; break;
                     case CELLTYPE_ERROR: std::wcout << "[error]"; break;
                  }
               }
               std::wcout << std::endl;
            }
         }
      }
   }

   book->release();
   return 0;
}