![]() |
Telelogic DOORS (steve huntington) | ![]() |
new topic :
profile :
search :
help :
dashboard :
calendar :
home
|
||
Latest News:
|
|
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 |
![]() |
![]()
|
![]() |
|
Hello Everyone!
If I know the row number to delete, how do I delete it in the excel file? Thanks & Regards Irfaan |
|
![]() |
|
![]() |
|
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 |
|
![]() |
|
![]() |
|
Hi David,
Thanks for your response. It worked! Regards Irfaan |
|
![]() |
Telelogic DOORS
» DXL Exchange
»
Delete a Row in Excel File
|
![]() |
FuseTalk Standard Edition v3.2 - © 1999-2009 FuseTalk Inc. All rights reserved.