You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@poi.apache.org by kavita deshpande <ka...@gmail.com> on 2009/08/05 08:20:09 UTC
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Summary Information bug ??
Posted by kavita deshpande <ka...@gmail.com>.
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:klute@rainer-klute.de
> <klute@rainer-klute.de>
> * @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:kavitapravindeshpande@gmail.com]
> Sent: Tuesday, August 04, 2009 11:20 PM
> To: user@poi.apache.org
> 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: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
> For additional commands, e-mail: user-help@poi.apache.org
>
>
>
--
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
RE: Summary Information bug ??
Posted by John Byrne <jb...@supportnetwork.org>.
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 <a
* href="mailto:klute@rainer-klute.de"><klute@rainer-klute.de></a>
* @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:kavitapravindeshpande@gmail.com]
Sent: Tuesday, August 04, 2009 11:20 PM
To: user@poi.apache.org
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: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org
---------------------------------------------------------------------
To unsubscribe, e-mail: user-unsubscribe@poi.apache.org
For additional commands, e-mail: user-help@poi.apache.org