8) LNCTOXLS : SAP

In this example, the database has the following characteristics :

• Type DB: SAP

• SAP server address: 192.168.1.7

• SAP user: DDIC

• SAP user password: aura

• SAP table name: SPFLI

• SQL query: select CITYFROM,CITYTO,DISTANCE,DEPTIME from SBOOK where CITYFROM = 'ROME'

The command LNCTOXLS is used to generate the following Excel file:
C:\temp\sap_test.xlsx

String Destination="C:\\temp\\sap_test.xlsx";

     DataSource myDataSource = new DataSource();
     myDataSource.setType("saptable");
     myDataSource.setUser("DDIC");
     myDataSource.setPassword("aura");
     myDataSource.setAshostSAP("192.168.1.7");
     myDataSource.setClientSAP("001");
     myDataSource.setLangSAP("");
     myDataSource.setSysnrSAP("00");
     myDataSource.setGwhostSAP("192.168.1.7");
     myDataSource.setGwservSAP("3300");
     myDataSource.setQuerySAP("CITYFROM = 'ROME'");
     myDataSource.setRowcountSAP("5");
     myDataSource.setRowskipsSAP("0");
     myDataSource.setFoiSAP("CITYFROM,CITYTO,DISTANCE,DEPTIME");
     myDataSource.setTableNameSAP("SPFLI");

     LNCTOXLS myLNCTOXLS = new LNCTOXLS();
     myLNCTOXLS.setToXls("*new");
     myLNCTOXLS.setAutoFit("true");
     myLNCTOXLS.setFmtCells("false");
     myLNCTOXLS.setAddColH("false");
     myLNCTOXLS.setShowDoc("true");
     myLNCTOXLS.setSourceData(myDataSource);
     myLNCTOXLS.setLNCSrvAddr("192.168.1.9");
     myLNCTOXLS.setSavFmt("*NORMAL");
     myLNCTOXLS.setSavDoc(Destination);

myLNCTOXLS.execute();