但是到了59000行时,接口变成一个数据都没有读到的原因是在是这个函数底层是用OLE的剪切板来做的, 590000行数据量太大剪切板的内存不够了。
你可以改改里面OLE剪切板复制的代码。
参考下面代码看看:(这段代码是在OLE中每一万条复制一次)
DATA: lv_brow TYPE i VALUE -9998,
lv_erow TYPE i.
WHILE lv_erow < i_end_row.
lv_brow = lv_brow + 9999.
lv_erow = lv_erow + 9999.
IF lv_erow > i_end_row.
lv_erow = i_end_row.
ENDIF.
* mark whole spread sheet
CALL METHOD OF
worksheet
'Cells' = h_cell
EXPORTING
#1 = lv_brow
#2 = i_begin_col.
m_message.
CALL METHOD OF
worksheet
'Cells' = h_cell1
EXPORTING
#1 = lv_erow
#2 = i_end_col.
m_message.
CALL METHOD OF
worksheet
'RANGE' = range
EXPORTING