huawei--在华为实现的excel转htm格式

最新推荐文章于 2024-05-08 20:28:07 发布

today1858

最新推荐文章于 2024-05-08 20:28:07 发布

阅读量3.1k

点赞数

分类专栏： java 文章标签： excel 华为 file string function html

本文链接：https://blog.csdn.net/today1858/article/details/5824907

版权

java 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

package com.huawei.transfer;

import java.io.File;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.util.Date;

import com.jacob.activeX.ActiveXComponent;
import com.jacob.com.Dispatch;
import com.jacob.com.Variant;

public class TransferAction {
public static final int WORD_HTML = 8;
public static final int WORD_TXT = 7;
public static final int EXCEL_HTML = 44;

/**
* 格式为.htm，而不是.html
*/
public static void excelToHtml(String xlsfile, String htmlfile){
ActiveXComponent app = new ActiveXComponent("Excel.Application"); // 启动excel
try {
app.setProperty("Visible", new Variant(false));
Dispatch excels = app.getProperty("Workbooks").toDispatch();
Dispatch excel = Dispatch.invoke(
excels,
"Open",
Dispatch.Method,
new Object[] { xlsfile, new Variant(false),
new Variant(true) }, new int[1]).toDispatch();

Dispatch.invoke(excel, "SaveAs", Dispatch.Method, new Object[] {
htmlfile, new Variant(EXCEL_HTML) }, new int[1]); //new Variant(44)一定是44
Variant f = new Variant(false);
Dispatch.call(excel, "Close", f);
}
catch (Exception e){
e.printStackTrace();
}finally{
app.invoke("Quit", new Variant[] {});
}
}

public void deleteFolder(File dir) {
File filelist[]=dir.listFiles();
int listlen=filelist.length;
for(int i=0;i <listlen;i++) {
if(filelist[i].isDirectory()) {
deleteFolder(filelist[i]);
filelist[i].delete();
}else{
filelist[i].delete();
}
}
}

public static void main(String[] args) {
File file1=new File("D:/report/");
File file2=new File("D:/report/html/");
if(!file1.exists()){file1.mkdir();}
if(!file2.exists()){file2.mkdir();}

Date d=new Date();
DateFormat df=new SimpleDateFormat("yyyy-MM-dd");
String dateString=df.format(d);
System.out.println(dateString);

//文件格式为"SysInCall_2010-07-14.xls"，所以该可执行文件要在报表订阅后执行（否则找不到）;
String fromPath="D:/report/";
String fromFile="SysInCall_"+dateString+".xls";

String toPath="D:/report/html/";
String toFile="SysInCall.htm";

TransferAction ta=new TransferAction();
ta.deleteFolder(new File(toPath));
ta.excelToHtml(fromPath+fromFile, toPath+toFile);

}
}

------------------------------------------------------------------------

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>


<script language='JavaScript' >
//获得本地IP地址
function GetLocalIPAddress() {
var obj = null;
var rslt = "";
try {
obj = new ActiveXObject("rcbdyctl.Setting");
rslt = obj.GetIPAddress;
obj = null;
} catch(e){
alert("some error is occuring!!");//异常发生
}
document.getElementById("LoginIP").value=rslt;
}

//表单提交时验证密码
function checkPassword(){
var LoginIP=document.getElementById('LoginIP').value;
var LoginPWD=document.getElementById('LoginPWD').value;
//alert(LoginPWD.length);
if(LoginPWD.length==0){
return false;
}

var getPWD=getValue();
if(trim(LoginPWD)==trim(getPWD)){
return true;
}
return false;
}

//根据key值获得文件中给定的value值
function getValue(){
var LoginIP=document.getElementById('LoginIP').value;
var text=GetEverything();//读init.properties文件
alert(text);
var str =text.split(";");
for(var i=0;i<str.length;i++){
var location1=str[i].indexOf("=");
var getIP=str[i].substr(0,location1);
if(trim(LoginIP)==trim(getIP)){
var len=str[i].length;
var getPWD=str[i].substr(location1+1,len-1);
alert("getPWD:"+getPWD);
return getPWD;
}
}
return;
}


//两端去空格函数 ,js中没有直接调用的trim方法
function trim(obj) {
return obj.replace(/(^/s*)|(/s*$)/g, "");
}

//读init.properties文件
function GetEverything() {
var fso;
var f;
var ForReading = 1;
var ForWriting = 2;
try {
fso = new ActiveXObject("Scripting.FileSystemObject");
var path=getPath();
alert(path);
//f = fso.OpenTextFile("E://workspace//reportProject//WebRoot//init.properties", ForReading);
f = fso.OpenTextFile(path, ForReading);
return f.ReadAll();
} catch(e){
alert("read file error");
return false;
}
}

//获得文件路径
function getPath(){
alert(document.location.href);
var pathfile=document.location.href;
var path=pathfile.substr(8,pathfile.length-18);
return path+"init.properties";
}

</script>

<style>
body{
padding:0;
margin:0:
}

.bodier{
margin:0 auto;
width:1003px;
height:759px;
background:url(backgr.gif) no-repeat;
}
.login{
width:482px;
margin:350px 0px 0px 279px;
}
</style>
</head>


<body>
<div class="bodier">
<div class="login" align="center">

AdressIP :<input type="text" name="LoginIP" id="LoginIP" disabled/><br/>
<form id="loginForm" name="loginForm" method="post" onSubmit="return checkPassword();"
action="report1.html">
Password :<input type="password" name="LoginPWD" id="LoginPWD"/><br/><br/>
<input type="reset" name="reset" value="reset"/>
<input type="submit" name='submit' value="submit"/>
</form>

</div>
</div>




<script>
GetLocalIPAddress();
</script>
</body>


</html>

today1858

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
1
评论
huawei--在华为实现的excel转htm格式

package com.huawei.transfer;import java.io.File;import java.text.DateFormat;import java.text.SimpleDateFormat;import java.util.Date;import com.jacob.activeX.ActiveXComponent;import com.jacob.com.Dispatch;import com.jacob.com.Variant;public class TransferAc
复制链接

扫一扫