Return-Path: Delivered-To: apmail-jakarta-poi-user-archive@www.apache.org Received: (qmail 64887 invoked from network); 4 Nov 2003 17:21:38 -0000 Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12) by minotaur-2.apache.org with SMTP; 4 Nov 2003 17:21:38 -0000 Received: (qmail 10946 invoked by uid 500); 4 Nov 2003 17:21:10 -0000 Delivered-To: apmail-jakarta-poi-user-archive@jakarta.apache.org Received: (qmail 10888 invoked by uid 500); 4 Nov 2003 17:21:10 -0000 Mailing-List: contact poi-user-help@jakarta.apache.org; run by ezmlm Precedence: bulk List-Unsubscribe: List-Subscribe: List-Help: List-Post: List-Id: "POI Users List" Reply-To: "POI Users List" Delivered-To: mailing list poi-user@jakarta.apache.org Received: (qmail 10745 invoked from network); 4 Nov 2003 17:21:09 -0000 Received: from unknown (HELO oceanus2.uk.clara.net) (195.8.69.18) by daedalus.apache.org with SMTP; 4 Nov 2003 17:21:09 -0000 Received: from southill.torchboxapps.com ([217.158.178.102] helo=fluffy.internal.torchbox.com) by oceanus2.uk.clara.net with esmtp (Exim 3.36 #2) id 1AH4rb-000Drq-00 for poi-user@jakarta.apache.org; Tue, 04 Nov 2003 17:21:07 +0000 Received: from grenache.internal.torchbox.com ([192.168.1.81]) by fluffy.internal.torchbox.com with esmtp (TLSv1:EDH-RSA-DES-CBC3-SHA:168) (Exim 4.24) id 1AH4rS-0008N5-2F for poi-user@jakarta.apache.org; Tue, 04 Nov 2003 17:20:58 +0000 Date: Tue, 4 Nov 2003 17:15:21 +0000 (GMT) From: Nick Burch X-X-Sender: nick@localhost.localdomain To: poi-user@jakarta.apache.org Subject: Document properties, HPSF and POIFileSystems Message-ID: MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Spam-Score: -104.5 (---------------------------------------------------) X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N I'm trying to write some code to pull the information out of the SummaryInformation HPSF block in an Excel spreadsheet Since I'm also getting information from the spreadsheet itself via the hssf.usermodel stuff, which accepts a POIFSFileSystem object, I thought I'd do something similar (rather than the eventfilesystem route described in docs/POI/hpsf/how-to.html) Writing the code to go walk through the POI Filesystem was nice and easy, and I've got my DocumentNode corresponding to the \005SummaryInformation block. My problem now is how to get this (or one of it's children) into a HPSF PropertySet My DocumentNode has two children: org.apache.poi.poifs.property.DocumentProperty, which contains a few children: -> Name = "SummaryInformation" -> Property Type = 2 -> Node Color = 1 -> Time 1 = 0 -> Time 2 = 0 Found org.apache.poi.poifs.filesystem.POIFSDocument, which contains a string, which is a nicely formatted representation of the data, looking like 00000000 FE FF 00 00 01 00 00 00 00 00 00 00 00 00 00 00 ................ 00000010 00 00 00 00 00 00 00 00 01 00 00 00 E0 85 9F F2 ................ So, does anyone know which of the above (or their children) I can use to build myself a HPSF PropertySet? Thanks Nick --------------------------------------------------------------------- To unsubscribe, e-mail: poi-user-unsubscribe@jakarta.apache.org For additional commands, e-mail: poi-user-help@jakarta.apache.org