title: How should data in xlsx format be indexed in Solr?
body: <p>I have been tasked with uploading some data into Solr, whereupon it will be used for analysis. </p>
  
  <p>I understand that Solr can index data in xlsx file formats. </p>
  
  <p>In Exercise 2 for Solr, the following files were indexed in the order of json, xml and csv:</p>
  
  <pre><code>bin/post -c films example/films/films.json
  
  bin/post -c films example/films/films.xml
  
  bin/post -c films example/films/films.csv -params "f.genre.split=true&amp;f.directed_by.split=true&amp;f.genre.separator=|&amp;f.directed_by.separator=|"
  </code></pre>
  
  <p>The issue I have is that the though I indexed my xlsx file, it only shows one record in the query, which means that the file may have been indexed wrongly, ie it may require parameters such as that needed by a csv file. Can anyone tell me how this indexing can be done without having to convert the xlsx file into a csv file?  </p>