javaÉú³Éxls
Ôõô°Ñ´ÓÊý¾Ý¿âÈ¡³öÀ´µÄÊý¾ÝÉú³ÉÒ»¸öExcelÎļþ£¬²¢ÏÔʾÊý¾Ý
ÓÃÓÃjxl
jxl.jar
×Ô¼º°Ù¶È google Ò»¶Ñ´úÂë ºÇºÇ
jxl »òÕß poi ¶¼ÊǺܺõĴ¦Àí·½·¨ ±È½Ï¶øÒÑpoiЧÂʸü¸ß
ÓÃpoi°É£¬°Ù¶È£¬googleÊÇÄã×îºÃµÄÀÏʦ
ÓкöàµÄ×é¼þ¶¼Ö§³ÖÊý¾ÝµÄµ¼Èëµ¼³ö ¿ÉÒÔµ¼³ö³ÉexcelµÄ pdfµÄµÈµÈ
ÍÆ¼öextremecomponents ×é¼þ
ÿÌì»ØÌû¿ÉµÃ10·Ö¿ÉÓ÷ÖO(¡É_¡É)O~
jxl »òÕß poi
jxlÁË£¬×Ô¼ºÏÈÑо¿Ò»Ï£¬²»ÐÐÎÒÕâÀïÓиöдºÃµÄ¹¤¾ßÀ๩µ÷Ó㬿ÉÒÔ¸øÄã²Î¿¼Ò»ÏÂ
poi ÓÐComThread ½ø³ÌÎÊÌ⣬·Ç·¨¹Ø±Õ½ø³ÌÒ»Ö±´æÔÚ
jxl Êý¾ÝÁ¿¹ý´ó »áÄÚ´æÐ¹Â©
jacob²Ù×÷excel
½¨ÒéÓÃjacob1.9µÄ ¾ßÌåÔõôÅäÖÃ ÍøÉÏÕÒϰÉ
Java code:
private ActiveXComponent xl;
private Dispatch workbooks = null;
private Dispatch workbook = null;
private Dispatch sheet = null;
private String filename = null;
private boolean readonly = false;
private Dispatch sheets = null;// »ñµÃsheets¼¯ºÏ¶ÔÏó
public void clean() {
xl = null;
workbooks = null;
workbook = null;
sheet = null;
filename = null;
sheets = null;// »ñµÃsheets¼¯ºÏ¶ÔÏó
}
// ´ò¿ªExcelÎĵµ
public void OpenExcel(String file, boolean f) {
ComThread.InitSTA();
//ComThread.InitSTA(true);
try {
filename = file;
Ïà¹ØÎÊ´ð£º
import java.sql.Connection;
import java.sql.Date;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class QueryTest&n ......
¹¤×÷ÐèÒª Çó´ó¼Ò°ïæд¸ö³ÌÐò
ÎÒÊÇѧC++µÄ ²»¶®JAVA
±àдһ¸öJavaÓ¦ÓóÌÐò£¬¶ÔÓÚ¸ø¶¨µÄÒ»¸ö×Ö·û´®µÄ¼¯ºÏ£¬¸ñʽÈ磺
{aaa bbb ccc}£¬ {bbb ddd}£¬{eee fff}£¬{ggg}£¬{ddd hhh}
ÒªÇ󽫯äÖн»¼¯²»Îª¿ÕµÄ ......
ÔÚaspÀïÔõôµ÷ÓÃjavaдµÄwebservice·½·¨£¬Óкܶ෽·¨
- <message name="RtPnrIn">
<part name="bstrPnrNO" type="s:string" />
<part name ......
ÎÒ¶¨ÒåÁËÒ»¸öJRadioButtonNanµÄµ¥Ñ¡°´Å¥£¬Èç¹ûÔÚÎÒÑ¡ÔñÁËÕâ¸ö°´Å¥ºóÏëµã»÷ÖØÖÃÈÃÕâ¸ö°´Å¥´¦ÓÚδѡÔñµÄ״̬¸ÃÔõô×öÄØ£¿Çë¸ßÊÖÖ¸½Ì
jRadioButton.setSelected(false);
²»ÖªµÀÄãÊÇʲôÒâ˼
Õâ¸öÊDz»Ñ¡Ôñ״̬ÁË
Î ......
CREATE DATABASE ADDRESSLIST;
USE ADDRESSLIST;
DROP TABLE IF EXISTS FRIEND;
CREATE TABLE FRIEND
(FRIEND_ID INTEGER NOT NULL AUTO_INCREMENT PRIMARY KEY ,
FRIEND_NAME VARCHAR(20) NOT N ......