ArrayDisplay with 2-Dimensional Array 1 Column and 1 Row

[souldjer777]

Good Morning All,

I am getting the ugliest results from a _IETableGetCollection _IETableWriteToArray and finally _ArrayDisplay. All the returned data is squished together in a single cell due to the 1 Column and 1 Row result. How can I separate the values of the Array to make things look better and fit in the proper columns? Trying to add pictures to this post so wish me luck Thanks everyone!

Edited October 15, 2012 by souldjer777

[water]

To split the content of a string into pieces a chracter in the string has to be the "separator character".

What's your separator character?

[souldjer777]

_ArrayDisplay($atabledata,"TEST", -1, 0, "", "|", "|Holiday|TZ|Start|Name|Function|Comments|OUTOFFICE|BlackBerry|DeskPhone|Ministry|SiteName|FacilityGroup|SiteAddress|Edit|Date")

I'm just an idiot when it comes to arrays... need

I also used this to add carriage returns but I have no idea how to separate the data into diff columns and rows for ArrayDisplay

;Display $atabledata's contents
Local $output = ""
For $r = 0 To UBound($atabledata, 1) - 1
$output = $output & @CR
For $c = 0 To UBound($atabledata, 2) - 1
$output = $output & $atabledata[$r][$c] & " "
Next
Next

MsgBox(4096, "Array Contents", $output)

Edited October 15, 2012 by souldjer777

[water]

There is a bug in ArrayDisplay when you set the separator character. Best in this case is to only use "_ArrayDisplay($atabledata).

[souldjer777]

Thanks for the info water - I get the same issue though...

_ArrayDisplay($atabledata)

Edited October 15, 2012 by souldjer777

[water]

But why do you get everything in a 1x1 array? Shouldn't _IETableWriteToArray return the correct array?

[souldjer777]

My apologies to water - I didn't mean to waste anyone's time... I really thought it was a formatting issue.

I kept plugging in different table indexes... and finally got one that formatted the data correctly - please excuse me water.

Hey if anyone has my same issue just keep trying different tables indexes

_IETableGetCollection($oIE, 49) ; 1, 2, 3,... 47, 48, 49...

I stopped trying different indexes because I was getting data just wrong format... and I had 50 tables to try...

Brute forced it though and finally got data I could actually read in the correct number of columns and rows.

Is there an easier way to do this other then just guessing the $i_index number???

$oTable=_IETableGetCollection($oIE, 49) ; Change your table number here and keep trying!!! Don't give up!

$atabledata=_IETableWriteToArray($oTable, True)

_IEQuit($oIE)

_ArrayDisplay($atabledata)

Edited October 15, 2012 by souldjer777

[water]

To get data from a sharepoint server there might be a better way. IIRC there is a Sharepoint UDF available on the forum (like one).

We have no sharepoint server here so I can't help with that subject.