How to access column AAA and further using ExcelRowColToRange.vi

[panka]

Hi

I have a huge data that I need to write on excel in the first row so I require to access columns AAA, AAB....

But using ExcelRowColToRange.vi i am able to go upto column ZZ. Can anyone please suggest a way to modify this VI in order to fulfil my requirement.

Thanks

[GerdW]

Hi panka,

right now the logic is only made for 2 chars as COLUMN indicator. You have to change that logic into providing upto 3 chars...

IF column < 27 THEN
  format only one char
ELSE IF column < 702 THEN
  format just two chars
ELSE IF column < 26*26*26+26*26+26 THEN
  format three chars
ELSE
  format four chars
ENDIF

 The first two cases already exit, you only need to add the 3rd one by now!

[panka]

Hi, 

thanks a lot for replying GerdW

I understand that the logic is limited for 2 characters and i tried a lot to modify it for 3 characters and was able to go until AAZ but not beyond.

Can u please provide me a solution of doing this.

Thanks Again

[GerdW]

Hi panka,

show what you have done so far and we will point out your errors. That's how the forum works!

Btw. nothing comes for free and you will learn LabVIEW better by actually "programming" instead of "using"...

[panka]

Here is the VI to which i did modification.

I will be very thankful if you can point out my mistakes.

[GerdW]

Sorry, can't open. See my signature...

[panka]

Sorry for the attachment.

Can you please check this one.

[GerdW · Accepted solution]

Hi panka,

try that one...