looking for excel function description list

[TiTou]

Thanks guys for these great answers, they match my needs

[TiTou]

BTW, I made a small VI that turn a number to an Excel column name,

1 > A
2 > B
..
27 > AA
..
53 > BA
..
256 > IV

The code certainly has room for improvment, but at least it works well ; is that the kind of code that can be shared on NI community ??

Message Edité par TiTou le 06-12-2006 08:27 AM

[tst]

It could definitely be shared in the community. Whether people will actually use it is a matter of need and neccessity.

BTW, if you want suggestions before you even post it, I would probably use the Q&R function and divide by 26 to get the letters. Then, I would translate to ASCII by adding 65 and I would use the Byte Array to String Function.

[TiTou]

HI tst, This is more or less what I did 😉

Ok... then before I post it to the community, if you have comments or ideas to improve the code, feel free !

There is the code, I put a range between 1 and 702... don't aske me why... At first I wanted to work for the whole range of I32 but I felt lazy and only made sure it works for an Excel file (xls) where the max number of column is 255 😉

[Joe_H]

Here is an excel toolbox for you.

[TiTou]

Hi Joe,

Thanks a lot for the llb, but could you save it back to LV 7.1 please ? 😉

What do you mean by "Save the words, show the code"  ? Can you not open my diagram ??

[TiTou]

Hooops... sory Joe, I've just notice that this is your signature

It reminds me one of the LabVIEW proverb : "A diagram is worth a thousand lines of code!"