query生成的report中的数据超过65535条时, 在用CA进行transfer时会报错.
Error Message:
The data will not fit in the worksheet.
You may want to choose a different starting position.
原因:
The iSeries Access for Windows Data Transfer Excel Add-In will transfer only 64K rows. This is because of a limit on the number of rows allowed in a worksheet by the BIFF file format. Any attempt to transfer more than 64K rows using the Add-In will result in the following message:
The data will not fit in the worksheet.
You may want to choose a different starting position.
Note: This limitation has been removed in V6R1 System i Access and V5R4 iSeries Access service pack SI31388. Also, the V5R4 Excel data transfer add-in does not support more then 65,536 rows when using Excel 2010. This is because the V5R4 iSeries Access code is written to only determine whether Excel 2007 is being used so that it will increase the number of records to 1,048,576 rows. The V5R4 code is not written to determine whether Excel 2010 is being used. The V5R4 code will not be enhanced because no additional service packs are planned for V5R4.
A way to work around this limitation is to transfer the file using the iSeries Access for Windows Data Transfer outside of Microsoft Excel using BIFF8 file format with the default option to Create extra sheets when first sheet overflows. The resulting file can then be opened with Excel. Excel will put the first 64K rows in the first worksheet and the second 64K rows in the second worksheet, and so on.
Service pack SI26879 for V5R4 iSeries Access for Windows adds support for the data transfer add-in within Excel 2007. While Excel 2007 does support more than 65535 rows of data in a spreadsheet, before V5R4 service pack SI31388 data transfer still imposed a limitation that limits the number of rows transferred by the add-in to 65535 rows.
参考Link:
阅读(2078) | 评论(0) | 转发(0) |
