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: OLE with Excel
Topic Summary:
Created On: 19-Sep-2006 15: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.
 19-Sep-2006 15:41
User is offline View Users Profile Print this message


Mussie Woldemicael

Posts: 95
Joined: 12-Sep-2006

Hello,
does anybody know how to get a string out of a Excel cell in order to compare it with an ordinary dxl string?

Best regards

Mussie

Report this to a Moderator Report this to a Moderator
 19-Sep-2006 20:50
User is offline View Users Profile Print this message


Louie Landale

Posts: 2070
Joined: 12-Sep-2002

Are you asking how to open a file *.xls and extract a specific cell's contents? Good luck with that; *.xls format doesn't look easy to understand for me.

Are you asking that given an open Excel file with which your DXL program has an OLE connection, you want a specific cell's value? Don't know, but I'm sure that's realistic and other's may know.

- Louie
Report this to a Moderator Report this to a Moderator
 20-Sep-2006 07:08
User is offline View Users Profile Print this message


Subrojyoti Sengupta

Posts: 52
Joined: 18-Nov-2005

Hello Muusie,
You can have a look at the script which DOORS uses for exporting in excel format. It'll give u some idea on how to handle excel sheet cells.

You'll find script at  \Telelogic\DOORS 7\lib\dxl\standard\export\office\excel.dxl in the drive where DOORS is installed.

Check out the function setCell().
You can probably write a function getCell() to retrieve the necessary string.
Hope this helps...

Regards,
Abhishek Biswas 
Report this to a Moderator Report this to a Moderator
 20-Sep-2006 09:43
User is offline View Users Profile Print this message


Subrojyoti Sengupta

Posts: 52
Joined: 18-Nov-2005

the attached code snippet will help u in retrieving the cell data once u have a handle to the active sheet....
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.