This article explains the cause of the problem and offers troubleshooting advice.
You may get the following error when writing records into an Excel file with a tFileOutputExcel component:
Exception in component tFileOutputExcel_1 The maximum number of rows permitted on a worksheet been exceeded
You are trying to insert data into Excel 2003, but the total amount of data is greater than 65536. Excel versions up to 11.0 (Office Excel 2003) had a limitation on the size of each sheet of 64K (216= 65536) rows. For more details, please see this wikipedia article. This is an Excel limitation.
To work around the problem, use one of these solutions: