How can I get the last column letter in Excel?

Help
, , , ,
1

Hi guys,

I’m having a problem. How can I get the last column letter in Excel?

I used a package that gets the last column but the output was Integer.

How can I convert that into Column Letter? Any ideas?

Thanks for the help.

2

So you want to get the last column name of excel? @Shaira_Janine_Torio

3

Yes, the column letter

4

@Shaira_Janine_Torio

One way of doing this is declare a array Variable like below

image

This one method, but you need to manually write all the Columns name

If you are ok with Custom Activity, Then check below

Mark as solution if this helps

Thanks

3 Likes
5

Can I get an example using that package? I’m trying right now but I’m getting some error.

6

@Shaira_Janine_Torio

Can you share me what error?

Thanks

7

I already got it. Thanks!!

1 Like
8

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.