RickB75 Posted October 29, 2013 Share Posted October 29, 2013 Guys, I have a quick question. I have a script thats building different sized arrays for me and I'm writing the data to excel. Heres an example. [0]7 [1]2013 [2]Toyota [3]Camry [4]LE [5]Sedan [6]4 Door The data in position 1,2 and 3 will always be written to the same columns in excel. How can I grab the data in the remaining positions and write it to a particular column. Link to comment Share on other sites More sharing options...
RickB75 Posted October 29, 2013 Author Share Posted October 29, 2013 (edited) lets say I want to grab position 5 and 6, would it be something like this? For $i = 5 to Ubound(myarray) _ExcelWriteCell($oExcel,$marray[$i],$icounter,5) Next Ya know, just looking at this, I can pretty much tell it won't work because I'm still telling it a certain position to write. I guess I need to remove the data from the first part of the array once I've used it and then write the remaining... I think Edited October 29, 2013 by RickB75 Link to comment Share on other sites More sharing options...
RickB75 Posted October 29, 2013 Author Share Posted October 29, 2013 Darn guys, I was just searching on google for an answer to my post here and my post is already indexed in google. Less than an hour later. Pretty impressive!! 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