how to extract a value of a cell in the excel with tfileinputexcel

[Anonymous]

i want to extract a value in a cell, i dont want to have all the column.
Could u help me please?

[Anonymous]

If I understand your question, you have a Cell, C4 for example, and you want to get this value.
I suggest you to create a schema with the cell name please verify that the schema of your cell has the right format.
A quite non elegant solution is to put into the tFileInputExcel value Header to 3 (for C4) and First column to 3 (for C)

[Anonymous]

thank u for ur help
but in the same file i want to get the value of 3 cells(B9,K24 and J7)

[Anonymous]

how can i create a schema with a cell?

[Anonymous]

you can use this method to get in my exemple the value of A3,C9 and B36

[Anonymous]

I advise you to read 970

[Anonymous]

i have followed u but it did not work.
i have only the out3 which contain K22 between tMap and tMysqlOutput.
i obtain this msg
Warning: Usage of a local non-builtin name
Unknown column 'K22' in 'field list'

[Anonymous]

these are the images of my work

[Anonymous]

,

[Anonymous]

the value of B9 is a string in the excel file
K22 is an integer
J7 is a date