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

2009-04-28 Thread Otis Gospodnetic
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 > p

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

2009-04-28 Thread Erik Hatcher
How are you indexing it? A sample of the CSV file would be helpful. Note that while the CSV update handler is very convenient and very fast, it also doesn't have much in the way of data massaging/ transformation - so it might require you pre-format the data for Solr ingestion, or have a p

Getting incorrect value while trying to extract content from xlsx

2009-04-28 Thread Koushik Mitra
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 - Discla