Method to convert Exl to html_html/css_WEB-ITnose

This method uses a plug-in: jacob-1.15-M4. This plug-in can convert office to html. I only introduce one here, converting Exl to html. Some of the converted html The border line is 0.5px. Some browsers do not recognize the 0.5px border line. You need to convert the 0.5px in the generated CSS to 1px. If you need to convert multiple times in the system, it is recommended to write a singleton mode. Otherwise, your computer's memory will be exhausted after several conversions. The reason is very simple, that is, each conversion will start the Exl program. If it is started too many times, the system memory will be full. Therefore, it is recommended to write in singleton mode. Without further ado, just post the code:

If you need to download the plug-in, you can click here to download: http://download.csdn.net/detail/s592652578/8446163

package com.odon.common.util;

import java.io.BufferedReader ;

import java.io.File;

import java.io.FileOutputStream;

import java.io.FileReader;

import java.io.IOException;

activeX.ActiveXComponent;

import com.jacob.com.Dispatch;

import com.jacob.com.Variant;

public class

ExlToHtm {

//Single case mode

private static

ExlToHtm exlToHtm=

null

;

public static

ExlToHtm getExlToHtm(){

==null)

exlToHtm=new ExlToHtm();

return

exlToHtm; }

public static final int

EXCEL_HTML = 44;

public static final

ActiveXComponent app = new ActiveXComponent("Excel.Application"); // Start exl

/** * EXCEL to HTML

*

@param

xlsfile EXCEL file full path

*

@param

htmlfile converted HTML storage Path */

public synchronized void excelToHtml(String xlsfile, Stringhtmlfile){

// ActiveXComponentapp = new ActiveXComponent("Excel.Application"); // Start exl

try {

        app.setProperty("Visible",

new

Variant(false));                                                                      

Dispatchexcel = Dispatch.invoke( excels, "Open",                                                          

Object[] { xlsfile,

new

Variant(

false

),

                                                },

new int

[1]).toDispatch();

Dispatch.invoke(excel,"SaveAs",Dispatch.Method,

newObject[] { htmlfile,newVariant(EXCEL_HTML)}, newint

[1]);

Variantf = newVariant( false);

Dispatch.call(excel,"Close",f);

}catch

(Exception e){

e.printStackTrace(); }finally

{

                                                                                       > /** * Modify css style

*

@param

filePath

*

@param

cssPath

*/

public static void readCss(StringfilePath,String cssPath) {

BufferedReaderbr = null;

Stringline =

null

; StringBufferbuf =

new

StringBuffer(); Stringcontent =

null

; Filetxt=

new

File(cssPath); FileOutputStreamfos =

null

;

try

{ fos=

new

FileOutputStream(txt); // Create a buffered input stream based on the file path

br= newBufferedReader (

new

FileReader(filePath)); // Loop through each line of the file, modify the lines that need to be modified, and put them into the buffer object

while

((line = br.readLine())!= null){ // Modify the contents of some lines here according to actual needs

                                                                                                                                           

line= line "r"; } buf.append(line);

}

//Judge file Does it exist?                                              content = buf.toString();

   

byte

bytes[]=

new byte

[1024];

     bytes=content.getBytes(); //Newly added

                                                                                                                                                                                                                                                                       🎜> }

catch

(Exception e) {

e.printStackTrace(); }

finally

{

// Close stream

                                         br. close();

                                                                   fos .close();          }catch(Exception e2) {

                e2.printStackTrace();

            }

         }

      } 

   } 

}