Thread: cell size excel and java

Since the size () method exists with Arrraylist, to know the size of the elements.

Instead using apache then how can I know the cell size in excel, to know how many records there are?

public void fillDispositivoVeicoloIDVEICOLO() {
  for (int rowIndex = 1; rowIndex < 281 ; rowIndex++) {
       currentRow = dataTypeSheet.getRow(rowIndex);
       cell_id_veicolo = currentRow.getCell(8); // Cella I
       id_veicolo.add(cell_id_veicolo.getStringCellValue());
   }
       System.out.println(id_veicolo);
}

instead of 281 what should I put in it? given that in Excel there are 281 records?

--- Update ---

public void fillDispositivoVeicoloIDVEICOLO() {
  for (int rowIndex = 1; rowIndex < dataTypeSheet.getLastRowNum() ; rowIndex++) {
       currentRow = dataTypeSheet.getRow(rowIndex);
       cell_id_veicolo = currentRow.getCell(8); // Cella I
       id_veicolo.add(cell_id_veicolo.getStringCellValue());
   }
       System.out.println(id_veicolo);
}

Error:
Exception in thread "main" java.lang.NullPointerException
at it.cliente.Cliente.fillVeicoloId(Cliente.java:112)
at it.cliente.Test.main(Test.java:15)

dataTypeSheet.getLastRowNum() -->
returns me 1000

the error is here:
id_veicolo.add(cell_id_veicolo.getStringCellValue( ));


now it works but the problem is always the index

public void fillTarga() {
		for (int rowIndex = 1; rowIndex < dataTypeSheet.getPhysicalNumberOfRows(); rowIndex++) {
			currentRow = dataTypeSheet.getRow(rowIndex);
			cell_targa = currentRow.getCell(21); // Cella V
			if( cell_targa != null)
			targa.add(cell_targa.getStringCellValue());
		}
 
		System.out.println(targa);
	}
 
Error:
Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 12, Size: 12
at java.util.ArrayList.rangeCheck(ArrayList.java:657)
at java.util.ArrayList.get(ArrayList.java:433)
at it.cliente.Confrontare.confrontaTargheVeicolo(Confrontare.java:97)
at it.cliente.Test.main(Test.java:10)

What class is dataTypeSheet? Is there API doc for that class that describes what you need to use it?

Are there other alternatives?

I do not know.

What class is dataTypeSheet? Is there API doc for that class that describes what you need to use it?
Please post a link to the API doc for the class.

Please post a link to the API doc for the class

Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 12, Size: 12
at java.util.ArrayList.rangeCheck(ArrayList.java:657)
at java.util.ArrayList.get(ArrayList.java:433)
at it.cliente.Confrontare.confrontaTargheVeicolo(Conf rontare.java:97)

What statement is at line 97?
Why does that statement use an index past the end? If the list has 12 elements, then 11 is the maximum index allowed.

always error indexes

I see 2 indexes. Which one has the invalid value in it?

cliente.getTarga()

Does that mean the index variable: clienteIndex has the wrong value?

Why does the code get the index value control value from cliente.getVeicoloId().size()
but uses the index in cliente.getTarga()?
It seems those two lists should be the same one.

yes, as you can see in the code they use the index, I don't know how I can solve, they are days that pass
(cliente.getTarga().get(clienteIndex)


When I compare in the first sheet it appears that there are 13 records and instead in the second sheet it is 16 records, when I make plaque .equals (plaque) it must return me based on the index of values.

I don't know how I can solve

Use the same reference to the list to get its size and to get an element from the list. For example:

  for (clienteIndex = 0; clienteIndex < cliente.getTarga().size(); clienteIndex++) {
...
     if (cliente.getTarga().get(clienteIndex).equals(veicolo.getTarga().get(veicoloIndex)))

i have to use only 1 index

One index for each list because it is possible for the lists to have different sizes.

since they are two lists. Just 1 index is enough

I think you have misunderstood me. If there are three lists and the lists are not guaranteed to all be the same size, then there must be 3 indexes, one for each list.

they have different sizes?

Use one index for each list. 2 lists requires 2 indexes.

As I understand the error gives me when I change the license plates in the Excel file.
When the plates have changed and they go into the else, they have to insert and here they go wrong because the indexes are not respectedv

Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 12, Size: 12
at java.util.ArrayList.rangeCheck(ArrayList.java:657)
at java.util.ArrayList.get(ArrayList.java:433)
at it.cliente.Confrontare.confrontaTargheVeicolo(Conf rontare.java:97)
at it.cliente.Test.main(Test.java:10)


error always in the for loop of idici, I'll show you the excel file

Exception in thread "main" java.lang.IndexOutOfBoundsException: Index: 12, Size: 12

The maximum index in a list with 12 elements is 11. Check the code to see why it is using an index past the end of the list.
What statement gives that exception?
What is the name of the list?
What is the name of the index variable with the value that is past the end of the list?
How does that index variable get a value past the end of the list?

If it is in a loop, the loop control expression should keep the index from going past the end. For example:
for(int theIndex = 0; theIndex < theList.size(); theIndex++)
The expression in red keeps theIndex from going past the end of theList

I checked the indexes and return both 12 values.

That does not make sense to me.
Do you mean that the code called the size() method for each list and they both returned 12?
That is what the exception message says: the size of the list is 12.
The problem is that the index to the list has a value of 12 which is too big. The maximum value for an index is 11 when the size is 12.

Can you answer these 3 questions?
1-What statement gives that exception?
2-What is the name of the list?
3-What is the name of the index variable with the value that is past the end of the list?