Excel max rows error

Error:

We received this error  for a map that transforms a comma-separated file into an Excel spreadsheet:

Unable to write into Row. The maximum number of rows permitted on a worksheet been exceeded

Cause:

When using the xls type of excel file, the number of rows is limited to  65,536

Solution:

1) Define the file target extension to be xlsx type, which was a row limit of 1048576

2) Please change the file type that is set in the schema to "Excel workbook(*.xlsx)" type from "Excel workbook(*.xls)" type as you are trying to process xlsx file