Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

what is the Javascript syntax for EOF in Excel dataconnection?

fox9991
Level 2
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
pguerett
Level 10
Level 10
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.