Welcome to Telelogic Product Support
  Home Downloads Knowledgebase Case Tracking Licensing Help Telelogic Passport
Telelogic DOORS (steve huntington)
Decrease font size
Increase font size
Topic Title: Bulk Import of Excel Documents
Topic Summary:
Created On: 24-Sep-2006 14:41
Status: Post and Reply
Linear : Threading : Single : Branch
Search Topic Search Topic
Topic Tools Topic Tools
Quick Reply Quick Reply
Subscribe to this topic Subscribe to this topic
E-mail this topic to someone. E-mail this topic
Bookmark this topic Bookmark this topic
View similar topics View similar topics
View topic in raw text format. Print this topic.
Answer This question was answered by Irfaan Jamal, on Monday, September 25, 2006 9:37 AM

Answer:
Hi Tony, This was exactly what I wanted. Thanks dude... Irfaan
 24-Sep-2006 14:41
User is offline View Users Profile Print this message


Irfaan Jamal

Posts: 8
Joined: 11-Apr-2005

Hello, I am trying to do a bulk excel import. ie, I have some 100 Excel documents in a Windows folder and I am trying to write a script which would pick up these 100 excel documents one by one and import it into DOORS. I already have a script to import a single excel document. Any hints how to browse through the different sheets in the windows share folder? Thanks! Irfaan
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 09:10
User is offline View Users Profile Print this message


Tony Goodman

Posts: 1098
Joined: 12-Sep-2002

The attached code should help you to get started.
Call scanDirectory with the full path name of the windows directory containing the files.
Add the call to your importer to the processFile function.

You may also wish to add checks for the file extension == ".xls" etc.

-------------------------
Tony Goodman
http://www.smartdxl.com
Report this to a Moderator Report this to a Moderator
 25-Sep-2006 09:37
User is offline View Users Profile Print this message


Irfaan Jamal

Posts: 8
Joined: 11-Apr-2005

Answer Answer
Hi Tony, This was exactly what I wanted. Thanks dude... Irfaan
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 2 users logged in.
The most users ever online was 15 on 15-Jan-2009 at 16:36.
There are currently 0 guests browsing this forum, which makes a total of 2 users using this forum.
You have posted 0 messages to this forum. 0 overall.

FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.