使用到的工具有：
開發(fā)工具：IDEA
報表開發(fā)工具：帆軟10.0.19
1、針對帆軟報表[普通報表]的設置
1.1首先選中在帆軟里制作好的報表，選擇模板web屬性
1.2.選擇數(shù)據(jù)分析模式，添加一個事件設置，該事件應該設置“加載結(jié)束”
1.3.在Js腳本里寫這段代碼：
var node = document.getElementsByClassName('x-table')[0].parentElement;
var message = {
nodeId: '自定義一個別名',
nodeInnerHTML: node.innerHTML
};
window.parent.postMessage(message, '*');
–繪制表格及如何將帆軟報表展示到html不做過多贅述
給生成PPT方法添加一個按鈕事件：
$("#DOWNLOAD").on("click", function () {
//給每個表格設置一個新的ID
updateTableId();
var timeBucket = $("#inqu_status-0-timeBucket").val();
let orderYear = timeBucket.substring(0, 4)
let orderMonth = timeBucket.substring(4, 6)
let orderYearC = orderYear + '年'
let orderMonthC = orderMonth + '月'
var inInfo = new EiInfo();
var promises = []; // 存儲生成圖片的 Promise
//確保每個table都生成了BASE64編碼
document.querySelectorAll(".html2canvas table").forEach((v, k, p) => {
var promise = html2canvas(document.querySelector('#' + v.id), {}).then((canvas) => {
//根據(jù)當前id獲取tr的數(shù)量。1tr假設等于11PX 從而計算出數(shù)據(jù)表格的高度
let tableHeight = v.querySelectorAll("tr").length * 11;
let src = canvas.toDataURL("image/png").replace("image/png", "image/octet-stream"); // 將canvas轉(zhuǎn)換成img的src流
console.log(v.id, k)
inInfo.set(v.id, src)
inInfo.set(v.id + 'Height', tableHeight.toString())
});
promises.push(promise);
})
//所有報表的base64編碼都在promises里后，調(diào)用后臺服務
Promise.all(promises).then(() => {
inInfo.set("{{Year}}", `${orderYear}`)
inInfo.set("{{Month}}", `${orderMonth}`)
inInfo.set("{{YearC}}", `${orderYearC}`)
inInfo.set("{{MonthC}}", `${orderMonthC}`)
inInfo.set("{{YearMonth}}", `${orderYear}${orderMonth}`)
inInfo.set("{{YearMonthC}}", `${orderYearC}${orderMonthC}`)
var jsonEi = inInfo.toJSONString(true);
console.log(jsonEi)
post(IPLATUI.CONTEXT_PATH + "/DownloadAgree", {"temporaryId": "PM15", "jsonEi": jsonEi});
// IPLAT.progress($("#result"), false);
});
IPLAT.progress($("#result"), false);
})
function updateTableId() {
var tables = document.querySelectorAll("table[class^='x-table']");
for (var i = 0; i < tables.length; i++) {
tables[i].setAttribute("id", "newTableId" + i);
num = i;
}
}
調(diào)用后臺：DownloadAgree，通過該服務，去調(diào)用具體實現(xiàn)方法
package com.baosight.bgdsp.rp.pm;
import com.baosight.iplat4j.core.ei.EiConstant;
import com.baosight.iplat4j.core.ei.EiInfo;
import com.baosight.iplat4j.core.service.soa.XLocalManager;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;
public class DownloadAgree extends HttpServlet{
@Override
protected void doGet(HttpServletRequest request, HttpServletResponse response) {
EiInfo eiInfo = EiInfo.parseJSONString(request.getParameter("jsonEi"));
String temporaryId = request.getParameter("temporaryId");
if (temporaryId.equals("PM")) {
eiInfo.set("response", response);
eiInfo.set(EiConstant.serviceName, "R07");
eiInfo.set(EiConstant.methodName, "exportPPT");
eiInfo = XLocalManager.callNewTx(eiInfo);
}if (temporaryId.equals("PM15")) {
eiInfo.set("response", response);
eiInfo.set(EiConstant.serviceName, "R15");
eiInfo.set(EiConstant.methodName, "exportPPT");
eiInfo = XLocalManager.callNewTx(eiInfo);
}
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException{
doGet(request, response);
}
}
exportPPT方法：
public EiInfo exportPPT(EiInfo inInfo) throws IOException {
HttpServletResponse response = (HttpServletResponse) inInfo.get("response");
// 創(chuàng)建一個空的演示文稿
String url = "";
String os = System.getProperty("os.name").toLowerCase();
boolean isMacOS = os.contains("mac");
if (isMacOS) {
url = PlatApplicationContext.getProperty("項目名." + projectEnv + ".share.template.mac");
} else {
url = PlatApplicationContext.getProperty("項目名." + projectEnv + ".share.template");
}
String tempName = PlatApplicationContext.getProperty("項目名." + projectEnv + ".share.template.rppm15");
// 讀取模板文件
//InputStream resource = new ClassPathResource("/Users/apple/Desktop/-job/2022-development/iplat4j/渠道長齡庫存壓降情況匯報_template.pptx").getInputStream();
FileInputStream inputStream = new FileInputStream(url + tempName);
// FileInputStream inputStream = new FileInputStream("E://" + tempName);
// 根據(jù)模板，創(chuàng)建一個新的ppt文檔
XMLSlideShow ppt = new XMLSlideShow(inputStream);
// 讀取模板PPT
inputStream.close();
Map<String, String> attr = inInfo.getAttr();
attr.put("netPrice_2", getReportsToimage());
// List<XSLFSlide> slides = ppt.getSlides();
// 得到每頁ppt
XSLFSlide[] slides = ppt.getSlides().toArray(new XSLFSlide[0]);
// 遍歷ppt，填充模板
for (XSLFSlide slide : slides) {
// List<XSLFShape> shapes = slide.getShapes();
XSLFShape[] shapes = slide.getShapes().toArray(new XSLFShape[0]);
// 遍歷每頁ppt中待填充的形狀組件
for (XSLFShape shape : shapes) {
if (shape instanceof XSLFTextShape) {
// 替換文本
XSLFTextShape textShape = (XSLFTextShape) shape;
String textValue = textShape.getText();
String shapeName = textShape.getShapeName();
boolean flag = false;
for (String text : extractContent(textValue)) {
if (attr.containsKey(text)) {
flag = true;
//使用mustache語法替換文字 {{YearC}}營{{MonthC}}銷預案會
textValue = textValue.replace(text, attr.get(text));
}
}
if (flag && StringUtils.isNotBlank(textValue)) {
List<XSLFTextParagraph> paragraphs = textShape.getTextParagraphs();
for (XSLFTextParagraph paragraph : paragraphs) {
List<XSLFTextRun> textRuns = paragraph.getTextRuns();
for (XSLFTextRun textRun : textRuns) {
textRun.setText("");
}
}
XSLFTextRun textRun2 = textShape.getTextParagraphs().get(0).getTextRuns().get(0);
textRun2.setText(textValue);
}
} else if (shape instanceof XSLFPictureShape) {
XSLFPictureShape pictureShape = (XSLFPictureShape) shape;
XSLFPictureData pictureData = pictureShape.getPictureData();
String imageName = pictureShape.getShapeName();
String imageBase64 = attr.get(imageName);
if (imageBase64 != null) {
byte[] bt = Base64.getDecoder().decode(imageBase64.split(",")[1]);
XSLFPictureData idx = ppt.addPicture(bt, PictureData.PictureType.PNG);
XSLFPictureShape pic = slide.createPicture(idx);
Rectangle2D anchor = pictureShape.getAnchor();
//高度取決于數(shù)據(jù)表格的條數(shù) 寬度固定
pic.setAnchor(new Rectangle2D.Double(anchor.getX(), anchor.getY(), anchor.getWidth(), anchor.getHeight()));
pictureShape.setAnchor(new Rectangle2D.Double(10, 0, 0, 0));
}
}
}
}
String fileName = "PPT名字" + DateUtils.curDateTimeStr14() + ".pptx";
// 保存PPT文件
//設置輸出文件類型為pptx文件
response.setContentType(CONTENT_TYPE_OF_PPT);
response.setHeader("Content-Disposition", "attachment;fileName=" + URLEncoder.encode(fileName, CHARSET_OF_UTF8));
response.setHeader("Pragma", URLEncoder.encode(fileName, CHARSET_OF_UTF8));
ServletOutputStream outputStream = response.getOutputStream();
ppt.write(outputStream);
outputStream.flush();
outputStream.close();
return new EiInfo();
}
extractContent方法：
public static List<String> extractContent(String input) {
List<String> contents = new ArrayList<>();
int startIndex = input.indexOf("{{");
while (startIndex != -1) {
int endIndex = input.indexOf("}}", startIndex);
if (endIndex != -1) {
String content = input.substring(startIndex, endIndex + 2);
contents.add(content);
startIndex = input.indexOf("{{", endIndex);
} else {
break;
}
}
return contents;
}
getReportsToimage()方法：該方法針對的是：帆軟報表的普通報表中，出現(xiàn)非表格報表的處理方法[即：柱狀圖、折線圖等]，通過直接訪問帆軟鏈接的方式去獲取表格的base64編碼。文章來源：http://www.zghlxwxcb.cn/news/detail-842527.html
private String getReportsToimage() throws IOException {
String reportAddress = PlatApplicationContext.getProperty("項目名." + projectEnv + ".report.address");
// 創(chuàng)建HttpClient對象
CloseableHttpClient httpClient = HttpClients.createDefault();
try {
// 構(gòu)造請求URL
String apiUrl = reportAddress + "/*/netPrice_2.cpt&format=image&extype=JPG";
// 創(chuàng)建HttpGet請求
//HttpPost request = new HttpPost(apiUrl);
System.out.println("apiUrl");
System.out.println(apiUrl);
HttpGet httpGet = new HttpGet(apiUrl);
// 設置請求頭部
httpGet.addHeader("Content-Type", "text/html; charset=utf-8");
// 發(fā)送請求并獲取響應
HttpResponse responsed = httpClient.execute(httpGet);
// 解析響應數(shù)據(jù)
HttpEntity entity = responsed.getEntity();
// 檢查響應是否成功
if (responsed.getStatusLine().getStatusCode() == HttpStatus.SC_OK) {
// 獲取Content-Type頭部信息
Header contentTypeHeader = entity.getContentType();
String contentType = contentTypeHeader.getValue();
// 獲取輸入流
InputStream inStream = entity.getContent();
ByteArrayOutputStream outputStream_u = new ByteArrayOutputStream();
// 將圖片裁剪為寬60px，高60px
BufferedImage originalImage = ImageIO.read(inStream);
BufferedImage croppedImage = originalImage.getSubimage(0, 0, 3560, 1560);
// 將裁剪后的圖片轉(zhuǎn)換成字節(jié)數(shù)組
ByteArrayOutputStream outputStream_c = new ByteArrayOutputStream();
ImageIO.write(croppedImage, "png", outputStream_c);
byte[] croppedImageBytes = outputStream_c.toByteArray();
// 將圖片數(shù)據(jù)編碼為base64格式
String base64Image = Base64.getEncoder().encodeToString(croppedImageBytes);
System.out.println(base64Image);
String responseBody = EntityUtils.toString(entity);
// 處理響應數(shù)據(jù)
System.out.println(responseBody);
// 關(guān)閉輸入流和輸出流
inStream.close();
outputStream_u.close();
return "data:image/png;base64," + base64Image;
} else {
System.out.println("HTTP請求失?。?);
}
} catch (PlatException e) {
}
return "";
}
最后，在設置PPT模板的時候，將模板內(nèi)的圖片設置為修改后的別名：newTableIdi文章來源地址http://www.zghlxwxcb.cn/news/detail-842527.html
到了這里，關(guān)于將html網(wǎng)頁展示的圖表，下載到PPT文檔內(nèi)，以圖片的形式展示在PPT內(nèi)的文章就介紹完了。如果您還想了解更多內(nèi)容，請在右上角搜索TOY模板網(wǎng)以前的文章或繼續(xù)瀏覽下面的相關(guān)文章，希望大家以后多多支持TOY模板網(wǎng)！
