java 将远程共享文件夹excel转html

最新推荐文章于 2022-01-28 21:12:13 发布
最新推荐文章于 2022-01-28 21:12:13 发布
阅读量710 收藏
点赞数
分类专栏： java后台 文章标签： poi excel java html
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.youkuaiyun.com/u011081801/article/details/53419152
版权
这是一个将Excel文件转换为HTML格式的工具实现，支持多种文件路径来源，并能生成完整的HTML页面，包括表格样式和内容。

摘要生成于 C知道 ，由 DeepSeek-R1 满血版支持， 前往体验 >

代码是从poi官方的列子上拿下来的，做了一点小小的修改

代码如下：

package com.kingdom.test;
import java.io.BufferedReader;
import java.io.Closeable;
import java.io.FileInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.io.InputStreamReader;
import java.io.PrintWriter;
import java.util.Formatter;
import java.util.HashMap;
import java.util.HashSet;
import java.util.Iterator;
import java.util.Map;
import java.util.Set;

import jcifs.smb.SmbFile;
import jcifs.smb.SmbFileInputStream;
import jcifs.smb.SmbFileOutputStream;

import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.openxml4j.exceptions.InvalidFormatException;
import org.apache.poi.ss.examples.html.HSSFHtmlHelper;
import org.apache.poi.ss.examples.html.HtmlHelper;
import org.apache.poi.ss.examples.html.XSSFHtmlHelper;
import org.apache.poi.ss.format.CellFormat;
import org.apache.poi.ss.format.CellFormatResult;
import org.apache.poi.ss.usermodel.BorderStyle;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.ss.usermodel.CellStyle;
import org.apache.poi.ss.usermodel.CellType;
import org.apache.poi.ss.usermodel.Font;
import org.apache.poi.ss.usermodel.HorizontalAlignment;
import org.apache.poi.ss.usermodel.Row;
import org.apache.poi.ss.usermodel.Sheet;
import org.apache.poi.ss.usermodel.VerticalAlignment;
import org.apache.poi.ss.usermodel.Workbook;
import org.apache.poi.ss.usermodel.WorkbookFactory;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class ToHtml {
	private final Workbook wb;
    private final Appendable output;
    private boolean completeHTML;
    private Formatter out;
    private boolean gotBounds;
    private int firstColumn;
    private int endColumn;
    private HtmlHelper helper;

    private static final String DEFAULTS_CLASS = "excelDefaults";
    private static final String COL_HEAD_CLASS = "colHeader";
    private static final String ROW_HEAD_CLASS = "rowHeader";

    private static final Map<HorizontalAlignment, String> HALIGN = mapFor(
            HorizontalAlignment.LEFT, "left",
            HorizontalAlignment.CENTER, "center",
            HorizontalAlignment.RIGHT, "right",
            HorizontalAlignment.FILL, "left",
            HorizontalAlignment.JUSTIFY, "left",
            HorizontalAlignment.CENTER_SELECTION, "center");

    private static final Map<VerticalAlignment, String> VALIGN = mapFor(
            VerticalAlignment.BOTTOM, "bottom",
            VerticalAlignment.CENTER, "middle",
            VerticalAlignment.TOP, "top");

    private static final Map<BorderStyle, String> BORDER = mapFor(
            BorderStyle.DASH_DOT, "dashed 1pt",
            BorderStyle.DASH_DOT_DOT, "dashed 1pt",
            BorderStyle.DASHED, "dashed 1pt",
            BorderStyle.DOTTED, "dotted 1pt",
            BorderStyle.DOUBLE, "double 3pt",
            BorderStyle.HAIR, "solid 1px",
            BorderStyle.MEDIUM, "solid 2pt",
            BorderStyle.MEDIUM_DASH_DOT, "dashed 2pt",
            BorderStyle.MEDIUM_DASH_DOT_DOT, "dashed 2pt",
            BorderStyle.MEDIUM_DASHED, "dashed 2pt",
            BorderStyle.NONE, "none",
            BorderStyle.SLANTED_DASH_DOT, "dashed 2pt",
            BorderStyle.THICK, "solid 3pt",
            BorderStyle.THIN, "dashed 1pt");

    @SuppressWarnings({"unchecked"})
    private static <K, V> Map<K, V> mapFor(Object... mapping) {
        Map<K, V> map = new HashMap<K, V>();
        for (int i = 0; i < mapping.length; i += 2) {
            map.put((K) mapping[i], (V) mapping[i + 1]);
        }
        return map;
    }

    /**
     * Creates a new converter to HTML for the given workbook.
     *
     * @param wb     The workbook.
     * @param output Where the HTML output will be written.
     *
     * @return An object for converting the workbook to HTML.
     */
    public static ToHtml create(Workbook wb, Appendable output) {
        return new ToHtml(wb, output);
    }

    /**
     * Creates a new converter to HTML for the given workbook.  If the path ends
     * with "<tt>.xlsx</tt>" an {@link XSSFWorkbook} will be used; otherwise
     * this will use an {@link HSSFWorkbook}.
     *
     * @param path   The file that has the workbook.
     * @param output Where the HTML output will be written.
     *
     * @return An object for converting the workbook to HTML.
     */
    public static ToHtml create(String path, Appendable output)
            throws IOException {
    	InputStream in = null;
    	if(path.indexOf("//") != -1 ){
    		in = new SmbFileInputStream(new SmbFile(path));
		}else{
			in = new FileInputStream(path);
		}
        return create(in, output);
    }

    /**
     * Creates a new converter to HTML for the given workbook.  This attempts to
     * detect whether the input is XML (so it should create an {@link
     * XSSFWorkbook} or not (so it should create an {@link HSSFWorkbook}).
     *
     * @param in     The input stream that has the workbook.
     * @param output Where the HTML output will be written.
     *
     * @return An object for converting the workbook to HTML.
     */
    public static ToHtml create(InputStream in, Appendable output)
            throws IOException {
        try {
            Workbook wb = WorkbookFactory.create(in);
            return create(wb, output);
        } catch (InvalidFormatException e){
            throw new IllegalArgumentException("Cannot create workbook from stream", e);
        }
    }

    private ToHtml(Workbook wb, Appendable output) {
        if (wb == null)
            throw new NullPointerException("wb");
        if (output == null)
            throw new NullPointerException("output");
        this.wb = wb;
        this.output = output;
        setupColorMap();
    }

    private void setupColorMap() {
        if (wb instanceof HSSFWorkbook)
            helper = new HSSFHtmlHelper((HSSFWorkbook) wb);
        else if (wb instanceof XSSFWorkbook)
            helper = new XSSFHtmlHelper();
        else
            throw new IllegalArgumentException(
                    "unknown workbook type: " + wb.getClass().getSimpleName());
    }

    /**
     * Run this class as a program
     *
     * @param args The command line arguments.
     *
     * @throws Exception Exception we don't recover from.
     */
    public static void main(String[] args) throws Exception {
        /*if(args.length < 2){
            System.err.println("usage: ToHtml inputWorkbook outputHtmlFile");
            return;
        }*/
    	 final String path = "//192.168.12.142/kdum/2016/11/29/";
    	 String filename = "案件列表（市局结案环节）.xls";
    	 SmbFile excelFile = new SmbFile("smb:"+path+filename);
    	 SmbFile htmlFile = new SmbFile("smb:"+path+filename.substring(0,filename.lastIndexOf("."))+".html");
         if(!excelFile.exists()){  
             try {  
            	 excelFile.createNewFile();
             } catch (IOException e) {  
                 // TODO Auto-generated catch block  
                 e.printStackTrace();  
             }  
         }  
         if(!htmlFile.exists()){  
             try {  
            	 htmlFile.createNewFile();
             } catch (IOException e) {  
                 e.printStackTrace();  
             }  
         } 
        ToHtml toHtml = create(excelFile.getCanonicalPath(), new PrintWriter(new SmbFileOutputStream(htmlFile)));
        toHtml.setCompleteHTML(true);
        toHtml.printPage();
    }

    public void setCompleteHTML(boolean completeHTML) {
        this.completeHTML = completeHTML;
    }

    public void printPage() throws IOException {
        try {
            ensureOut();
            if (completeHTML) {
                out.format(
                        "<?xml version=\"1.0\" encoding=\"GBK\" ?>%n");
                out.format("<html>%n");
                out.format("<head>%n");
                out.format("</head>%n");
                out.format("<body>%n");
            }

            print();

            if (completeHTML) {
                out.format("</body>%n");
                out.format("</html>%n");
            }
        } finally {
            if (out != null)
                out.close();
            if (output instanceof Closeable) {
                Closeable closeable = (Closeable) output;
                closeable.close();
            }
        }
    }

    public void print() {
        printInlineStyle();
        printSheets();
    }

    private void printInlineStyle() {
        //out.format("<link href=\"excelStyle.css\" rel=\"stylesheet\" type=\"text/css\">%n");
        out.format("<style type=\"text/css\">%n");
        printStyles();
        out.format("</style>%n");
    }

    private void ensureOut() {
        if (out == null)
            out = new Formatter(output);
    }

    public void printStyles() {
        ensureOut();

        // First, copy the base css
        BufferedReader in = null;
        try {
            in = new BufferedReader(new InputStreamReader(
                    getClass().getResourceAsStream("excelStyle.css")));
            String line;
            while ((line = in.readLine()) != null) {
                out.format("%s%n", line);
            }
        } catch (IOException e) {
            throw new IllegalStateException("Reading standard css", e);
        } finally {
            if (in != null) {
                try {
                    in.close();
                } catch (IOException e) {
                    //noinspection ThrowFromFinallyBlock
                    throw new IllegalStateException("Reading standard css", e);
                }
            }
        }

        // now add css for each used style
        Set<CellStyle> seen = new HashSet<CellStyle>();
        for (int i = 0; i < wb.getNumberOfSheets(); i++) {
            Sheet sheet = wb.getSheetAt(i);
            Iterator<Row> rows = sheet.rowIterator();
            while (rows.hasNext()) {
                Row row = rows.next();
                for (Cell cell : row) {
                    CellStyle style = cell.getCellStyle();
                    if (!seen.contains(style)) {
                        printStyle(style);
                        seen.add(style);
                    }
                }
            }
        }
    }

    private void printStyle(CellStyle style) {
        out.format(".%s .%s {%n", DEFAULTS_CLASS, styleName(style));
        styleContents(style);
        out.format("}%n");
    }

    private void styleContents(CellStyle style) {
        styleOut("text-align", style.getAlignmentEnum(), HALIGN);
        styleOut("vertical-align", style.getVerticalAlignmentEnum(), VALIGN);
        fontStyle(style);
        borderStyles(style);
        helper.colorStyles(style, out);
    }

    private void borderStyles(CellStyle style) {
        styleOut("border-left", style.getBorderLeftEnum(), BORDER);
        styleOut("border-right", style.getBorderRightEnum(), BORDER);
        styleOut("border-top", style.getBorderTopEnum(), BORDER);
        styleOut("border-bottom", style.getBorderBottomEnum(), BORDER);
    }

    private void fontStyle(CellStyle style) {
        Font font = wb.getFontAt(style.getFontIndex());

        if (font.getBold())
            out.format("  font-weight: bold;%n");
        if (font.getItalic())
            out.format("  font-style: italic;%n");

        int fontheight = font.getFontHeightInPoints();
        if (fontheight == 9) {
            //fix for stupid ol Windows
            fontheight = 10;
        }
        out.format("  font-size: %dpt;%n", fontheight);

        // Font color is handled with the other colors
    }

    private String styleName(CellStyle style) {
        if (style == null)
            style = wb.getCellStyleAt((short) 0);
        StringBuilder sb = new StringBuilder();
        Formatter fmt = new Formatter(sb);
        try {
            fmt.format("style_%02x", style.getIndex());
            return fmt.toString();
        } finally {
            fmt.close();
        }
    }

    private <K> void styleOut(String attr, K key, Map<K, String> mapping) {
        String value = mapping.get(key);
        if (value != null) {
            out.format("  %s: %s;%n", attr, value);
        }
    }

    private static CellType ultimateCellType(Cell c) {
        CellType type = c.getCellTypeEnum();
        if (type == CellType.FORMULA)
            type = c.getCachedFormulaResultTypeEnum();
        return type;
    }

    private void printSheets() {
        ensureOut();
        Sheet sheet = wb.getSheetAt(0);
        printSheet(sheet);
    }

    public void printSheet(Sheet sheet) {
        ensureOut();
        out.format("<table class=%s>%n", DEFAULTS_CLASS);
        printCols(sheet);
        printSheetContent(sheet);
        out.format("</table>%n");
    }

    private void printCols(Sheet sheet) {
        out.format("<col/>%n");
        ensureColumnBounds(sheet);
        for (int i = firstColumn; i < endColumn; i++) {
            out.format("<col/>%n");
        }
    }

    private void ensureColumnBounds(Sheet sheet) {
        if (gotBounds)
            return;

        Iterator<Row> iter = sheet.rowIterator();
        firstColumn = (iter.hasNext() ? Integer.MAX_VALUE : 0);
        endColumn = 0;
        while (iter.hasNext()) {
            Row row = iter.next();
            short firstCell = row.getFirstCellNum();
            if (firstCell >= 0) {
                firstColumn = Math.min(firstColumn, firstCell);
                endColumn = Math.max(endColumn, row.getLastCellNum());
            }
        }
        gotBounds = true;
    }

    private void printColumnHeads() {
        out.format("<thead>%n");
        out.format("  <tr class=%s>%n", COL_HEAD_CLASS);
        out.format("    <th class=%s>◊</th>%n", COL_HEAD_CLASS);
        //noinspection UnusedDeclaration
        StringBuilder colName = new StringBuilder();
        for (int i = firstColumn; i < endColumn; i++) {
            colName.setLength(0);
            int cnum = i;
            do {
                colName.insert(0, (char) ('A' + cnum % 26));
                cnum /= 26;
            } while (cnum > 0);
            out.format("    <th class=%s>%s</th>%n", COL_HEAD_CLASS, colName);
        }
        out.format("  </tr>%n");
        out.format("</thead>%n");
    }

    private void printSheetContent(Sheet sheet) {
        printColumnHeads();

        out.format("<tbody>%n");
        Iterator<Row> rows = sheet.rowIterator();
        while (rows.hasNext()) {
            Row row = rows.next();

            out.format("  <tr>%n");
            out.format("    <td class=%s>%d</td>%n", ROW_HEAD_CLASS,
                    row.getRowNum() + 1);
            for (int i = firstColumn; i < endColumn; i++) {
                String content = " ";
                String attrs = "";
                CellStyle style = null;
                if (i >= row.getFirstCellNum() && i < row.getLastCellNum()) {
                    Cell cell = row.getCell(i);
                    if (cell != null) {
                        style = cell.getCellStyle();
                        attrs = tagStyle(cell, style);
                        //Set the value that is rendered for the cell
                        //also applies the format
                        CellFormat cf = CellFormat.getInstance(
                                style.getDataFormatString());
                        CellFormatResult result = cf.apply(cell);
                        content = result.text;
                        if (content.equals(""))
                            content = " ";
                    }
                }
                out.format("    <td class=%s %s>%s</td>%n", styleName(style),
                        attrs, content);
            }
            out.format("  </tr>%n");
        }
        out.format("</tbody>%n");
    }

    private String tagStyle(Cell cell, CellStyle style) {
        if (style.getAlignmentEnum() == HorizontalAlignment.GENERAL) {
            switch (ultimateCellType(cell)) {
            case STRING:
                return "style=\"text-align: left;\"";
            case BOOLEAN:
            case ERROR:
                return "style=\"text-align: center;\"";
            case NUMERIC:
            default:
                // "right" is the default
                break;
            }
        }
        return "";
    }
}

