php调用python导出excel_java、ruby、python、php等如何生成excel文档?

packagecom.xiaocongjisuan.module.example;importjava.io.BufferedReader;importjava.io.DataOutputStream;importjava.io.IOException;importjava.io.InputStream;importjava.io.InputStreamReader;importjava.io.UnsupportedEncodingException;importjava.net.HttpURLConnection;importjava.net.URL;importjava.net.URLEncoder;importjava.util.HashMap;importjava.util.Map;public classApplication {public static final String DEF_CHATSET = "UTF-8";public static final int DEF_CONN_TIMEOUT = 30000;public static final int DEF_READ_TIMEOUT = 30000;public static String userAgent = "Mozilla/5.0 (Windows NT 6.1) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/29.0.1547.66 Safari/537.36";//配置您申请的appKey和openId

public static final String APP_KEY ="yours";public static final String OPEN_ID ="yours";//将map型转为请求参数型

public static String urlEncode(Mapparams) {if(params==null){return "";};

StringBuilder sb= newStringBuilder();for (Map.Entryi : params.entrySet()) {try{

sb.append(i.getKey()).append("=").append(URLEncoder.encode(i.getValue()+"","UTF-8")).append("&");

}catch(UnsupportedEncodingException e) {

e.printStackTrace();

}

}

String r=sb.toString();if(r.endsWith("&")){

r= r.substring(0,r.length()-1);

}returnr;

}/***

*@paramrequestUrl 请求地址

*@paramparams 请求参数

*@parammethod 请求方法

*@return请求结果

*@throwsException*/

public static String requestContent(String requestUrl, Map params,String method) throwsException {

HttpURLConnection conn= null;

BufferedReader reader= null;

String rs= null;try{//组装请求链接

StringBuffer sb = newStringBuffer();if(method!=null&&method.equalsIgnoreCase("get")){

requestUrl= requestUrl+"?"+urlEncode(params);

}//默认get

URL url = newURL(requestUrl);

conn=(HttpURLConnection) url.openConnection();

conn.setRequestMethod("GET");if(method!=null&&method.equalsIgnoreCase("post")){

conn.setRequestMethod("POST");

conn.setDoOutput(true);

conn.setDoInput(true);

}//参数配置

conn.setRequestProperty("User-agent", userAgent);

conn.setUseCaches(false);

conn.setConnectTimeout(DEF_CONN_TIMEOUT);

conn.setReadTimeout(DEF_READ_TIMEOUT);

conn.setInstanceFollowRedirects(false);

conn.connect();if (params!= null && method.equalsIgnoreCase("post")) {try{

DataOutputStream out= newDataOutputStream(conn.getOutputStream());

out.writeBytes(urlEncode(params));

}catch(Exception e) {

e.printStackTrace();

}

}//读取数据

InputStream is =conn.getInputStream();

reader= new BufferedReader(newInputStreamReader(is, DEF_CHATSET));

String strRead= null;while ((strRead = reader.readLine()) != null) {

sb.append(strRead);

}

rs=sb.toString();

}catch(IOException e) {

e.printStackTrace();

}finally{if (reader != null) {

reader.close();

}if (conn != null) {

conn.disconnect();

}

}returnrs;

}public static void main(String[] args) throwsException{

String domain="http://api.xiaocongjisuan.com/";

String servlet="develop/officeexcelgenerate/get";

String method="get";

String requestUrl=domain+servlet;

Map params=new HashMap();

params.put("appKey",APP_KEY);

params.put("openId",OPEN_ID);//变动部分

params.put("toFormat","xlsx");

params.put("content","{\"sheets\":[{\"header\":[\"姓名\",\"性别\",\"年龄\"],\"rows\":[[\"张三\",\"男\",\"25\"],[\"李四\",\"男\",\"20\"],[\"小红\",\"女\",\"21\"]]},{\"header\":[\"姓名\",\"成绩\"],\"rows\":[[\"张三\",25],[\"李四\",20],[\"小红\",21]]}]}");

String result=requestContent(requestUrl,params,method);

System.out.println(result);

}

}