Jump to content

Trying to loop through every row in a Excel sheet

TheDcoder
 Share

Recommended Posts

iamtheky Universalist

iamtheky

Posted
Posted (edited)

Yeah mine totally shits the bed on your A2 line.

May need to call in @water for this answer, but what exactly does the "visible text" (3) option in rangeread return? It is always blank for me.

But it seems if you could simply hide the rows, then rangeread the visible text, you would reach the desired result as well...

Edited by iamtheky 

,-. .--. ________ .-. .-. ,---. ,-. .-. .-. .-.
|(| / /\ \ |\ /| |__ __||| | | || .-' | |/ / \ \_/ )/
(_) / /__\ \ |(\ / | )| | | `-' | | `-. | | / __ \ (_)
| | | __ | (_)\/ | (_) | | .-. | | .-' | | \ |__| ) (
| | | | |)| | \ / | | | | | |)| | `--. | |) \ | |
`-' |_| (_) | |\/| | `-' /( (_)/( __.' |((_)-' /(_|
'-' '-' (__) (__) (_) (__)

Subz Universalist

Subz

Posted
Posted

As per the help $iReturn = 3 can only return a single cell.  I tried the following first which filters the sheet correctly but only returns the information up until the first blank row. 

$oWorkbook.ActiveSheet.UsedRange.AutoFilter(1, "<>")
Global $aSpreadsheet = _Excel_RangeRead($oWorkbook, Default, $oWorkbook.ActiveSheet.UsedRange.SpecialCells($xlCellTypeVisible))

 

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share
Go to topic listing
×
×
  • Create New...