css样式文件：（是从别人那借过来的，暂未研究这个东西） 

.excelDefaults {  
      
    background-color: white;  
    color: black;  
    text-decoration: none;  
    direction: ltr;  
    text-transform: none;  
    text-indent: 0;  
    letter-spacing: 0;  
    word-spacing: 0;  
    white-space: normal;  
    unicode-bidi: normal;  
    background-image: none;  
    text-shadow: none;  
    list-style-image: none;  
    list-style-type: none;  
    padding: 0;  
    margin: 0;  
    border-collapse: collapse;  
    font-style: normal;  
    font-family: 宋体;  
    font-variant: normal;  
    font-weight: normal;  
    font-size: 10pt;  
    text-align: left;  
      
}  
  
.excelDefaults td {  
    /*padding: 1px 5px;*/  
    border: 1;  
}  
  
.excelDefaults .colHeader {  
    background-color: silver;  
    font-weight: bold;  
    border: 1px solid black;  
    text-align: center;  
    padding: 1px 5px;  
}  
  
.excelDefaults .rowHeader {  
    background-color: silver;  
    font-weight: bold;  
    border: 1px solid black;  
    text-align: right;  
    padding: 1px 5px;  
}

注意:commons-collections.jar包的版本得高点不然会报错，我用的是4.4的jar包

