1、 'TEXT_CONVERT_XLS_TO_SAP'单元格文本不能超过256个字符
CALL FUNCTION 'TEXT_CONVERT_XLS_TO_SAP'
EXPORTING
i_line_header = 'X'
i_tab_raw_data = lt_raw
i_filename = p_file
TABLES
i_tab_converted_data = it_data
EXCEPTIONS
conversion_failed = 1
OTHERS = 2
.
TEXT_CONVERT_CSV_TO_SAP "CVS
TEXT_CONVERT_TEX_TO_SAP "tex
TEXT_CONVERT_TXT_TO_SAP "txt
TEXT_CONVERT_XLS_TO_SAP "xls
TEXT_CONVERT_XML_TO_SAP "xml
2、'ALSM_EXCEL_TO_INTERNAL_TABLE'单元格文本不能超过50个字符
data: gt_upload type alsmex_tabline occurs 0 with header line.
call function 'ALSM_EXCEL_TO_INTERNAL_TABLE'
exporting
filename = p_file
i_begin_col = '1'
i_begin_row = '1'
i_end_col = '9'
i_end_row = '50000'
tables
intern = gt_upload.
3修改ALSM_EXCEL_TO_INTERNAL_TABLE的限制(http://blogold.chinaunix.net/u1/40527/showart_1970184.html)
M:ALSM_EXCEL_TO_INTERNAL_TABLE 是上载Excel文件的一个函数,但是这个函数有两个限制。
一是每个CELL只能导入前50个字符,二是如果超过9999行,行号会初始化为从零开始
其实解决起来很简单,只要改一下结构 ALSMEX_TABLINE 的字段就行了,然后COPY ALSM_EXCEL_TO_INTERNAL_TABLE 为 ZALSM_EXCEL_TO_INTERNAL_TABLE ,并做少许改动即可。
另外,如果要上载有打开密码保护的Excel,只要修改一下OLE的 OPEN 语句即可。
以及导入指定的Sheet等。。
注意COPY出来的函数的 Global Data 里面应该有下列语句:
TYPE-POOLS: ole2.
TYPES: ty_d_itabvalue TYPE zalsmex_tabline-value,
ty_t_itab TYPE zalsmex_tabline OCCURS 0,
BEGIN OF ty_s_senderline,
line(4096) TYPE c,
END OF ty_s_senderline,
ty_t_sender TYPE ty_s_senderline OCCURS 0.
CONSTANTS: gc_esc VALUE '"'.
- 大小: 31.2 KB
- 大小: 35.5 KB
分享到:
相关推荐
HCS-Solution
IBM BI solution ppt2IBM BI solution ppt2IBM BI solution ppt2
solution to Csolution to CLR(算法导论习题全部答案) 挺全的LR(算法导solution to CLR(算法导论习题全部答案) 挺全的论习题solution to CLR(算法导论习题全部答案) 挺全的全部solution to CLR(算法导论习题全部答案...
Filter Solution v12 patcher
打印机驱动 LJPro_MFP_M125-126_full_solution_15309打印机驱动 LJPro_MFP_M125-126_full_solution_15309打印机驱动 LJPro_MFP_M125-126_full_solution_15309打印机驱动 LJPro_MFP_M125-126_full_solution_15309...
pc connectivity solution下载,解决你在安装或使用诺基亚PC套件时出现的得安装pc connectivity solution7.0以上的问题。本产品绝对无毒,放毒者断子绝孙。(注意:下载本资源后要解压压缩里面的全部压缩文件再打开...
Solution源码
SolutionManager
从官方网站下载的Ashtech Solution 2.7 安装光盘中的压缩文件Data1.cab 解压缩后的全部文件,其中包含Ashtech Solution 2.7安装后的全部文档。官方的Ashtech Solution 2.7 安装时会出现_setup.dll文件错误,无法安装...
We derive an analytical expression of the best approximate solution in the leastsquares solution set SE of the matrix equation AXB + CY D = E to a given matrix pair (Xf, Yf ), where A, B, C, D, and E ...
权限管理solution
solution manager 的文档PDF文件
SRM SAP Markets Solution presentation
data and computer solution
Microelectronic Circuits Sedra Smith 5th Edition - Solution Manual
SAP solution manager 4.0 配置手册
Munkres Topology Solution 拓扑相关的内容很重要
database system concepts solution
SAP Solution Manager 7.0 SAP Solution Manager 7.0 种子
pre-engineered, high-density configuration solution for systems with multiple FPGAs. System ACE technology is a ground-breaking in-system programmable configuration solution that provides substantial ...