# Unable to search in xls and xlsx

**URL:** <https://discuss.elastic.co/t/unable-to-search-in-xls-and-xlsx/12581>\
**Category:** Elasticsearch\
**Created:** [June 28, 2013, 12:40pm UTC](https://discuss.elastic.co/t/unable-to-search-in-xls-and-xlsx/12581 "2013-06-28T12:40:06Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![ujjwalkotdiya](https://avatars.discourse-cdn.com/v4/letter/u/c0e974/32.png) [@ujjwalkotdiya](https://discuss.elastic.co/u/ujjwalkotdiya)\
**Post date:** [June 28, 2013, 12:40pm UTC](https://discuss.elastic.co/t/unable-to-search-in-xls-and-xlsx/12581/1 "2013-06-28T12:40:06Z")

</div>

In large excel sheet iam able to search in starting but in the end of file unable to search.  
I had posted it in stack overflow.

link :- [http://stackoverflow.com/questions/17036856/searching-in-xls-and-xlsx-file-from-elasticsearch](http://stackoverflow.com/questions/17036856/searching-in-xls-and-xlsx-file-from-elasticsearch)

---

<div class="post-metadata">

**Author:** ![dadoonet](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/dadoonet/32/137187_2.png) [@dadoonet](https://discuss.elastic.co/u/dadoonet)\
**Post date:** [July 1, 2013, 3:09pm UTC](https://discuss.elastic.co/t/unable-to-search-in-xls-and-xlsx/12581/2 "2013-07-01T15:09:32Z")

</div>

I assume that you are using [GitHub - elastic/elasticsearch-mapper-attachments: Mapper Attachments Type plugin for Elasticsearch](https://github.com/elasticsearch/elasticsearch-mapper-attachments)?  
Check indexed characters option: [GitHub - elastic/elasticsearch-mapper-attachments: Mapper Attachments Type plugin for Elasticsearch](https://github.com/elasticsearch/elasticsearch-mapper-attachments#indexed-characters)

If it does not help, could you provide more details?

--  
David Pilato | Technical Advocate | [Elasticsearch.com](http://Elasticsearch.com)  
@dadoonet | @elasticsearchfr | @scrutmydocs

Le 28 juin 2013 à 14:40, ujjwalkotdiya [ujjwalkotdiya@gmail.com](mailto:ujjwalkotdiya@gmail.com) a écrit :

> In large excel sheet iam able to search in starting but in the end of file  
> unable to search.  
> I had posted it in stack overflow.
> 
> link :-  
> [http://stackoverflow.com/questions/17036856/searching-in-xls-and-xlsx-file-from-elasticsearch](http://stackoverflow.com/questions/17036856/searching-in-xls-and-xlsx-file-from-elasticsearch)
> 
> --  
> View this message in context: [http://elasticsearch-users.115913.n3.nabble.com/Unable-to-search-in-xls-and-xlsx-tp4037240.html](http://elasticsearch-users.115913.n3.nabble.com/Unable-to-search-in-xls-and-xlsx-tp4037240.html)  
> Sent from the Elasticsearch Users mailing list archive at [Nabble.com](http://Nabble.com).
> 
> --  
> You received this message because you are subscribed to the Google Groups "elasticsearch" group.  
> To unsubscribe from this group and stop receiving emails from it, send an email to [elasticsearch+unsubscribe@googlegroups.com](mailto:elasticsearch+unsubscribe@googlegroups.com).  
> For more options, visit [https://groups.google.com/groups/opt\_out](https://groups.google.com/groups/opt_out).

---

<div class="post-metadata">

**Author:** ![ujjwalkotdiya](https://avatars.discourse-cdn.com/v4/letter/u/c0e974/32.png) [@ujjwalkotdiya](https://discuss.elastic.co/u/ujjwalkotdiya)\
**Post date:** [July 2, 2013, 4:44am UTC](https://discuss.elastic.co/t/unable-to-search-in-xls-and-xlsx/12581/3 "2013-07-02T04:44:56Z")

</div>

I had already installed mapperattachment plugin and using it and even changed the parameter in elasticsearch.yml i.e.  
index.mapping.attachment.indexed\_chars=-1

The problem is :-- When files are of bigger size it's able to search content in the starting while at the end it is unable to search. For eg:- I had tried to search the content of this file which are present at last.

\<nabble\_a href="SessionAtt.xlsx"\>SessionAtt.xlsx\</nabble\_a\>

Its showing hit=0

Thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [July 6, 2017, 2:28am UTC](https://discuss.elastic.co/t/unable-to-search-in-xls-and-xlsx/12581/4 "2017-07-06T02:28:43Z")

</div>


