Write Range Horizontal

[Joeri_Rethy (JR)]

Hi Guys,

I’m breaking my head on this… so i’m asking for your help!

I need to write a variable that changes everytime to an excel file. But it has to be horizontal.
Example i need to write from A1 to B1 to C1 … but with big data…
It keeps bugging me that something simple as this takes me this long. Please relieve me from this burden

Kind Regards,
JR

[pavanh003 (Pavan Harisha)]

Hi,
Can you share mote info regarding this.

Regards,
Pavan H

[Maria_Nolan (mn)]

HI, what exactly is your ‘big data’? To keep track of the column letter, simply increment it by Chr(Asc(letter) + 1).ToString. Once you reach Z, you will have to make it so that it allows for AA, AB, etc.
Hope that helps.

[Lahiru.Fernando]

Hi @Joeri_Rethy

I think this post will help you to get what you are looking for…

just don’t break your head. we are hear to help

Incrementing character

Hey @tech_incubator Well if you want to increment char for the Excel Column Mapping need then you can check this existing thread. Get last column of Excel sheet in Alphanumeric form - #7 by aksh1yadav or if you want to stick with the above query then please find the attached Workflow as per your need: Char Input = "A"C; Char next_char = Convert.ToChar(Convert.ToUInt16(Input) +1) // will Give you Next Character i.e. B If you want characters from A to Z then you can use loop till 26 and u…

Let know how it goes bro!!