Excel max rows 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



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




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


Article is closed for comments.