what is the Javascript syntax for EOF in Excel dataconnection?

[fox9991]

I know how to access each row in Excel dataconnection by :



xfa.sourceSet.dataConnectionName.first();

xfa.sourceSet.dataConnectionName.last();

xfa.sourceSet.dataConnectionName.previous();

xfa.sourceSet.dataConnectionName.next();



Now I have to write a loop to process from first row upto last row in the worksheet.

How can I check for EOF condition, is there something like :

xfa.sourceSet.dataConnectionName.eof() ?



Thanks in advance.

[Former Community Member]

AWS Excel is not a real database I am not sure that an EOF marker exists. You will have to try it and see. The method you want is:



isEOF()



This returns a boolean value of true if this is the last record in the record set.

[fox9991]

Thanks Paul,



isEOF() did work!