Export will export the rows that are currently displayed in the table. The table creates separate pages for large row sets such as the S&P 500. It breaks them into separate pages. The rows of the currently visible page are what is actually written in an export operation. The limits are different for each subscription.
See our help section for more detail.