Jewtus Posted September 16, 2014 Share Posted September 16, 2014 #include <Excel.au3> #include <Array.au3> $ExcelFile=_ExcelBookOpen(@scriptdir&"\EXCEL EXAMPLE.xls",1) _ExcelSheetActivate($ExcelFile,"Export_6") $Milestones=_ExcelReadSheetToArray($ExcelFile,2,2,0,0) _ArrayDelete($Milestones,0) ; get rid of that pesky excel blank row For $z=0 to UBound($Milestones) -3 If StringInStr($Milestones[$z][6],"OTHER") = 0 Then _ArrayDelete($Milestones,$z) EndIf Next I know there is a simple answer for this, but I'm coming up blank. What I wanted this to do is search the column in the array and if column 6 contaied OTHER delete the row. What I've figured out is that because the row is getting deleted, the whole index shifts up, so when it should delete row 2, if it has already deleted a row, it will actually delete the original row 3 and not row 2. Anyone know how to fix this? Link to comment Share on other sites More sharing options...
Moderators Solution Melba23 Posted September 16, 2014 Moderators Solution Share Posted September 16, 2014 Jewtus,When deleting rows from an array, always work from the bottom up. M23 Jewtus 1 Any of my own code posted anywhere on the forum is available for use by others without any restriction of any kind Open spoiler to see my UDFs: Spoiler ArrayMultiColSort ---- Sort arrays on multiple columnsChooseFileFolder ---- Single and multiple selections from specified path treeview listingDate_Time_Convert -- Easily convert date/time formats, including the language usedExtMsgBox --------- A highly customisable replacement for MsgBoxGUIExtender -------- Extend and retract multiple sections within a GUIGUIFrame ---------- Subdivide GUIs into many adjustable framesGUIListViewEx ------- Insert, delete, move, drag, sort, edit and colour ListView itemsGUITreeViewEx ------ Check/clear parent and child checkboxes in a TreeViewMarquee ----------- Scrolling tickertape GUIsNoFocusLines ------- Remove the dotted focus lines from buttons, sliders, radios and checkboxesNotify ------------- Small notifications on the edge of the displayScrollbars ----------Automatically sized scrollbars with a single commandStringSize ---------- Automatically size controls to fit textToast -------------- Small GUIs which pop out of the notification area Link to comment Share on other sites More sharing options...
Jewtus Posted September 16, 2014 Author Share Posted September 16, 2014 Jewtus, When deleting rows from an array, always work from the bottom up. M23 Thats what I needed! Thanks! $ExcelFile=_ExcelBookOpen(@scriptdir&"\EXCEL EXAMPLE.xls",1) _ExcelSheetActivate($ExcelFile,"Export_6") $Milestones=_ExcelReadSheetToArray($ExcelFile,2,2,0,0) _ArrayDelete($Milestones,0) ; get rid of that pesky excel blank row For $z=UBound($Milestones)-2 to 0 step -1 If StringInStr($Milestones[$z][6],"OTHER") = 0 Then _ArrayDelete($Milestones,$z) EndIf Next Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now