The Artima Developer Community
Sponsored Link

Python Answers Forum
exporting Excel tables into PostgreSQL database

0 replies on 1 page.

Welcome Guest
  Sign In

Go back to the topic listing  Back to Topic List Click to reply to this topic  Reply to this Topic Click to search messages in this forum  Search Forum Click for a threaded view of the topic  Threaded View   
Previous Topic   Next Topic
Flat View: This topic has 0 replies on 1 page
Jurgen Kemeter

Posts: 1
Nickname: juergenkem
Registered: Dec, 2005

exporting Excel tables into PostgreSQL database Posted: Dec 12, 2005 4:11 PM
Reply to this message Reply
Advertisement
Hi!

Here is a 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.

My ultimate aim is to get ALL data, that means cell values, hyperlink addresses in cells, and comments, into corresponding PostgreSQL database table. Principally there are at maximum three different data per cell (value, hyperlink address, comment).

Here is my idea., which I lack of Python programming practice to implement in a reasonable amount of time, so every help is welcome:
Some kind of For - Loop, which looks into all folders and subfolders. Then opens all workbooks one after another. Then looks into every spreadsheet of a workbook. For every spreadsheet, read out cell values, cell hyperlink addresses (if there are any), and cell comments (if there are any).
(Perhaps the win32com - module is helpful?)

Then open a PostgreSQL database connection, and insert the cell values into a corresponding table.
(which should already be created in the database before?)
This table should also contain a column for the possible hyperlink addresses, and possible cell comment strings.

So, this sounds like fun work... any help appreciated.
Cheers
Juergen

Topic: multiarray module not found Previous Topic   Next Topic Topic: Python Jobs Yahoo Group

Sponsored Links



Google
  Web Artima.com   

Copyright © 1996-2019 Artima, Inc. All Rights Reserved. - Privacy Policy - Terms of Use