I'm implementing utility that uses Elasticsearch database and should be able to index excel files with specified file sctructure.
For instance, I have file with 3 columns:
UserId FirstName LastName
1 Alex Smith
2 John Johnson
I use ingest attachment plugin and examples in elasticsearch documentation and it works perfectly. In result I can find any excel file in elasticsearch by, for instance, 'Alex' or 'John' query.
But I don't undestand how to find files by specified columns. For instance, I want to find excel files, that contains 'Alex' in column FirstName, or contains 'Johnson' in column LastName.