• This repository has been archived on 27/Oct/2021
  • Stars
    star
    205
  • Rank 190,276 (Top 4 %)
  • Language
    Java
  • License
    Apache License 2.0
  • Created over 7 years ago
  • Updated over 5 years ago

Reviews

There are no reviews yet. Be the first to send feedback to the community and the maintainers!

Repository Details

An easy way to convert Excel to PDF by Java code based on Apache POI and itextpdf. 利用 JAVA 编写把 Excel 转 PDF 解决方案,依赖POI与IText库的实现。

excel2pdf

An easy way to convert Excel to PDF by Java code based on Apache POI and itextpdf. 利用 JAVA 编写把 Excel 转 PDF 解决方案,依赖POI与IText库的实现。

单文件转换 / Single files convert

String pathOfXls = "D:\\pdfexport\\MAD 5-3-05-Octavia NF-20131025.xls";
String pathOfPdf = "D:\\pdfexport\\MAD 5-3-05-Octavia NF-20131025.pdf";

FileInputStream fis = new FileInputStream(pathOfXls);
List<ExcelObject> objects = new ArrayList<ExcelObject>();
objects.add(new ExcelObject("导航1",fis));
FileOutputStream fos = new FileOutputStream(pathOfPdf);
Excel2Pdf pdf = new Excel2Pdf(objects, fos);
pdf.convert();

多文件转换 / Multiple files convert

多文件转换之后会合并至某一个 PDF 中,并且支持导航栏标题方式。

FileInputStream fis1 = new FileInputStream(new File("D:\\pdfexport\\MAD 5-3-05-Octavia NF-20131025.xls"));
FileInputStream fis2 = new FileInputStream(new File("D:\\pdfexport\\MAD 6-1-47-Octavia NF-20131025.xls"));
FileInputStream fis3 = new FileInputStream(new File("D:\\pdfexport\\MAD 038-Superb FL DS-20131025.xls"));

FileOutputStream fos = new FileOutputStream(new File("D:\\test.pdf"));

List<ExcelObject> objects = new ArrayList<ExcelObject>();
objects.add(new ExcelObject("1.MAD 5-3-05-Octavia NF-20131025.xls",fis1));
objects.add(new ExcelObject("2.MAD 6-1-47-Octavia NF-20131025.xls",fis2));
objects.add(new ExcelObject("3.MAD 038-Superb FL DS-20131025.xls",fis3));

Excel2Pdf pdf = new Excel2Pdf(objects , fos);
pdf.convert();

代码打包

package -Prelease -Dmaven.test.skip=true

贡献与建议 / Contribution

希望拿了此份代码的人改进了一些问题或提交BUG的请提交PR到这个主干上,我会做合并操作希望把这个库进行更加的完善,谢谢! All Contributions are welcomed

后续功能计划(可能需要重构)

1、对单个 Excel 文件的 Sheet 进行 PDF 的页处理,并把 Sheet 名称当做锚;
2、支持多个 Excel 文件的 Sheet 合并,并在 PDF 页后面进行追加;
3、实现自动分辨 Excel 版式并对内容进行有效的缩放。

More Repositories

1

jellyfin-plugin-opendouban

Douban metadata provider for Jellyfin
C#
187
star
2

jellyfin-plugin-maxsubtitle

一个 Jellyfin 中文字幕插件(未来可以不局限中文)
C#
75
star
3

douban-openapi-server

A Douban API server that provides an unofficial APIs for media information gathering
Python
66
star
4

javashop

社区开源版本JAVA B2C/CMS 系统,适合二次开发;An Community Open Source B2C/CMS system based on Java, Suitable for twice development.
JavaScript
27
star
5

maxsubtitle-openapi-server

一个简易的字幕接口服务端,主要利用爬虫进行结构化数据处理并暴露接口出来给各方平台接入使用
Go
21
star
6

spring-embedded-redis-server

A tiny redis embedded server fully integrated with Spring and Spring Boot, Only for testing or debugging.
Java
14
star
7

jellyfin-plugin-repo

Caryyu's Jellyfin Plugin Repositories
11
star
8

selenium-chrome

3
star
9

ddns-client

DDNS Client 是一个运行在用户机上的 Dynamic DNS 客户端更新器,主要原理是利用 DDNS 提供商所支持的 HTTP/HTTPS 域名解析修改链接来定时对本地路由的外网动态 IP 地址进行更新,这样我们就不用担心本地动态 IP 地址的问题了。 DDNS Client is a client or an updater for Dynamic DNS that running on the user computer, The principle is using modifiable HTTP/HTTPS URL of DDNS Provider to periodically update specific domain matching to dynamic public ip address of the local router , so there will be no longer worry about the dynamic public ip problems.
Shell
3
star
10

caryyu.github.io

HTML
2
star
11

RAP-Docker

基于官方v0.14.3制作的Docker容器,有什么问题请在Issue提出来,谢谢!
2
star
12

csdn-openapi

(非官方)一个封装 CSDN 接口的 Java 第三方程序,目前支持的功能参考下面的列表,有兴趣的有伙伴可以一起追加维护哈!😄
Java
2
star
13

bteye

This project is a tampermonkey-based plugin that aims to aggregate the internet BitTorrent resources and apply to some kinds of interesting media-information-ranked sites, such as Douban(豆瓣)
JavaScript
2
star
14

spring-security-saml2-onelogin

Java
1
star
15

selenium-recorder

Java
1
star
16

xpack-license-modifier

Java
1
star
17

clock

利用JS与HTML5的Canvas绘制的一个闹钟例子。
JavaScript
1
star
18

auto-testing-demo

自动化测试入门教程(Maven + TestNG + Selenium)
Java
1
star
19

springmvc-fileuploading

如何使用 Spring MVC 进行单文件与多文件上传的三种情况
Java
1
star