RE:Explaination

[Chanty4u]

Hi all,

Can any one Explain the below code how it works?

My data has two fileds in excel

LOAD ColorNo,

     ColorCode

FROM

[C\...\....\ColorCodes.xlsx]

(ooxml, embedded labels, table is Sheet1);

Let vNumberOfRows = NoOfRows('ColorCodes');

For vI = 0 to (vNumberOfRows - 1)

Let vVariable_Name = Peek('ColorNo',vI,'Expression');

Let [$(vVariable_Name)] = Peek('ColorCode',vI,'Expression');

Next

DROP Table ColorCodes;

[Chanty4u]

Thnx jagan.