JAVA下载SAP的Excel文件

1.SAP端准备好函数：ZEXCELTEST

1.1 若启用RESTFUL的方式，则不用勾选“远程启用模块”，若JAVA通过JCO包调用则需要启用。（restful方式暂时未更新）

函数为测试信息，仅有返回文件的二进制信息，无其他返回参数

 

 SAP端ABAP代码如下：

FUNCTION zexceltest.
*"----------------------------------------------------------------------
*"*"本地接口：
*"  EXPORTING
*"     VALUE(OV_STR) TYPE  XSTRING
*"----------------------------------------------------------------------
  SELECT * INTO TABLE @DATA(lt_bp) FROM but000 UP TO 100 ROWS.
  DATA:lw_tab_ref TYPE REF TO data.
  CREATE DATA lw_tab_ref LIKE LINE OF lt_bp.

  DATA:ls_mime    TYPE w3mime,
       lt_mime    TYPE TABLE OF w3mime,
       filesize   TYPE string,
       filesizei  TYPE i,
       lv_xstring TYPE xstring,
       fileext    TYPE char20,
       ls_key     TYPE wwwdatatab.

  ls_key-relid = 'MI'.
  ls_key-objid = 'XXXXXX'.
  SELECT * FROM wwwparams INTO TABLE @DATA(lt_wwwparam)
        WHERE relid = @ls_key-relid
        AND objid = @ls_key-objid.
  TRY.
      LOOP AT lt_wwwparam INTO DATA(ls_wwwparam).
        CASE ls_wwwparam-name.
          WHEN 'filesize'.
            filesizei = filesize = ls_wwwparam-value.
            CONDENSE filesize NO-GAPS.
          WHEN 'fileextension'.
            fileext = ls_wwwparam-value.
        ENDCASE.
      ENDLOOP.
**********************************************************************
* 获取SMW0的数据
      CALL FUNCTION 'WWWDATA_IMPORT'
        EXPORTING
          key               = ls_key
        TABLES
          mime              = lt_mime
        EXCEPTIONS
          wrong_object_type = 1
          import_error      = 2
          OTHERS            = 99.

      CALL FUNCTION 'SCMS_BINARY_TO_XSTRING'
        EXPORTING
          input_length = filesizei
        IMPORTING
          buffer       = lv_xstring
        TABLES
          binary_tab   = lt_mime
        EXCEPTIONS
          failed       = 1
          OTHERS       = 2.
**********************************************************************
      DATA(xlsx_handling) = cl_ehfnd_xlsx=>get_instance( )."xlsx 句柄
      DATA(xlsx_document) = xlsx_handling->load_doc( lv_xstring )."xlsx 文件
      DATA(xlsx_sheets) = xlsx_document->get_sheets( )."得到sheets
      DATA(first_xlsx_sheet) = xlsx_document->get_sheet_by_id( xlsx_sheets[ 1 ]-sheet_id )."得到sheet
      first_xlsx_sheet->change_sheet_name( 'Sheet_first' )."设置sheet的名称
      DO 2 TIMES.
        DATA(lv_row) = sy-index + 3."从第三行起，开始写数据
        DO 10 TIMES.
          DATA(lv_column) = sy-index.
          IF first_xlsx_sheet->has_cell_content( iv_row = lv_row iv_column = lv_column ).
          ELSE.
            first_xlsx_sheet->set_cell_content( iv_row = lv_row iv_column = lv_column iv_value = '测试数据!' ).
          ENDIF.

        ENDDO.
      ENDDO.

      ov_str = xlsx_document->save( ).
    CATCH cx_openxml_format  INTO DATA(openxml_format_exception).
      MESSAGE e001(00) RAISING file_export_error
      WITH 'Error occurs when constructing excel file instance.'." cx_openxml_format.
    CATCH cx_openxml_not_found INTO DATA(openxml_not_found_exception).
      MESSAGE e001(00) RAISING file_export_error
      WITH ' Error occurs when constructing excel file instance.' "CX_OPENXML_NOT_FOUND |.
      .
    CATCH cx_openxml_not_allowed INTO DATA(openxml_not_allowed_exception).
      MESSAGE e001(00) RAISING file_export_error
      WITH 'Error occurs when constructing excel file instance.'" CX_OPENXML_NOT_ALLOWED |.
      .
  ENDTRY.

ENDFUNCTION.

JAVA端通过JCO包代码如下：

import java.io.BufferedInputStream;
import java.io.BufferedOutputStream;
import java.io.ByteArrayInputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;

import com.sap.conn.jco.JCoDestination;
import com.sap.conn.jco.JCoFunction;
import com.sap.conn.jco.JCoParameterList;

public class FM_ZEXCELTEST {
    public static void main(String[] args) {
        BufferedInputStream bis = null;
        FileOutputStream fos = null;
        BufferedOutputStream output = null;
        String filePath = "C:\\Users\\XXXX\\Desktop\\Test\\测试文件.xlsx";
        try {
            JCoFunction function = null;
            JCoDestination destination = SAPConn.connect("S4D360");
            function = destination.getRepository().getFunction("ZEXCELTEST");
            function.execute(destination);
            JCoParameterList list = function.getExportParameterList();
            byte[] contents = (byte[])list.getValue("OV_STR");

            ByteArrayInputStream byteInputStream = new ByteArrayInputStream(contents);
            bis = new BufferedInputStream(byteInputStream);
            File file = new File(filePath);
            File path = file.getParentFile();
            if (!path.exists()) {
                boolean isCreated = path.mkdirs();
                if (!isCreated) {}
            }
            fos = new FileOutputStream(file);
            output = new BufferedOutputStream(fos);
            byte[] buffer = new byte[1024];
            int length = bis.read(buffer);
            while (length != -1) {
                output.write(buffer, 0, length);
                length = bis.read(buffer);
            }
            output.flush();
            System.out.println("文件下载完毕:"+filePath);
        } catch (Exception e) {

        } finally {
            try {
                bis.close();
                fos.close();
                output.close();
            } catch (IOException e) {
                System.out.println("异常" + e.toString());
            }
        }
    }
}