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
BedrockMission!

Learn More

View all

Sign in to view all badges

what is the Javascript syntax for EOF in Excel dataconnection?

Avatar

Avatar
Level 1
fox9991
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
fox9991
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile
fox9991
Level 1

09-03-2009

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.

Replies

Avatar

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile

Avatar
Boost 500
Level 10
pguerett
Level 10

Likes

612 likes

Total Posts

7,689 posts

Correct Reply

692 solutions
Top badges earned
Boost 500
Boost 50
Boost 5
Boost 3
Boost 250
View profile
pguerett
Level 10

10-03-2009

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

Avatar
Level 1
fox9991
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile

Avatar
Level 1
fox9991
Level 1

Likes

0 likes

Total Posts

6 posts

Correct Reply

0 solutions
View profile
fox9991
Level 1

11-03-2009

Thanks Paul,



isEOF() did work!