用户操作
[留言]  [发消息]  [加为好友] 
订阅我的博客
XML聚合    FeedSky
订阅到鲜果
订阅到Google
订阅到抓虾
ejunnet的公告
<script type="text/javascript"><!-- google_ad_client = "pub-5804414361724728"; //160x600, 创建于 07-12-15 google_ad_slot = "0605332833"; google_ad_width = 160; google_ad_height = 600; //--></script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
文章分类
友情联接
存档

原创  GWT 调用本地js 导出excel 收藏

    刚做的用GWT调用本地js导出excel ， 导出的excel有点难看， 但总比没有导出功能好！

 

    第一步： 编写本地js放到public/js/file/FileExport.js目录下：

  1.  //导入Excel
  2.  function ExportToExcel(element) 
  3.  {
  4.   var oXL = new ActiveXObject("Excel.Application"); 
  5.   var oWB = oXL.Workbooks.Add(); 
  6.   var oSheet = oWB.ActiveSheet;  
  7.   var sel=document.body.createTextRange();
  8.   sel.moveToElementText(element);
  9.   sel.select();
  10.   sel.execCommand("Copy");
  11.   oSheet.Paste();
  12.   oXL.Visible = true;
  13.  }
  15.  //导入Word
  16.  function ExportToWord(element)
  17.  {
  18.   var oWD = new ActiveXObject("Word.Application");
  19.   var oDC = oWD.Documents.Add("",0,1);
  20.   var oRange =oDC.Range(0,1);
  21.   var sel = document.body.createTextRange();
  22.   sel.moveToElementText(element);
  23.   sel.select();
  24.   sel.execCommand("Copy");
  25.   oRange.Paste();
  26.   oWD.Application.Visible = true;
  27.  }

   第二步： 编写JSNI实现类来调用js

  1. package com.gogocode.bi.client;
  3. import com.google.gwt.user.client.Element;
  4. /**
  5.  * JSNI实现类调用js 
  6.  * @author 赵昌峻
  7.  *
  8.  */
  9. public class FileExport {
  10.     public static native void ExportToExcel(Element element) /*-{
  11.       $wnd.ExportToExcel(element);
  12.     }-*/;
  13.     
  14.     public static native void ExportToWord(Element element) /*-{
  15.       $wnd.ExportToWord(element);
  16.     }-*/;
  17. }

