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;

ExlToHtm {

//Single case mode

ExlToHtm exlToHtm=

;

ExlToHtm getExlToHtm(){

==null)

exlToHtm=new ExlToHtm();

exlToHtm; }

EXCEL_HTML = 44;

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

/** * EXCEL to HTML

*

xlsfile EXCEL file full path

*

htmlfile converted HTML storage Path */

public synchronized void excelToHtml(String xlsfile, Stringhtmlfile){

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

try {

        app.setProperty("Visible",

Variant(false));                                                                      

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

new

false

new int

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

Variantf = newVariant( false);

}catch

e.printStackTrace(); }finally

                                                                                       > /** * Modify css style

*

filePath

*

cssPath

*/

public static void readCss(StringfilePath,String cssPath) {

BufferedReaderbr = null;

Stringline =

; StringBufferbuf =

StringBuffer(); Stringcontent =

; Filetxt=

File(cssPath); FileOutputStreamfos =

;

{ fos=

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

br= newBufferedReader (

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

((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();

bytes[]=

[1024];

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

                                                                                                                                                                                                                                                                       🎜> }

(Exception e) {

e.printStackTrace(); }

{

// Close stream

                                         br. close();

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

                e2.printStackTrace();

            }

         }

      } 

   } 

}