topic Re: Working with tJavaRow - Excel in Talend Studio

Working with tJavaRow - Excel

EnriqueLDE — Thu, 17 Jan 2019 12:41:04 GMT

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.

Re: Working with tJavaRow - Excel

akumar2301 — Thu, 17 Jan 2019 13:11:40 GMT

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;
}

Re: Working with tJavaRow - Excel

akumar2301 — Thu, 17 Jan 2019 13:13:44 GMT

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

Re: Working with tJavaRow - Excel

EnriqueLDE — Thu, 17 Jan 2019 13:42:36 GMT

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