echars柱状图，折线图，和导出到Excel

最新推荐文章于 2024-08-13 18:13:57 发布

我有辣条

最新推荐文章于 2024-08-13 18:13:57 发布

阅读量7.9k

点赞数 2

分类专栏： echars+java动态数据文章标签： echars柱状图折线图 echars导出到excel

本文链接：https://blog.csdn.net/qq_24803895/article/details/48706991

版权

echars+java动态数据专栏收录该内容

1 篇文章 0 订阅

订阅专栏

前台的jsp页面

<form action="<%=basePath %>/admin/report/goodOrder.do?deliveryTimes=export" method="post" id="exportForm">
<div id="main" style="height: 400px; border: 1px solid #ccc; padding: 10px;"></div>

</form>

</div>
</body>
</html>

后台---------------------------------------------------------------------------------------------------

基于SpringMVC框架

@RequestMapping("/goodOrder")
public String goodOrder(SaleOrder saleOrder) throws Exception{
String data = request.getParameter("img");

//这里是导出的代码
if("export".equals(saleOrder.getDeliveryTimes())&&(null!= data||""!=data)){
try {
String userName = System.getProperty("user.name");
String filePath = "C:\\Users\\"+userName+"\\Desktop\\chart";
File file = new File(filePath);
if(!file.exists()){
file.mkdir();
}
String fileName = filePath +"\\"+ System.currentTimeMillis()+".png";
createImage( fileName, data);
createExcel(fileName);
return null;
} catch (Exception e) {
e.printStackTrace();
}
}
//这里是生成柱状图的jsp页面
return “页面”;
}
//这里是ajax同步请求获取数据的页面
@RequestMapping("/goodOrderData")
@ResponseBody
public Map<String, Object> goodOrderData(SaleOrder saleOrder) throws Exception{
Map<String, Object> map = new HashMap<String, Object>();
//纵坐标值
Integer [] values = new Integer[]{12,33,4,56,5};
//横坐标值
String [] aa= new String[]{"2015-01","2015-02","2015-03","2015-04","2015-05"};

map.put("categories", aa);
map.put("values", values);
return map;
}

public void createImage(String fileName, String data) throws ServletException,IOException {
try {
String[] url = data.split(",");
String u = url[1];
// Base64解码
byte[] b = new BASE64Decoder().decodeBuffer(u);
// 生成图片
OutputStream out = new FileOutputStream(new File(fileName));
out.write(b);
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 图片写入Excel中
* @param fileName
* @throws ServletException
* @throws IOException
*/
public void createExcel(String fileName) throws ServletException ,IOException {

HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("echart");
HSSFRow rows = sheet.createRow(0);
HSSFCell cells = rows.createCell(40);
// 另一个样式
// 设置字体
HSSFFont headfont = wb.createFont();
headfont.setFontName("新宋体");
headfont.setFontHeightInPoints((short) 18);// 字体大小
headfont.setBoldweight(HSSFFont.BOLDWEIGHT_BOLD);// 加粗
HSSFCellStyle headstyle = wb.createCellStyle();
headstyle.setFont(headfont);
headstyle.setAlignment(HSSFCellStyle.ALIGN_CENTER);// 左右居中
headstyle.setVerticalAlignment(HSSFCellStyle.VERTICAL_CENTER);// 上下居中
headstyle.setLocked(true);
headstyle.setWrapText(true);// 自动换行
HSSFRow row0 = sheet.createRow(0);
// 设置行高
row0.setHeight((short) 900);
// 创建第一列
HSSFCell cell0 = row0.createCell(0);
String header = "关于统计报表";
cell0.setCellValue(new HSSFRichTextString(header));
cell0.setCellStyle(headstyle);
//合并
CellRangeAddress range = new CellRangeAddress(0, 0, 0, 14);
sheet.addMergedRegion(range);
//
cells.setCellType(HSSFCell.CELL_TYPE_BLANK);

ByteArrayOutputStream outStream = new ByteArrayOutputStream(); // 将图片写入流中
BufferedImage bufferImg = ImageIO.read(new File(fileName));
ImageIO.write(bufferImg, "PNG", outStream); // 利用HSSFPatriarch将图片写入EXCEL
HSSFPatriarch patri = sheet.createDrawingPatriarch();
HSSFClientAnchor anchor = new HSSFClientAnchor(20, 20, 20,20,
(short) 0, 1, (short) 15, 20);
patri.createPicture(anchor, wb.addPicture(
outStream.toByteArray(), HSSFWorkbook.PICTURE_TYPE_PNG));

long name = System.currentTimeMillis();
SimpleDateFormat df = new SimpleDateFormat("yyyyMMddHHmmss");
String currentDate = df.format(new Date());
String pngName =currentDate+name+".xls";
try {
OutputStream out = null;
response.reset();
response.setContentType("application/x-msdownload");
response.setHeader("Content-Disposition", "attachment; filename=" + URLEncoder.encode(pngName, "UTF-8"));
out = response.getOutputStream();
wb.write(out);
out.flush();
out.close();
} catch (Exception e) {
e.printStackTrace();
}
}