Newbies Seth Redlus Posted January 12, 2017 Newbies Share Posted January 12, 2017 Hello- I'm new to scribe, and I'm trying to build a looping script that will systematically go through all the data in a given spreadsheet. The challenge I have is that though it's easy for me to build a script to advance rows: Set Variable $currentrow = 1 Set Variable $currentrow + 1 Columns however are different. How can I tell it to advance to the next column since I can't do it via a mathematic equation? I only ask because the spreadsheets I'm trying to import have between 100-110 columns, so I don't want to have to hand-build the logic to "go to the next column" since I have to be able to get to column "CI" in this book. Thanks! Link to comment Share on other sites More sharing options...
ryan360Works Posted January 13, 2017 Share Posted January 13, 2017 Hi Seth, I have accomplished this in that past by using the "char" calculation. So char(65) =A and char(90)=Z. To increment columns you would need two variables, one to hold the numeric value and another to append to your row variable. I have attached a screen shot of a script that creates an excel sheet with 10000 rows and columns from A-Z. You would need to modify this a bit to work for you but the concept is the same. With that being said, this gets a little tricky when you start to get into the AA,AB,AC columns and so on. One of my colleague's uses this custom function to make that a non issue. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 2632 days old. Please don't post here. Open a new topic instead.
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