Jump to content
Seth Redlus

Scribe Excel "Next Column"

Recommended Posts

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!

Share this post


Link to post
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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


×
×
  • Create New...

Important Information

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