How to copy Excel rows and process data

[omar]

I will copy into Clipboard 100 rows of data with 4 columns from Excel.

I want to process the data 1 row at a time.
How do I process the data? How do I store in an array?

I've done before for reading in files and from the Clipboard.
I'm thinking it will be different reading from Excel - what will the delimeter be?

Thanks.

[omar]

Anyone?

[jmeneses]

Hi Omar,
You can search the forum but this https://github.com/tmplinshi/ExcelToArray it meets

[sinkfaze]

If you copy the range to the Clipboard, you can use two parsing loops: first one by newline, second by tab.

Code: Select all

Loop, Parse, Clipboard, `n, `r
	Loop, Parse, A_LoopField, `t
		MsgBox %	A_LoopField

[FanaticGuru]

I will copy into Clipboard 100 rows of data with 4 columns from Excel.

I want to process the data 1 row at a time.
How do I process the data? How do I store in an array?

I've done before for reading in files and from the Clipboard.
I'm thinking it will be different reading from Excel - what will the delimeter be?

Thanks.

You don't have to use the Clipboard with Excel.

Through COM there are lots of easy ways to access the values in a Range of Cells.

Here is a simple example:

Code: Select all

xlApp := ComObjActive("Excel.Application")

for Cell in xlApp.Range("A1:B2")
	MsgBox % Cell.Value

FG