Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • Users
  • Groups
  • Search
  • Get Qt Extensions
  • Unsolved
Collapse
Brand Logo
  1. Home
  2. Qt Development
  3. General and Desktop
  4. Problem while Reading data from excel sheet
Forum Updated to NodeBB v4.3 + New Features

Problem while Reading data from excel sheet

Scheduled Pinned Locked Moved General and Desktop
3 Posts 2 Posters 1.4k Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • S Offline
    S Offline
    Swinetha
    wrote on last edited by
    #1

    hi

    I want data from excel sheet, so I found libxl-3.5.3.0 using this I am able write and read data for single cell and 10 rows

    but I want to read more than 200 rows, below is the code I have written for reading excel sheet is there any mistake in my code or the capability of excel sheet reading is that much only?
    @
    using namespace libxl;
    Book* book = xlCreateBook();
    if(book)
    {
    if(book->load("Type_B.xls"))
    {
    Sheet* sheet = book->getSheet(0);
    if(sheet)
    {
    for(int i=0;i<=200;i++)
    {
    for(int j=0;j<12;j++)
    {
    double d = sheet->readNum(i, j);
    QString str=QString::number(d);
    qDebug(str.toLatin1());
    }
    }
    }
    }
    book->release();
    }
    @
    please let me know what is my problem

    1 Reply Last reply
    0
    • K Offline
      K Offline
      koahnig
      wrote on last edited by
      #2

      Why should that be a Qt problem?

      libxl is a commercial product. You should ask them. If you are using a free trial version, it may have exactly those limitations you see.

      Vote the answer(s) that helped you to solve your issue(s)

      1 Reply Last reply
      0
      • S Offline
        S Offline
        Swinetha
        wrote on last edited by
        #3

        thank you for ur reply

        1 Reply Last reply
        0

        • Login

        • Login or register to search.
        • First post
          Last post
        0
        • Categories
        • Recent
        • Tags
        • Popular
        • Users
        • Groups
        • Search
        • Get Qt Extensions
        • Unsolved