Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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

i want to extract a value in a cell, i dont want to have all the column.
Could u help me please?
Labels (2)
31 Replies
Anonymous
Not applicable
Author

you have to adapt the pattern to your own pattern, please check the different pattern
Anonymous
Not applicable
Author

I used the pattern "dd/MM/yyyy" which much with the type of the date in my excel file but this did not work
i have this msg
pattern cannot be resolved
stringDate cannot be resolved
even i used the pattern "dd-MM-yyyy" i have the same problem