Re: Getting incorrect value while trying to extract content from xlsx

[Otis Gospodnetic <ot...@yahoo.com>]

Koushik,

You didn't say much about how you are doing the extraction.  Note that Solr doesn't do any extraction from spreadsheets, even though it has a component (known as Solr Cell) to provide that interface.  The actual extraction is done by a tool called Tika, or more precisely, POI, both of which are separate Apache projects.  Asking there may get you to the solution faster.


Otis --
Sematext -- http://sematext.com/ -- Lucene - Solr - Nutch



----- Original Message ----
> From: Koushik Mitra <Ko...@infosys.com>
> To: "solr-user@lucene.apache.org" <so...@lucene.apache.org>
> Sent: Tuesday, April 28, 2009 4:17:00 AM
> Subject: Getting incorrect value while trying to extract content from xlsx 
> 
> HI,
> 
> I was trying to extract content from an xlsx file for indexing.
> However, I am getting julian date value for a cell with date format and '1.0' in 
> place of '100%'.
> I want to retain the value as present in that xlsx file.
> 
> Solution appreciated.
> 
> Thanks,
> Koushik
> 
> **************** CAUTION - Disclaimer *****************
> This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely 
> for the use of the addressee(s). If you are not the intended recipient, please 
> notify the sender by e-mail and delete the original message. Further, you are 
> not 
> to copy, disclose, or distribute this e-mail or its contents to any other person 
> and 
> any such actions are unlawful. This e-mail may contain viruses. Infosys has 
> taken 
> every reasonable precaution to minimize this risk, but is not liable for any 
> damage 
> you may sustain as a result of any virus in this e-mail. You should carry out 
> your 
> own virus checks before opening the e-mail or attachment. Infosys reserves the 
> right to monitor and review the content of all messages sent to or from this 
> e-mail 
> address. Messages sent to or from this e-mail address may be stored on the 
> Infosys e-mail system.
> ***INFOSYS******** End of Disclaimer ********INFOSYS***