Another Excel question with Autoit

[stickwiththescript]

I have over 43,000 rows of cells in (column A) of my excel sheet that are filled with information and used as headings for my blog posts.

The goal is that I want to break all those individual cells into single parts where I can access them individually with my script by assigning a variable to the specific cell that I need to use.

Would it be best to use an array to be able to access all of those cells from the excel sheet?

[JLogan3o13]

@stickwiththescript welcome to the forum. Yes, you can use _Excel_RangeRead to read the column into an array. Something like this:

#include <Array.au3>
#include <Excel.au3>

Local $oExcel = _Excel_Open()
Local $oWorkbook = _Excel_BookOpen($oExcel, @DesktopDir & "\Test.xls") ;Workbook with A1-A43000 filled
Local $aArray = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.Usedrange.Columns("A:A"))
    _ArrayDisplay($aArray)

Depending on how unique the different entries are, you could then use _ArraySearch, like this (I simply numbered the cells 1 to 43,000):

MsgBox(0, "", "Search Item found on row " & _ArraySearch($aArray, 18246))

 

[stickwiththescript]

Excellent! Thankyou. The array display function displays all the rows perfectly. The only problem is that the message box reads out "Search item found on row -1".

[232showtime]

because you dont have 18246 value in Column A:A, type in the value 18246 any where in column A in excel

Edited October 3, 2016 by 232showtime

[JLogan3o13]

Yes, as 232showtime explains, replace 18246 with whatever value you're searching for