How to read/write next row or column?

[feugen]

Hello,

how can I read the next row or column, it there a function for this? Probably you can give me an example? The problem is... I have to search for a patern where I dont know the position of the cell, so I have to search for the cell. As you understand, I cant do it manualy for a sheet with 100 rows and 100 columns. So I cant use xlsx.read("A1"); xlsx.read("A2"); 10000 times etc :-). Is there a way do do it? I tried to increase the position from A->B->C.....AA->AB etc and the same for columns 1->2 ->3 etc and put all together - but I failed do do it for characters so I cant put it together. I am able to work around this, but its still would be great to have something like nextrow and nextcolumn. thanks.

[luckyhacky]

You are using read("A1"), which is quite ok. But there is also an overloaded function ->

QVariant read(int row, int col);

you can do it his way:

for(int i=0; i < MAX_ROW; i++)
{
  for(int j=0; j < MAX_COL; j++)
  {
    if(xlsx.read(i, j).toString == "test") 
     // got it
  }
}

[dbzhang800]

Hi, as luckyhacky said, you can use

QVariant read(int row, int col);

Just note that, the index row and col starts from 1 instead of 0, so

read("A1") <==> read(1,1)
read("A2") <==> read(2,1)
read("B1") <==> read(1,2)

[feugen]

Hello,

thanks a lot guys thats exactly what I need. Case closed :-)