Jump to content

Scribe Excel "Next Column"


This topic is 2632 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

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

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.

 

 

Screen Shot 2017-01-13 at 2.33.15 PM.png

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.