给你一个最简单的方法: function AllAreaExcel() { var oXL = new ActiveXObject("Excel.Application"); var oWB = oXL.Workbooks.Add(); var oSheet = oWB.ActiveSheet; var sel=document.body.createTextRange(); sel.moveToElementText(这里表格的名字); sel.select(); sel.execCommand("Copy"); oSheet.Paste(); oXL.Visible = true; } javascript 用一个按钮调用这个事件就搞定。
import java.util.Iterator;import junit.framework.TestCase;import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;/**
* POI使用方法简单示例
* @author Administrator
*
*/
public class ExcelTest extends TestCase {
//创建Workbook
public void testCreateWorkbook(){
//创建Excel文件
HSSFWorkbook workbook = new HSSFWorkbook();
//创建页
HSSFSheet sheet = workbook.createSheet("Sheet1");
//创建行
HSSFRow row = sheet.createRow(0);
//创建列
HSSFCell cell = row.createCell((short)0);
cell.setCellValue("Hello World!");
try {
//将创建好的Excel文件保存到磁盘上
FileOutputStream output = new FileOutputStream("d:/test.xls");
workbook.write(output);
output.flush();
output.close();
} catch (Exception e) {
e.printStackTrace();
}
}
//创建Workbook
public void testCreateWorkbook1(){
//创建Excel文件
HSSFWorkbook workbook = new HSSFWorkbook();
//创建页
HSSFSheet sheet = workbook.createSheet("Sheet1");
//创建行
HSSFRow row = sheet.createRow(0);
//创建列
HSSFCell cell = row.createCell((short)0);
//正确设置单元格的编码,才能正确输出中文信息
cell.setEncoding(HSSFCell.ENCODING_UTF_16);
cell.setCellValue("世界你好");
try {
//将创建好的Excel文件保存到磁盘上
FileOutputStream output = new FileOutputStream("d:/test1.xls");
workbook.write(output);
output.flush();
output.close();
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 读取Excel文档的方法
*/
public void testReadWorkbook(){
try {
//读取test_template.xls文件
POIFSFileSystem ps = new POIFSFileSystem(
Thread.currentThread().getContextClassLoader().getResourceAsStream("test_template.xls")
);
HSSFWorkbook workbook = new HSSFWorkbook(ps);
//获取第一页的数据
HSSFSheet sheet = workbook.getSheetAt(0);
Iterator rows = sheet.rowIterator();
while(rows.hasNext()){
System.out.println();
HSSFRow row = (HSSFRow)rows.next();
Iterator cells = row.cellIterator();
while(cells.hasNext()){
HSSFCell cell = (HSSFCell)cells.next();
System.out.print(cell.getStringCellValue()+"\t");
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
/**
* 读取Excel文档的方法
*/
public void testReadWorkbook1(){
try {
//读取test_template.xls文件
POIFSFileSystem ps = new POIFSFileSystem(
Thread.currentThread().getContextClassLoader().getResourceAsStream("test_template.xls")
);
HSSFWorkbook workbook = new HSSFWorkbook(ps);
//获取第一页的数据
HSSFSheet sheet = workbook.getSheetAt(0);
Iterator rows = sheet.rowIterator();
while(rows.hasNext()){
System.out.println();
HSSFRow row = (HSSFRow)rows.next();
//获得最后一个单元格的编号
int cellLength = row.getLastCellNum();
//按顺序读取单元格的值
for(int i=0; i < cellLength; i++){
HSSFCell cell = row.getCell((short)i);
System.out.print(cell.getStringCellValue()+"\t");
}
}
} catch (Exception e) {
e.printStackTrace();
}
}
}
function AllAreaExcel()
{
var oXL = new ActiveXObject("Excel.Application");
var oWB = oXL.Workbooks.Add();
var oSheet = oWB.ActiveSheet;
var sel=document.body.createTextRange();
sel.moveToElementText(这里表格的名字);
sel.select();
sel.execCommand("Copy");
oSheet.Paste();
oXL.Visible = true;
}
javascript
用一个按钮调用这个事件就搞定。
而且需要对IE进行设置才行,不过还是谢谢了!