How to identify 2 Dimensional Array's position with respect to CSV cells in java

Question

I want to get a 2 Dimensional Array's position in java.

Purpose: I get this 2 dimensional array from an CSV file for a validation. So I want to identify which one is invalid by mentioning its Cell position.

Example:

A B C D E

1 a b c d e

2 f g h i j

3 k l m n o

4 p q k r s

If I give 'h' in the a code with the above input, it should give me C2. API for this will be very helpful.

Can anyone help me in this please?

score 0 · Answer 1 · answered Nov 18 '12 at 11:30

0

Apache POI should help you for excel manipulation

answered Nov 18 '12 at 11:30

Saddam Abu Ghaida

6,381
2
22
29

Thanks for the reply. But will it give me the data's cell position? – Harish Raj Nov 18 '12 at 11:32
you need to search text in the cells and when found it will return the position of the cell. check this out http://stackoverflow.com/questions/9049995/java-poi-how-to-find-an-excel-cell-with-a-string-value-and-get-its-position-ro – Saddam Abu Ghaida Nov 18 '12 at 11:33
yes it works because you can open csv files as an excel sheet – Saddam Abu Ghaida Nov 18 '12 at 11:38
sorry. Apache POI doesn't support CSV file operation. – Harish Raj Nov 18 '12 at 20:49

score 0 · Accepted Answer · answered Nov 18 '12 at 20:10

Use the following method for better result.

private static String ConvertColumnNumberToChars( int i ){

if( i < 0 )
throw new UnsupportedOperationException("Converted number must be greater than zero.");

int iBase = 'Z' - 'A'+1;
if( iBase > Character.MAX_RADIX )
throw new UnsupportedOperationException("This JRE can't convert to radix greater than "+Character.MAX_RADIX);

String interConversion = Integer.toString(i-1, iBase).toUpperCase();

//System.out.print("inter: "+ interConversion +";  ");

char[] ac = interConversion.toCharArray();

for( int j = 0; j < ac.length; j++ ) {

int poziceOdzadu = ac.length - j - 1;
char c = ac[j];
ac[j] =  (char) ('A' - poziceOdzadu + Character.digit( c, iBase ));

}
return String.copyValueOf( ac );

}

All you gotta do is to input an int value to this method which want to change to the column name.

String Value's Row Number+1 is the Row Number of the CSV file and ConvertColumnNumberToChars(Number+1) is the column character name.

Good Luck!

How to identify 2 Dimensional Array's position with respect to CSV cells in java

2 Answers2