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

[AEM Gems Webinar] Accelerating Experience Manager as a Cloud Service development with Rapid Development Environments

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

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.