linux服务器上远程读取远程window电脑文件？Java实现
weixin_40800275的博客
07-29 847
读取远程文件快慢依赖于网络IO速度，大文件读取可能比较慢。window电脑的ip需要设置固定ip，避免winodw电脑ip频繁变动。整体过程配置流程比较多、有问题可以私聊本人沟通。
服务器ftp文件不能共享文件夹权限设置,ftp服务器共享不了文件夹权限
weixin_42129300的博客
08-05 584
ftp服务器共享不了文件夹权限 内容精选换一换华为云对象存储服务帮助中心，为用户提供产品简介、价格说明、购买指南、用户指南、API参考、最佳实践、常见问题、视频帮助等技术文档，帮助您快速上手使用对象存储服务。企业不同部门/项目之间需要共享的数据，本部门/项目允许其他部门/项目用户下载共享数据，禁止写删，以降低共享数据被误删、篡改的风险。本文以部门A共享存储在example-bucket桶中的数据给...
java excel转html
03-25
java excel转html 支持32为和64位
java将excel转html
09-24
java将excel转为html(03,07都可以),用于在线预览或手机端浏览excel
java excel文件转html
西凉的悲伤博客
01-28 8164
maven文件如下： 2、工具类 3、测试与效果 效果如下：通过Aspose.Cells 来实现 excel 转化为 html Aspose.Cells官网maven如下： 或者百度云下载jar 链接：https://pan.baidu.com/s/1lElXrUZ4seowJ1xSfAvPLA 提取码：wssh因为评估版生成的html会有水印（官网水印说明），所以我写了个工具类来去除水印，工具类如下： 3.转化为html 4.转换效果 通过Spire.XLS 来实现 excel 转化为 html ,
Java 之Excel 转HTML 篇
m0_37598953的博客
08-06 8936
import java.io.BufferedOutputStream; import java.io.BufferedWriter; import java.io.File; import java.io.FileNotFoundException; import java.io.FileOutputStream; import java.io.IOException; import ja...
Java将excel转为html
tanwenfang的博客
07-02 9968
1，maven项目加入依赖 <dependency> <groupId>org.apache.poi</groupId> <artifactId>poi</artifactId> <version>3.9</version> </dependency> <...
远程服务器怎么运行exe文件,java打开远程机器的启动exe文件
weixin_42608299的博客
07-29 1308
java打开远程机器的启动exe文件[2021-02-02 01:39:09]简介:系统运维Windows中tocmat设置为服务开机启动一 安装Java，tomcat安装jdk，解压tomcat，配置好Java环境变量 二 配置tomcat作为服务启动 tomphp去除nbsp的方法：首先创建一个PHP代码示例文件；然后通过“preg_replace("/(\s|\&nbsp\...
使用smb协议获取远程服务器的文件(共享文件)
xujunxiong0621的博客
01-08 3642
       最近用户需要需要程序定时去读取另外一台机器的EXCEL文件，我出了个解决方案：因为是windows服务器，所以我在本地映射了一个盘Z然后就想读取本机的文件那样读取，结果临到上生产的时候发现只要服务器休眠后映射就会被断开，导致读取失败，找不到文件。        后来多方google之后，发现SMB协议 ,屌丝程序员的福音啊。       SMB协议(百度百科) ：     ht...
用java代码实现两个linux服务器文件的互相拷贝,linux两台服务器实现自动同步文件...
weixin_34493871的博客
03-13 2465
linux两台服务器实现自动同步文件服务器B(172.17.166.11)上开机或者重启会自动拉取服务器A(172.17.166.10)上指定目录下所有文件1、创建服务器B到服务器A的互信(1)服务器B上执行 ssh-keygen -t rsa 一路回车(2)服务器B上执行 ssh-copy-id -i 172.17.166.10 回车输入服务器A的密码(3)在服务器B上 执行 ssh 172.1...
java实现excel转换成html
10-19
java 实现wordpptexcel转换成html 都是经过测试的可放心使用
JAVA POI Excel转Html
03-06
JAVA POI Excel转Html，代码和所需的jar都在压缩包，项目在线预览需求，实现后分享下
Excel2html－纯java实现excel转html
05-23
使用java版excel操作api实现excel读取并转转为html，转换后的文件包含边框线、背景色、字体、字号、列宽等样式处理。
java将excel转换为html
weixin_42739916的博客
12-20 2491
方式一 /** * EXCEL转HTML * @param xlsfile EXCEL文件全路径 * @param htmlfile 转换后HTML存放路径 */ public void excelToHtml(String htmlfile,String xlsfile) { ActiveXCompo...
java将Excel转化为Html
dhlctaqzyba39516的博客
09-01 422
　　之前在做移动端页面的时候，发现iphone不支持预览excel文档，于是将excel转化为html元素然后查看其中的具体信息，在这里整理下文档，以便于记忆避免踩坑。 　　1. 引入相关的jar包文件 　　　　dom4j-1.6.1.jar 　　　　poi-3.9.jar 　　　　poi-ooxml-3.9.jar poi-ooxml-schemas-3.9.jar xml...
java excel 转 html格式_（POI）Excel格式转Html格式
weixin_36172296的博客
02-19 542
package test;import java.util.HashMap;import org.apache.poi.hssf.usermodel.HSSFCell;import org.apache.poi.hssf.usermodel.HSSFCellStyle;import org.apache.poi.hssf.usermodel.HSSFFont;import org.apache.p...
Excel转Html
abxlep7702的博客
10-29 358
项目结构： 这是一个maven项目，主函数在Client类里面 当运行程序的后，控制台情况： 当我们刷新了test.html文件后，用浏览器打开效果： 说一下这个过程的设计思路： 1.读取excel文件 2.利用velocity模板工具把读取的内容渲染到html里面 整个过程就两个步骤，是不是非常简单。 当我们在把这两个过程再细化一下，思路就更加清晰明了了。 ...
excel html java_Excel转html工具类
weixin_40006977的博客
02-12 322
packagecom.alphajuns.utils;import org.apache.poi.hssf.usermodel.*;importorg.apache.poi.hssf.util.HSSFColor;import org.apache.poi.ss.usermodel.*;importorg.apache.poi.ss.util.CellRangeAddress;importorg....
java excel 转html格式_谁知道在JAVA中Excel文件转换为Html格式。
weixin_29056701的博客
02-13 265
protected void Button1_Click(object sender, EventArgs e){if (FileUpload1.PostedFile.ContentLength > 0){try{string name = System.IO.Path.GetExtension(FileUpload1.PostedFile.FileName);if (name == ".x...
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值