Expand my Community achievements bar.

Learn about Edge Delivery Services in upcoming GEM session

what is the Javascript syntax for EOF in Excel dataconnection?

Avatar

Level 2
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.
2 Replies

Avatar

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.

Avatar

Level 2
Thanks Paul,



isEOF() did work!