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: Delete a Row in Excel File
Topic Summary: How do I delete a row in a excel file
Created On: 29-Feb-2008 13:05
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.
 29-Feb-2008 13:05
User is offline View Users Profile Print this message


Irfaan Jamal

Posts: 30
Joined: 13-Feb-2008

Hello Everyone!

If I know the row number to delete, how do I delete it in the excel file?

Thanks & Regards
Irfaan
Report this to a Moderator Report this to a Moderator
 29-Feb-2008 14:53
User is offline View Users Profile Print this message


David Pechacek

Posts: 674
Joined: 5-Dec-2006

Any time you need to know how to do something, just go into Excel, record a macro for what you're doing, then you can work at the DXL from there provided you have an idea of how to drive Excel with OLE.

Anyway, to delete row 17, Excel generates this macro.

Rows("17:17").Select
Selection.Delete Shift:=xlUp

After you've opened your excel file and gotten a handle to the workbook and sheet you can do the following. Note that I didn't test this so a little trial and error might be required.

-------------------------
David Pechacek
AAI Services Textron
dpechacek@sc-aaicorp.com
David.Pechacek@gmail.com
Report this to a Moderator Report this to a Moderator
 4-Mar-2008 04:32
User is offline View Users Profile Print this message


Irfaan Jamal

Posts: 30
Joined: 13-Feb-2008

Hi David,

Thanks for your response. It worked!

Regards
Irfaan
Report this to a Moderator Report this to a Moderator
Statistics
20925 users are registered to the Telelogic DOORS forum.
There are currently 1 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 1 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.