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

Have more questions? Submit a request

0 Comments

Article is closed for comments.