Hi, Thanks a lot for your update. Have you checked that all the create dates you get from the summary information are right ?? I created a few excel files the normal way and tried to retrieve the creation date for all. What I got was wrong in some cases. That is still the issue.
Thanks Kavita. John Byrne-7 wrote: > > I just used the Example code to read the summary Date of Creation with > version 3.2. Maybe you could compare your code with the example and see > what's different? It worked fine for me. > > John Byrne > > (I've attached the example below for your convenience but it's in the > source code download as well if you want to get it from there. (I have > version 3.2)) > > John > > John Byrne > Support Network for Battered Women > 1257 Tasman Dr. Suite C > Sunnyvale, CA > 94089 > > (408) 541-6100 x 138 > Fax: (408) 541-3333 > > --------- code starts here. > > > /* ==================================================================== > Licensed to the Apache Software Foundation (ASF) under one or more > contributor license agreements. See the NOTICE file distributed with > this work for additional information regarding copyright ownership. > The ASF licenses this file to You under the Apache License, Version 2.0 > (the "License"); you may not use this file except in compliance with > the License. You may obtain a copy of the License at > > http://www.apache.org/licenses/LICENSE-2.0 > > Unless required by applicable law or agreed to in writing, software > distributed under the License is distributed on an "AS IS" BASIS, > WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or > implied. > See the License for the specific language governing permissions and > limitations under the License. > ==================================================================== */ > > package org.apache.poi.hpsf.examples; > > import java.io.FileInputStream; > import java.io.IOException; > > import java.util.*; > import java.text.*; > > import org.apache.poi.hpsf.PropertySetFactory; > import org.apache.poi.hpsf.SummaryInformation; > import org.apache.poi.poifs.eventfilesystem.POIFSReader; > import org.apache.poi.poifs.eventfilesystem.POIFSReaderEvent; > import org.apache.poi.poifs.eventfilesystem.POIFSReaderListener; > > /** > * <p>Sample application showing how to read a OLE 2 document's > * title. Call it with the document's file name as command line > * parameter.</p> > * > * <p>Explanations can be found in the HPSF HOW-TO.</p> > * > * @author Rainer Klute mailto:[email protected] > <[email protected]> > * @version $Id: ReadTitle.java 489730 2006-12-22 19:18:16Z bayard $ > * @since 2003-02-01 > */ > public class ReadTitle > { > /** > * <p>Runs the example program.</p> > * > * @param args Command-line arguments. The first command-line argument > must > * be the name of a POI filesystem to read. > * @throws IOException if any I/O exception occurs. > */ > public static void main(final String[] args) throws IOException > { > final String filename = args[0]; > POIFSReader r = new POIFSReader(); > r.registerListener(new MyPOIFSReaderListener(), > "\005SummaryInformation"); > r.read(new FileInputStream(filename)); > } > > > static class MyPOIFSReaderListener implements POIFSReaderListener > { > public void processPOIFSReaderEvent(final POIFSReaderEvent event) > { > SummaryInformation si = null; > try > { > si = (SummaryInformation) > PropertySetFactory.create(event.getStream()); > } > catch (Exception ex) > { > throw new RuntimeException > ("Property set stream \"" + > event.getPath() + event.getName() + "\": " + ex); > } > // final String title = si.getTitle(); > // if (title != null) > // System.out.println("Title: \"" + title + "\""); > // else > // System.out.println("Document has no title."); > Date myDate = si.getCreateDateTime(); > SimpleDateFormat sdf = null; > try { > sdf = new SimpleDateFormat("MMddyy"); > } catch (Exception e) { e.printStackTrace(); } > String dateString = sdf.format(myDate); > System.out.println(dateString); > > } > } > > } > > ------------------------- code ends here. > > > -----Original Message----- > From: kavita deshpande [mailto:[email protected]] > Sent: Tuesday, August 04, 2009 11:20 PM > To: [email protected] > Subject: Summary Information bug ?? > > > Hi, > > I want to access the date of creation from summary information object. > > getCreateDateTime() method returns the wrong creation date. > > We are not using POI to create the excel file. THis has been created using > microsoft excel. > We only want to access the file properties and values within. > > We would appreciate any inputs. > Thank You, > Kavita > -- > View this message in context: > http://www.nabble.com/Summary-Information-bug----tp24821345p24821345.html > Sent from the POI - User mailing list archive at Nabble.com. > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [email protected] > For additional commands, e-mail: [email protected] > > > -- View this message in context: http://www.nabble.com/Summary-Information-bug----tp24821345p25091028.html Sent from the POI - User mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
