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

Problem while Reading data from excel sheet

Scheduled Pinned Locked Moved General and Desktop
3 Posts 2 Posters 1.5k 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