鍘熺悊寰堢畝鍗曞氨鏄嬌鐢‵ilter澶勭悊璁劇疆鐨勮姹傜殑 CharacterEncoding
鍏蜂綋瀹炵幇Filter
| package yidishui.util; |
| import javax.servlet.Filter; |
| import javax.servlet.FilterChain; |
| import javax.servlet.FilterConfig; |
| import javax.servlet.ServletException; |
| import javax.servlet.ServletRequest; |
| import javax.servlet.ServletResponse; |
| import java.io.IOException; |
| public class EncodingFilter implements Filter { |
| /** |
| * The default character encoding to set for requests that pass through this |
| * filter. |
| */ |
| protected String encoding = null; |
| /** |
| * The filter configuration object we are associated with. If this value is |
| * null, this filter instance is not currently configured. |
| */ |
| protected FilterConfig filterConfig = null; |
| /** |
| * Should a character encoding specified by the client be ignored? |
| */ |
| protected boolean ignore = true; |
| // --------------------------------------------------------- Public Methods |
| /** |
| * Take this filter out of service. |
| */ |
| public void destroy() { |
| this.encoding = null; |
| this.filterConfig = null; |
| } |
| /** |
| * Select and set (if specified) the character encoding to be used to |
| * interpret request parameters for this request. |
| * |
| * @param request The servlet request we are processing |
| * @param response The servlet response we are creating |
| * @param chain The filter chain we are processing |
| * @throws IOException if an input/output error occurs |
| * @throws ServletException if a servlet error occurs |
| */ |
| public void doFilter(ServletRequest request, ServletResponse response, |
| FilterChain chain) throws IOException, ServletException { |
| // Conditionally select and set the character encoding to be used |
| if (ignore || (request.getCharacterEncoding() == null)) { |
| String encoding = selectEncoding(request); |
| if (encoding != null) |
| request.setCharacterEncoding(encoding); |
| } |
| // Pass control on to the next filter |
| chain.doFilter(request, response); |
| } |
| /** |
| * Place this filter into service. |
| * |
| * @param filterConfig The filter configuration object |
| */ |
| public void init(FilterConfig filterConfig) throws ServletException { |
| this.filterConfig = filterConfig; |
| this.encoding = filterConfig.getInitParameter("encoding"); |
| String value = filterConfig.getInitParameter("ignore"); |
| if (value == null) |
| this.ignore = true; |
| else if (value.equalsIgnoreCase("true")) |
| this.ignore = true; |
| else if (value.equalsIgnoreCase("yes")) |
| this.ignore = true; |
| else |
| this.ignore = false; |
| } |
| // ------------------------------------------------------ Protected Methods |
| /** |
| * Select an appropriate character encoding to be used, based on the |
| * characteristics of the current request and/or filter initialization |
| * parameters. If no character encoding should be set, return |
| * <code>null</code>. |
| * <p/> |
| * The default implementation unconditionally returns the value configured |
| * by the <strong>encoding</strong> initialization parameter for this |
| * filter. |
| * |
| * @param request The servlet request we are processing |
| * @return return encoding |
| */ |
| protected String selectEncoding(ServletRequest request) { |
| return (this.encoding); |
| } |
| }// EOC |
2.鍏蜂綋web.xml閰嶇疆
| <filter> |
| <filter-name>EncodingFilter</filter-name> |
| <filter-class>yidishui.util.EncodingFilter</filter-class> |
| <init-param> |
| <param-name>encoding</param-name> |
| <param-value>UTF-8</param-value> |
| </init-param> |
| <init-param> |
| <param-name>ignore</param-name> |
| <param-value>yes</param-value> |
| </init-param> |
| </filter> |
| <filter-mapping> |
| <filter-name>EncodingFilter</filter-name> |
| <url-pattern>/*</url-pattern> |
| </filter-mapping> |
]]>
]]>
]]>
]]>
driver=org.hsqldb.jdbcDriverurl=jdbc:hsqldb:mem:jpetstoreusername=sapassword=java浠ｇ爜
聽聽聽聽聽 Properties聽props聽=聽Resources.getResourceAsProperties("properties/database.properties");聽聽聽聽聽聽String聽url聽=聽props.getProperty("url");聽聽聽聽聽聽String聽driver聽=聽props.getProperty("driver");聽聽聽聽聽聽String聽username聽=聽props.getProperty("username");聽聽聽聽聽聽String聽password聽=聽props.getProperty("password");]]>
鏃墮棿錛?006-2-10
瑙ｅ喅鏂規(guī)硶錛?nbsp;
HSSFSheet sheet = wb.createSheet();// 寤虹珛鏂扮殑sheet瀵硅薄 wb.setSheetName(0, "瀛︾敓鍩烘湰淇℃伅", (short) 1);*********************************************
]]>
Hssf閫氳繃 HSSFWorkbook 鍚戣緭鍑烘祦鍐欏叆錛?BR>鍏蜂綋浠ｇ爜錛?BR>
Bean錛?/P>
public class TestBean 
{
public String action() {
HSSFWorkbook wb = new HSSFWorkbook(); FacesContext context=FacesContext.getCurrentInstance(); HttpServletResponse response = (HttpServletResponse) context.getExternalContext().getResponse(); response.reset(); response.setContentType("application/ms-excel"); try { response.setHeader("Content-disposition", "attachment;filename="+new String("涓嬭澆Excel.xls".getBytes(),"iso-8859-1")); wb.write(response.getOutputStream()); } catch (Exception e1) { // TODO Auto-generated catch block e1.printStackTrace();
} FacesContext.getCurrentInstance().responseComplete(); return null; }
}<managed-bean> <managed-bean-name>test</managed-bean-name> <managed-bean-class>yds.study.web.TestBean</managed-bean-class> <managed-bean-scope>session</managed-bean-scope> </managed-bean><f:view> <h:form> <h:commandButton id="button" value="涓嬭澆" rendered="true" action="#{test123.action}" /> </h:form></f:view>ok榪欐牱灝卞彲浠ヤ簡(jiǎn);)
]]>
鍦ㄦ垜浠疄闄呯殑寮鍙戜腑錛岃〃鐜板眰鐨勮В鍐蟲柟妗堣櫧鐒舵湁澶氭牱錛屼絾鏄疘E嫻忚鍣ㄥ凡鎴愪負(fù)鏈澶氫漢浣跨敤鐨勬祻瑙堝櫒錛屽洜涓哄ぇ瀹墮兘鐢╓indows銆傚湪浼佷笟鍔炲叕緋葷粺涓紝甯稿父鏈夊鎴瘋繖鏍峰瓙瑕佹眰錛氫綘瑕佹妸鎴戜滑鐨勬姤琛ㄧ洿鎺ョ敤Excel鎵撳紑銆?BR>
鎴栬呮槸錛氭垜浠凡緇忎範(fàn)鎯敤Excel鎵撳嵃銆傝繖鏍峰瓙濡傛灉鐢?net寮鍙戞槸娌℃湁闂鐨勶紝浣嗘槸鏈塉2EE榪欎釜姣?net鏇存湁鍓嶉旂殑寮鏀懼紡鐨勫紑鍙戠幆澧冿紝闅鵑亾鎴戜負(fù)浜?jiǎn)瑙ｅ喯x墦鍗扮殑瑕佹眰鍘誨彟鍐欏鎴風(fēng)鐨勬帶浠訛紵鎴栬呭湪鏈嶅姟鍣ㄧ浣跨敤鏈湴浠ｇ爜錛熺涓縐嶆柟妗堢殑闂鏄叧閿暟鎹殑澶勭悊鏈夋椂鍊欎笉鑳藉湪瀹㈡埛绔仛錛岀2縐嶆柟妗堢殑闂鏄壓鐗蹭簡(jiǎn)浠ｇ爜鐨勫彲縐繪鎬у拰紼沖畾鎬с傚鏋滆瀹㈡埛绔彧璐熻矗澶勭悊鐢熸垚濂界殑鎶ヨ〃錛岄偅灝嗘槸涓縐嶈浜虹殑閫夋嫨銆?BR>
Apache鐨凧akata欏圭洰鐨凱OI瀛愰」鐩紝鐩爣鏄鐞唎le2瀵硅薄銆傜洰鍓嶆瘮杈冩垚鐔熺殑鏄疕SSF鎺ュ彛錛屽鐞哅S Excel錛?7-2002錛夊璞°傚畠涓嶈薄鎴戜滑浠呬粎鏄敤csv鐢熸垚鐨勬病鏈夋牸寮忕殑鍙互鐢盓xcel杞崲鐨勪笢瑗匡紝鑰屾槸鐪熸鐨凟xcel瀵硅薄錛屼綘鍙互鎺у埗涓浜涘睘鎬уsheet,cell絳夌瓑銆?BR>
榪欐槸涓涓勾杞葷殑欏圭洰錛屾墍浠ヨ薄HDF榪欐牱鐩存帴鏀寔Word瀵硅薄鐨勫ソ涓滆タ浠嶇劧鍦ㄨ璁′腑銆傚叾瀹冩敮鎸亀ord鏍煎紡鐨勭函Java鏂規(guī)榪樻湁itext錛屼笉榪囦篃鏄粛鍦ㄥ鏂椾腑銆備絾鏄疕SSF宸茬粡鎴愮啛鍒拌兘澶熷拰瓚沖鎴戜滑浣跨敤浜?jiǎn)銆?BR>
鍏跺疄錛屼粠寮鍙戝巻鍙茬殑瑙掑害璁詫紝鍦?0騫翠唬涓湡starOffice鐨勫師浣滆呭湪寰峰浗鎴愮珛浜?jiǎn)StarOffice suite鍏徃錛岀劧鍚庡埌1999騫村澶﹕tarOffice琚玸un鏀惰喘錛屽啀鍒?000騫?鏈坰tarOffice5.2鐨勫彂甯冿紱騫朵笖浠巗tarOffice6.0寮濮嬶紝starOffice寤虹珛鍦∣penOffice鐨刟pi鐨勫熀紜涓婏紝榪欎釜鍏紑浠ｇ爜鐨刼ffice欏圭洰宸茬粡榪涜浜?jiǎn)寰堥暱鐨勬棄櫁淬傝櫧鐒墮偅鏄敱C++鍐欑殑錛屼絾鏄疨OI鐨勪唬鐮侀儴鍒嗕篃鏄敱openOffice鏀硅繃鏉ョ殑銆傛墍浠ワ紝搴旇瀵筆OI鍏呮弧瓚沖鐨勪俊蹇?jī)銆傚浗鍐呭凡緇忔湁閮ㄥ垎鍏徃鍦ㄤ粬浠殑鍔炲叕鑷姩鍖栫瓑Web欏圭洰涓嬌鐢╬oi浜?jiǎn)锛屽鏃ユ亽鐨刬office錛屾搗娉扮殑HTOffice絳夈?BR>
Java褰撳垵鎶婃牳蹇?jī)澶勭悊璁炬垚Unicode錛屽甫鏉ョ殑濂藉鏄彟浠ｇ爜閫傚簲浜?jiǎn)澶氳瑷鐜銆傜劧鑰岀敱浜庤佸鐨勮嫳璇彧鏈?6涓瓧姣嶏紝鏈変簺鎯呭喌涓嬶紝涓浜涚▼搴忓憳鐢?浣嶇殑byte澶勭悊錛屼竴涓嶅皬蹇?jī)灏卞幚L帀浜?jiǎn)CJK鐨勯珮浣嶃傛垨鑰呮槸鐢變簬涔?fàn)鎯湪绋嬪簭涓噰鐢嫭缂栫爜锛寴q樻湁澶氱鍘熷洜錛屼嬌寰楄澶欽ava搴旂敤鍦–JK鐨勫鐞嗕笂寰堢儲(chǔ)鎭箋傝繕濂藉湪POI HSSF涓冭檻鍒拌繖涓棶棰橈紝鍙互璁劇疆encoding涓哄弻瀛楄妭銆?BR>
POI鍙互鍒皐ww.apache.org涓嬭澆鍒般傜紪璇戝ソ鐨刯ar涓昏鏈夎繖鏍?涓細(xì)poi鍖?poi Browser鍖?poi hdf鍖?poi hssf渚嬬▼鍖呫傚疄闄呰繍琛屾椂錛岄渶瑕佹湁poi鍖呭氨鍙互浜?jiǎn)銆?BR>
濡傛灉鐢↗akarta ant緙栬瘧鍜岃繍琛岋紝涓嬭澆apache Jakarta POI鐨剅elease涓殑src鍖咃紝瀹冮噷闈㈠凡緇忎負(fù)浣犵敓鎴愬ソ浜?jiǎn)build鏂囦歡浜?jiǎn)銆傚彧瑕佽繍琛宎nt灝卞彲浠ヤ簡(jiǎn)(ant 鐨勫畨瑁呭拰浣跨敤鍦ㄦ涓嶈浜?銆傚鏋滄槸鐢↗builder 榪愯錛岃鍦ㄦ柊寤虹殑欏圭洰涓姞鍏oi鍖呫?BR>
浠builder6涓轟緥錛岄夋嫨Tools鑿滃崟欏圭殑config libraries...閫夐」錛屾柊寤轟竴涓猯ib銆傚湪寮瑰嚭鐨勮彍鍗曚腑閫夋嫨poi鍖咃紝濡傝繖涓猨akarta-poi-1.5.1-final-20020820.jar錛屾妸poi娣誨姞鍒癹builder涓傜劧鍚庯紝鍙抽敭鐐瑰嚮浣犵殑欏圭洰錛屽湪project鐨刾roperties鑿滃崟涓璸ath鐨剅equired Libraries涓紝鐐筧dd錛屾坊鍔犲垰鎵嶅姞鍏ュ埌jbuilder涓殑poi鍒頒綘鐜板湪鐨勯」鐩腑銆?BR>
濡傛灉浣犱粎浠呮槸涓轟簡(jiǎn)鐔熸?zhèn)塒OI hssf鐨勪嬌鐢紝鍙互鐩存帴鐪婸OI鐨剆amples鍖呬腑鐨勬簮浠ｇ爜錛屽茍涓旇繍琛屽畠銆俬ssf鐨勫悇縐嶅璞￠兘鏈変緥紼嬬殑浠嬬粛銆俬ssf鎻愪緵鐨勪緥紼嬪湪org.apache.poi.hssf.usermodel.examples鍖呬腑錛屽叡鏈?4涓紝鐢熸垚鐨勭洰鏍噚ls閮芥槸workbook.xls銆傚鏋滀綘鎯崇湅鏇村鐨勪緥紼嬶紝鍙互鍙傝僪ssf鐨凧unit test cases錛屽湪poi鐨勫寘鐨勬簮浠ｇ爜涓湁銆俬ssf閮芥湁嫻嬭瘯浠ｇ爜銆?BR>榪欓噷鍙閮ㄥ垎渚嬬▼鐨勫疄鐜板仛浠嬬粛銆?BR>
HSSF鎻愪緵緇欑敤鎴蜂嬌鐢ㄧ殑瀵硅薄鍦╫rg.apache.poi.hssf.usermodel鍖呬腑,涓昏閮ㄥ垎鍖呮嫭Excell瀵硅薄錛屾牱寮忓拰鏍煎紡錛岃繕鏈夎緟鍔╂搷浣溿傛湁浠ヤ笅鍑犵瀵硅薄錛?BR>
HSSFWorkbook excell鐨勬枃妗ｅ璞?BR>
HSSFSheet excell鐨勮〃鍗?BR>
HSSFRow excell鐨勮
HSSFCell excell鐨勬牸瀛愬崟鍏?BR>
HSSFFont excell瀛椾綋
HSSFName 鍚嶇О
HSSFDataFormat 鏃ユ湡鏍煎紡
鍦╬oi1.7涓墠鏈変互涓?欏癸細(xì)
HSSFHeader sheet澶?BR>
HSSFFooter sheet灝?BR>
鍜岃繖涓牱寮?BR>
HSSFCellStyle cell鏍峰紡
杈呭姪鎿嶄綔鍖呮嫭
HSSFDateUtil 鏃ユ湡
HSSFPrintSetup 鎵撳嵃
HSSFErrorConstants 閿欒淇℃伅琛?BR>
浠旂粏鐪媜rg.apache.poi.hssf鍖呯殑緇撴瀯錛屼笉闅懼彂鐜癏SSF鐨勫唴閮ㄥ疄鐜伴伒寰殑鏄疢VC妯″瀷銆?BR>
榪欓噷鎴戠敤Rose鎶妎rg.apache.poi.hssf.usermodel鍖呬腑鐨勫璞″弽鍚戝鍏ュ茍鏍規(guī)嵁鐩鎬簰鍏崇郴浣滀簡(jiǎn)鏁寸悊錛岃瑙佷笅闈袱鍥撅細(xì)
鍥? 鍩烘湰瀵硅薄
浠庝腑涓嶉毦鍙互鍙戠幇姣忎竴涓熀鏈璞￠兘鍏寵仈浜?jiǎn)涓涓猂ecord瀵硅薄銆俁ecord瀵硅薄鏄竴涓弬鑰僌ffice鏍煎紡鐨勭浉鍏寵褰曘?nbsp;
鍥? HSSFWorkbook
HSSFWorkbook鍗蟲槸涓涓狤xcell瀵硅薄銆傝繖騫呯被鍥句綋鐜扮殑鏄疕SSFWorkbook鍜屽熀鏈璞＄殑鐩鎬簰鍏崇郴銆傚彲瑙侊紝璁稿瀵硅薄涓篃寤虹珛浜?jiǎn)Workbook鐨勫紩鐢ㄣ傝繕闇瑕佹敞鎰忕殑鏄湪HSSFWorkbook鍜孒SSFSheet涓緩绔嬩簡(jiǎn)log鏈哄埗POILogger錛岃屼笖POILogger涔熸槸浣跨敤apache Log4J瀹炵幇鐨勩?BR>
鍏堢湅poi鐨別xamples鍖呬腑鎻愪緵鐨勬渶綆鍗曠殑渚嬪瓙錛屽緩绔嬩竴涓┖xls鏂囦歡銆?BR>
import org.apache.poi.hssf.usermodel.HSSFWorkbook;import java.io.FileOutputStream;import java.io.IOException;public class NewWorkbook{public static void main(String[] args)throws IOException{HSSFWorkbook wb = new HSSFWorkbook();//寤虹珛鏂癏SSFWorkbook瀵硅薄FileOutputStream fileOut =new FileOutputStream("workbook.xls"錛?wb.write(fileOut);//鎶奧orkbook瀵硅薄杈撳嚭鍒版枃浠秝orkbook.xls涓?/SPAN>fileOut.close();}}閫氳繃榪欎釜渚嬪瓙錛屾垜浠緩绔嬬殑鏄竴涓┖鐧界殑xls鏂囦歡錛堜笉鏄┖鏂囦歡錛夈傚湪姝ゅ熀紜涓婏紝鎴戜滑鍙互榪涗竴姝ョ湅鍏跺畠鐨勪緥瀛愩?nbsp;
import org.apache.poi.hssf.usermodel.*;import java.io.FileOutputStream;import java.io.IOException;public class CreateCells{public static void main(String[] args)throws IOException{HSSFWorkbook wb = new HSSFWorkbook();//寤虹珛鏂癏SSFWorkbook瀵硅薄HSSFSheet sheet = wb.createSheet("new sheet"錛?//寤虹珛鏂扮殑sheet瀵硅薄// Create a row and put some cells in it.Rows are 0 based.HSSFRow row = sheet.createRow((short)0);//寤虹珛鏂拌// Create a cell and put a value in it.HSSFCell cell = row.createCell((short)0);//寤虹珛鏂癱ellcell.setCellvalue(1);//璁劇疆cell鐨勬暣鏁扮被鍨嬬殑鍊?BR>// Or do it on one line.row.createCell((short)1).setCellvalue(1.2);//璁劇疆cell嫻偣綾誨瀷鐨勫?/SPAN>row.createCell((short)2).setCellvalue("test"錛?//璁劇疆cell瀛楃綾誨瀷鐨勫?/SPAN>row.createCell((short)3).setCellvalue(true);//璁劇疆cell甯冨皵綾誨瀷鐨勫?nbsp;HSSFCellStyle cellStyle = wb.createCellStyle();//寤虹珛鏂扮殑cell鏍峰紡cellStyle.setDataFormat(HSSFDataFormat.getFormat("m/d/yy h:mm"錛夛級(jí);//璁劇疆cell鏍峰紡涓哄畾鍒剁殑鏃ユ湡鏍煎紡HSSFCell dCell =row.createCell((short)4);dCell.setCellvalue(new Date());//璁劇疆cell涓烘棩鏈熺被鍨嬬殑鍊?/SPAN>dCell.setCellStyle(cellStyle); //璁劇疆璇ell鏃ユ湡鐨勬樉紺烘牸寮?/SPAN>HSSFCell csCell =row.createCell((short)5);csCell.setEncoding(HSSFCell.ENCODING_UTF_16);//璁劇疆cell緙栫爜瑙ｅ喅涓枃楂樹綅瀛楄妭鎴柇csCell.setCellvalue("涓枃嫻嬭瘯_Chinese Words Test"錛?//璁劇疆涓タ鏂囩粨鍚堝瓧絎︿覆row.createCell((short)6).setCellType(HSSFCell.CELL_TYPE_ERROR);//寤虹珛閿欒cell// Write the output to a fileFileOutputStream fileOut = new FileOutputStream("workbook.xls"錛?wb.write(fileOut);fileOut.close();}}鎴戠◢寰慨鏀逛簡(jiǎn)鍘熸潵鐨別xamples鍖呬腑鐨凜reateCells綾誨啓浜?jiǎn)涓婇潰鐨勫姛鑳綃箣璇暰c匯傞氳繃榪欎釜渚嬪瓙錛屾垜浠彲浠ユ竻妤氱殑鐪嬪埌xls鏂囦歡浠庡ぇ鍒板皬鍖呮嫭浜?jiǎn)HSSFWorkbook HSSFSheet HSSFRow HSSFCell榪欐牱鍑犱釜瀵硅薄銆傛垜浠彲浠ュ湪cell涓緗悇縐嶇被鍨嬬殑鍊箋?nbsp;
灝ゅ叾瑕佹敞鎰忕殑鏄鏋滀綘鎯蟲紜殑鏄劇ず闈炴緹庣殑瀛楃鏃訛紝灝ゅ叾璞′腑鏃ラ煩榪欐牱鐨勮璦錛屽繀欏昏緗紪鐮佷負(fù)16浣嶇殑鍗蟲槸HSSFCell.ENCODING_UTF_16錛屾墠鑳戒繚璇佸瓧絎︾殑楂?浣嶄笉琚埅鏂屽紩璧風(fēng)紪鐮佸け鐪熷艦鎴愪貢鐮併?nbsp;
鍏朵粬嫻嬭瘯鍙互閫氳繃鍙傝僥xamples鍖呬腑鐨勬祴璇曚緥瀛愭帉鎻oi鐨勮緇嗙敤娉曪紝鍖呮嫭瀛椾綋鐨勮緗紝cell澶у皬鍜屼綆綰圭殑璁劇疆絳夈傞渶瑕佹敞鎰忕殑鏄疨OI鏄竴涓粛鐒跺湪瀹屽杽涓殑鍏紑浠ｇ爜鐨勯」鐩紝鎵浠ユ湁浜涘姛鑳芥鍦ㄤ笉鏂殑鎵╁厖銆?nbsp;
濡侶SSFSheet鐨刧etFooter() getHeader()鍜宻etFooter(HSSFFooter hsf) setHeader(HSSFHeader hsh)鏄湪POI1.7涓墠鏈夌殑錛岃孭OI1.5涓氨娌℃湁銆傝繍琛屾祴璇曠啛鎮(zhèn)変唬鐮佹垨鑰呬嬌鐢ㄥ畠鍋氶」鐩椂璇鋒敞鎰廝OI鐨勭増鏈?nbsp;
鍙﹀闇瑕佹敞鎰忕殑鏄疕SSF涔熸湁瀹冪殑瀵箈ls鍩轟簬浜嬩歡鐨勮В鏋愩傚彲浠ュ弬鑰冧緥紼嬩腑鐨凟ventExample.java銆傚畠閫氳繃瀹炵幇HSSFListener瀹屾垚浠庢櫘閫氭祦璁ょ煡Xls涓寘鍚殑鍐呭錛屽湪apache Cocoon涓殑org.apache.cocoon.serialization.HSSFSerializer涓敤鍒頒簡(jiǎn)榪欎釜瑙ｆ瀽銆傚洜涓篊ocoon2鏄熀浜庝簨浠剁殑錛屾墍浠OI涓轟簡(jiǎn)鎻愪緵蹇熺殑瑙ｆ瀽涔熸彁渚涗簡(jiǎn)鐩稿簲鐨勪簨浠躲傚綋鐒舵垜浠嚜宸變篃鍙互瀹炵幇榪欎釜浜嬩歡鎺ュ彛銆?nbsp;
鍥犱負(fù)POI榪樹笉鏄竴涓凍澶熸垚鐔熺殑欏圭洰錛屾墍浠ユ湁蹇呰鍋氳繘涓姝ョ殑寮鍙戝拰嫻嬭瘯銆備絾鏄畠宸茬粡涓烘垜浠敤綰疛ava鎿嶄綔ole2瀵硅薄鎻愪緵浜?jiǎn)鍙兘锛岃屼笖鍏嬫湇浜?jiǎn)ole瀵硅薄璋冪敤鐨勭己闄鳳紝鎻愪緵浜?jiǎn)鏈嶅姟鍣ㄧ鐨凟xcel瑙ｅ喅鏂規(guī)銆?BR>
]]>