![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
Topic Title: OLE with Excel Topic Summary: Created On: 19-Sep-2006 15:41 Status: Post and Reply |
Linear : Threading : Single : Branch |
![]() |
![]()
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
the attached code snippet will help u in retrieving the cell data once u have a handle to the active sheet....
|
|
![]() |
Telelogic DOORS
» DXL Exchange
»
OLE with Excel
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.