第三步： 在程序中调用JSNI实现类

  1. package com.gogocode.bi.client;
  3. import com.google.gwt.core.client.EntryPoint;
  4. import com.google.gwt.user.client.DOM;
  5. import com.google.gwt.user.client.ui.RootPanel;
  6. import com.gwtext.client.core.EventObject;
  7. import com.gwtext.client.data.ArrayReader;
  8. import com.gwtext.client.data.DateFieldDef;
  9. import com.gwtext.client.data.FieldDef;
  10. import com.gwtext.client.data.FloatFieldDef;
  11. import com.gwtext.client.data.MemoryProxy;
  12. import com.gwtext.client.data.RecordDef;
  13. import com.gwtext.client.data.Store;
  14. import com.gwtext.client.data.StringFieldDef;
  15. import com.gwtext.client.widgets.Button;
  16. import com.gwtext.client.widgets.Panel;
  17. import com.gwtext.client.widgets.Toolbar;
  18. import com.gwtext.client.widgets.ToolbarButton;
  19. import com.gwtext.client.widgets.event.ButtonListenerAdapter;
  20. import com.gwtext.client.widgets.grid.ColumnConfig;
  21. import com.gwtext.client.widgets.grid.ColumnModel;
  22. import com.gwtext.client.widgets.grid.GridPanel;
  23. /**
  24.  * GWT 调用本地js 导出excel 示例程序
  25.  * @author 赵昌峻
  26.  *
  27.  */
  29. public class BI_Enter implements EntryPoint {
  31.     public void onModuleLoad() {   
  32.         Panel panel = new Panel();   
  33.         panel.setBorder(false);   
  34.         panel.setPaddings(15);   
  35.   
  36.         RecordDef recordDef = new RecordDef(   
  37.                 new FieldDef[]{   
  38.                         new StringFieldDef("company"),   
  39.                         new FloatFieldDef("price"),   
  40.                         new FloatFieldDef("change"),   
  41.                         new FloatFieldDef("pctChange"),   
  42.                         new DateFieldDef("lastChanged", "n/j h:ia"),   
  43.                         new StringFieldDef("symbol"),   
  44.                         new StringFieldDef("industry")   
  45.                 }   
  46.         );   
  47.   
  48.         final GridPanel grid = new GridPanel();   
  49.         grid.setId("grid"); //给要导出的表格一个维一的ID
  50.   
  51.         Object[][] data = getCompanyData();   
  52.         MemoryProxy proxy = new MemoryProxy(data);   
  53.   
  54.         ArrayReader reader = new ArrayReader(recordDef);   
  55.         Store store = new Store(proxy, reader);   
  56.         store.load();   
  57.         grid.setStore(store);   
  58.   
  59.   
  60.         ColumnConfig[] columns = new ColumnConfig[]{   
  61.                 new ColumnConfig("股票", "company", 130, true, null, "company"),   
  62.                 new ColumnConfig("价格", "price", 35),   
  63.                 new ColumnConfig("涨跌", "change", 45),   
  64.                 new ColumnConfig("涨幅", "pctChange", 65),   
  65.                 new ColumnConfig("最后更新时间", "lastChanged", 100)
  66.         };   
  67.   
  68.         ColumnModel columnModel = new ColumnModel(columns);   
  69.         grid.setColumnModel(columnModel);   
  70.   
  71.         grid.setFrame(true);   
  72.         grid.setStripeRows(true);   
  73.         grid.setAutoExpandColumn("company");   
  74.   
  75.         grid.setHeight(350);   
  76.         grid.setWidth(600);   
  77.         grid.setTitle("今日股市情况");   
  78.   
  79.         Toolbar bottomToolbar = new Toolbar();   
  80.         bottomToolbar.addFill();   
  81.         bottomToolbar.addButton(new ToolbarButton("导出到Excel", new ButtonListenerAdapter() {   
  82.             public void onClick(Button button, EventObject e) {
  83.                 FileExport.ExportToExcel(DOM.getElementById("grid"));  //调用本地js导出excel
  84.                 grid.clearSortState(true);   
  85.             }   
  86.         }));   
  87.         grid.setBottomToolbar(bottomToolbar);   
  88.   
  89.         panel.add(grid);   
  90.   
  91.         RootPanel.get().add(panel);   
  92.     }   
  93.     
  94.     /**
  95.      * 得到测试数据
  96.      * @return
  97.      */
  98.     private Object[][] getCompanyData() {   
  99.         return new Object[][]{   
  100.                 new Object[]{"Google", new Double(71.72), new Double(0.02),   
  101.                         new Double(0.03), "9/1 12:00am", "MMM", "Manufacturing"},   
  102.                 new Object[]{"Alcoa Inc", new Double(29.01), new Double(0.42),   
  103.                         new Double(1.47), "9/1 12:00am", "AA", "Manufacturing"},   
  104.                 new Object[]{"Altria Group Inc", new Double(83.81), new Double(0.28),   
  105.                         new Double(0.34), "9/1 12:00am", "MO", "Manufacturing"},   
  106.                 new Object[]{"American Express Company", new Double(52.55), new Double(0.01),   
  107.                         new Double(0.02), "9/1 12:00am", "AXP", "Finance"},   
  108.                 new Object[]{"American International Group, Inc.", new Double(64.13), new Double(0.31),   
  109.                         new Double(0.49), "9/1 12:00am", "AIG", "Services"},   
  110.                 new Object[]{"AT&T Inc.", new Double(31.61), new Double(-0.48),   
  111.                         new Double(-1.54), "9/1 12:00am", "T", "Services"},   
  112.                 new Object[]{"Boeing Co.", new Double(75.43), new Double(0.53),   
  113.                         new Double(0.71), "9/1 12:00am", "BA", "Manufacturing"},   
  114.                 new Object[]{"Caterpillar Inc.", new Double(67.27), new Double(0.92),   
  115.                         new Double(1.39), "9/1 12:00am", "CAT", "Services"},   
  116.                 new Object[]{"Yahoo", new Double(49.37), new Double(0.02),   
  117.                         new Double(0.04), "9/1 12:00am", "C", "Finance"},   
  118.                 new Object[]{"E.I. du Pont de Nemours and Company", new Double(40.48), new Double(0.51),   
  119.                         new Double(1.28), "9/1 12:00am", "DD", "Manufacturing"}   
  120.         };   
  121.     }   
  122. }

最终效果如下图所示：

 

说明： 代码中用到了GWT-EXT，项目主页：http://gwt-ext.com/

 

转载请注明出处和作者信息

 

发表于 @ 2008年08月27日　15:23:00 | 评论( loading... ) | 编辑| 举报| 收藏

旧一篇:简简单单实现Ajax | 新一篇:Ejunnet博客搬家公告
查看最新精华文章 请访问博客首页相关文章
  • 发表评论
  • 评论内容：
  •  
Copyright © ejunnet
Powered by CSDN Blog