Problem while Reading data from excel sheet
-
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 -
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.
-
thank you for ur reply