Working with tJavaRow - Excel

[EnriqueLDE]

Hello,

I have this code to work with Excel rows using tJavaRow:

I have these doubts:

1-) output_row.A = input_row.A.toLowerCase() modifies the entire column i'm working with, i would like to know how do i modify only a single cell, not an entire column. For example, something like A2.toLowerCase();

2-) Is there any Java library to work with Excel files? Im new using tJavaRow and i haven't worked with java code in Talend components yet. 

[akumar2301]

https://help.talend.com/reader/eh9WpFesWS~soEOr0cnHCQ/d5pHWffz0ZuTR9btmVVmQQ

this would help. To get A2 , you could do like this :

int seq=Numeric.sequence("xyz",1,1);
if (seq == 2) {
output_row.A = input_row.A.toLowerCase();
}else {
output_row.A = input_row.A;
}

[akumar2301]

there is custom component tFileExcelReferencedCellInput . You coud try that as well.

[EnriqueLDE]

@uganesh That's what i need. Thank you!