METHODimport_document_from_frontend.*create a xlsx handlerDATA(xlsxhandler) = cl_ehfnd_xlsx=>get_instance( )."创建了句柄*open xlsx into xstringTRY.DATA(xstring_excel) = cl_openxml_helper=>load_local_file( pi_filename ). "获取excel路径 为 xstring格式 CATCHcx_openxml_not_foundINTODATA(...
METHOD import_document_from_frontend. *create a xlsx handler DATA(xlsxhandler) = cl_ehfnd_xlsx=>get_instance( )."创建了句柄 *open xlsx into xstring TRY. DATA(xstring_excel) = cl_openxml_helper=>load_local_file( pi_filename ). "获取excel路径 为 xstring格式 CATCH cx_openxml_not_foun...
2020.02.28 【ABAP随笔】- EXCEL批导程式3 - CL_EHFND_XLSX类 比较好用快速准确,程序员大本营,技术文章内容聚合第一站。
DATA(xlsx_handling) = cl_ehfnd_xlsx=>get_instance( )."xlsx 句柄 DATA(xlsx_document) = xlsx_handling->create_doc( )."xlsx 文件 DATA(xlsx_sheets) = xlsx_document->get_sheets( )."得到sheets DATA(first_xlsx_sheet) = xlsx_document->get_sheet_by_id( xlsx_sheets[ 1 ]-sheet_id )."...
.ENDIF.DATAfilecontentTYPExstring."内容16进制TRY.DATA(xlsx_handling)=cl_ehfnd_xlsx=>get_instance()."xlsx 句柄DATA(xlsx_document)=xlsx_handling->create_doc()."xlsx 文件DATA(xlsx_sheets)=xlsx_document->get_sheets()."得到sheetsDATA(first_xlsx_sheet)=xlsx_document->get_sheet_by_id(xlsx_...
METHODexport_document_to_frontend.IFpt_tabISINITIAL.MESSAGEe001(00) RAISING file_export_errorWITH|Table has no entry.|.ENDIF.DATAfilecontentTYPExstring."内容 16进制TRY.DATA(xlsx_handling) = cl_ehfnd_xlsx=>get_instance( )."xlsx 句柄DATA(xlsx_document) = xlsx_handling->create_doc( )."xlsx...