Skip to main content.
home | support | download

Back to List Archive

Re: Extracting titles and correct authors out of Excel docs

From: Bill Moseley <moseley(at)>
Date: Thu Dec 16 2004 - 16:29:15 GMT
On Thu, Dec 16, 2004 at 07:06:04AM -0800, Kissman, Paul (BLC) wrote:
> Because we are spidering with -S prog all our titles in Swish-e look
> like
> Library Chart - /tmp/sG36QWw6iW v.1536
> which I gather is from this line in XLtoHTML
> $ExcelFirstWorksheetName - $ExcelFilename v.$ExcelVersion
> and since the filter is reading a temporary copy of the file, it loses
> the actual path and filename.

You can specify the "real" path when calling $filter->convert() by
specifying the "name" attribute.

> I would really like to get the title out of the document properties; it
> differs quite a bit from the filename.

Isn't $ExcelFirstWorksheetName the name of the worksheet?

> Author appears to be coming for the "Last Saved by" value in the
> spreadsheets document properties (statistics), not the Author in
> Properties | Document Summary. Thes are clearly not going to be the same
> people much of the time.

You will need to contact the author of Spreadsheet::ParseExcel and ask
about that, I think.

Bill Moseley

Unsubscribe from or help with the swish-e list:

Help with Swish-e:
Received on Thu Dec 16 08:29:16 2004