X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id E7EE39DC871 for ; Tue, 13 Dec 2005 17:45:31 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 32905-07 for ; Tue, 13 Dec 2005 17:45:30 -0400 (AST) X-Greylist: delayed 00:05:03.551682 by SQLgrey- Received: from ns1.cksoft.de (ns1.cksoft.de [62.111.66.1]) by postgresql.org (Postfix) with ESMTP id 1EC3C9DC81E for ; Tue, 13 Dec 2005 17:45:27 -0400 (AST) Received: from vesihiisi.cksoft.de (unknown [192.168.64.10]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (No client certificate requested) by ns1.cksoft.de (Postfix) with ESMTP id 1CA2615C158; Tue, 13 Dec 2005 22:40:22 +0100 (CET) Received: from vesihiisi.cksoft.de (localhost [127.0.0.1]) by vesihiisi.cksoft.de (Postfix) with ESMTP id 3E6A91F6C; Tue, 13 Dec 2005 22:40:21 +0100 (CET) Received: by vesihiisi.cksoft.de (Postfix, from userid 1000) id A40AA1EA2; Tue, 13 Dec 2005 22:40:17 +0100 (CET) Received: from localhost (localhost [127.0.0.1]) by vesihiisi.cksoft.de (Postfix) with ESMTP id 9BD8D1E86; Tue, 13 Dec 2005 22:40:17 +0100 (CET) Date: Tue, 13 Dec 2005 22:40:17 +0100 (CET) From: Christian Kratzer X-X-Sender: ck@vesihiisi.cksoft.de Reply-To: Christian Kratzer To: =?iso-8859-1?Q?J=FCrgen_Kemeter?= Cc: pgsql-sql@postgresql.org Subject: Re: exporting Excel tables into PostgreSQL database with Python In-Reply-To: <000601c5ffd3$c9a80020$6106a8c0@samsungx30> Message-ID: <20051213223654.J56365@vesihiisi.cksoft.de> References: <000601c5ffd3$c9a80020$6106a8c0@samsungx30> X-Spammer-Kill-Ratio: 75% MIME-Version: 1.0 X-Virus-Scanned: by AMaViS cksoft-s20020300-20031204bz on vesihiisi.cksoft.de X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0 required=5 tests=[none] X-Spam-Score: 0 X-Spam-Level: Content-Type: TEXT/PLAIN; charset=iso-8859-1; format=flowed Content-Transfer-Encoding: QUOTED-PRINTABLE X-Archive-Number: 200512/104 X-Sequence-Number: 23646 Hi, On Tue, 13 Dec 2005, J=FCrgen Kemeter wrote: > Hi! > > Here is a hopefully convenient description of my situation: > - I have a main folder, containing several subfolders. > - Every (sub)folder contains one or more .xls - Workbooks. > - Every Workbook contains one or more different Spreadsheets. > - The workbooks contain some cells which have Hyperlink addresses to > other, > relating workbooks. > - Some cells in wokrbooks contain comments, which must also be exported. [snipp] I am not familiar with python but we have done imports and exports from=20 and to excel in perl using the Spreadsheet::ParseExcel and=20 Spreadsheet::WriteExcel modules from CPAN. Greetings Christian --=20 Christian Kratzer ck@cksoft.de CK Software GmbH http://www.cksoft.de/ Phone: +49 7452 889 135 Fax: +49 7452 889 136=