Ext的grid如何导出excel？？？？

解决方案 »

免费领取超大流量手机卡，每月29元包185G流量+100分钟通话, 中国电信官方发货

createWorksheet: function(includeHidden) {
// Calculate cell data types and extra class names which affect formatting
        var cellType = [];
        var cellTypeClass = [];
        var cm = this.getColumnModel();
        var totalWidthInPixels = 0;
        var colXml = **;
        var headerXml = **;
        var visibleColumnCountReduction = 0;
        for (var i = 0; i < cm.getColumnCount(); i++) {
            if (includeHidden || !cm.isHidden(i)) {
                var w = cm.getColumnWidth(i)
                totalWidthInPixels += w;
                if (cm.getColumnHeader(i) === ""){
                 cellType.push("None");
                 cellTypeClass.push("");
                 ++visibleColumnCountReduction;
                }
                else
                {
                 colXml += *<ss:Column ss:AutoFitWidth="1" ss:Width="* + w + *" />*;
                 headerXml += *<ss:Cell ss:StyleID="headercell">* +
                     *<ss:Data ss:Type="String">* + cm.getColumnHeader(i) + *</ss:Data>* +
                     *<ss:NamedCell ss:Name="Print_Titles" /></ss:Cell>*;
                 var fld = this.store.recordType.prototype.fields.get(cm.getDataIndex(i));
                 switch(fld.type) {
                     case "int":
                         cellType.push("Number");
                         cellTypeClass.push("int");
                         break;
                     case "float":
                         cellType.push("Number");
                         cellTypeClass.push("float");
                         break;
                     case "bool":
                     case "boolean":
                         cellType.push("String");
                         cellTypeClass.push("");
                         break;
                     case "date":
                         cellType.push("DateTime");
                         cellTypeClass.push("date");
                         break;
                     default:
                         cellType.push("String");
                         cellTypeClass.push("");
                         break;
                 }
                }
            }
        }
        var visibleColumnCount = cellType.length - visibleColumnCountReduction;        var result = {
            height: 9000,
            width: Math.floor(totalWidthInPixels * 30) + 50
        }; // Generate worksheet header details.
        var t = *<ss:Worksheet ss:Name="* + this.title + *">* +
            *<ss:Names>* +
                *<ss:NamedRange ss:Name="Print_Titles" ss:RefersTo="=\** + this.title + *\*!R1:R2" />* +
            *</ss:Names>* +
            *<ss:Table x:FullRows="1" x:FullColumns="1"* +
                * ss:ExpandedColumnCount="* + visibleColumnCount +
                *" ss:ExpandedRowCount="* + (this.store.getCount() + 2) + *">* +
                colXml +
                *<ss:Row ss:Height="38">* +
                    *<ss:Cell ss:StyleID="title" ss:MergeAcross="* + (visibleColumnCount - 1) + *">* +
                      *<ss:Data xmlns:html="http://www.w3.org/TR/REC-html40" ss:Type="String">* +
                        *<html:B>Generated by ExtJS</html:B></ss:Data><ss:NamedCell ss:Name="Print_Titles" />* +
                    *</ss:Cell>* +
                *</ss:Row>* +
                *<ss:Row ss:AutoFitHeight="1">* +
                headerXml +
                *</ss:Row>*; // Generate the data rows from the data in the Store
        for (var i = 0, it = this.store.data.items, l = it.length; i < l; i++) {
            t += *<ss:Row>*;
            var cellClass = (i & 1) ? *odd* : *even*;
            r = it[i].data;
            var k = 0;
            for (var j = 0; j < cm.getColumnCount(); j++) {
                if (includeHidden || !cm.isHidden(j)) {
                    var v = r[cm.getDataIndex(j)];
                    if (cellType[k] !== "None") {                     t += *<ss:Cell ss:StyleID="* + cellClass + cellTypeClass[k] + *"><ss:Data ss:Type="* + cellType[k] + *">*;
                         if (cellType[k] == *DateTime*) {
                             t += v.format(*Y-m-d*);
                         } else {
                             t += v;
                         }
                     t +=*</ss:Data></ss:Cell>*;
                    }
                    k++;
                }
            }
            t += *</ss:Row>*;
        }        result.xml = t + *</ss:Table>* +
            *<x:WorksheetOptions>* +
                *<x:PageSetup>* +
                    *<x:Layout x:CenterHorizontal="1" x:Orientation="Landscape" />* +
                    *<x:Footer x:Data="Page &P of &N" x:Margin="0.5" />* +
                    *<x:PageMargins x:Top="0.5" x:Right="0.5" x:Left="0.5" x:Bottom="0.8" />* +
                *</x:PageSetup>* +
                *<x:FitToPage />* +
                *<x:Print>* +
                    *<x:PrintErrors>Blank</x:PrintErrors>* +
                    *<x:FitWidth>1</x:FitWidth>* +
                    *<x:FitHeight>32767</x:FitHeight>* +
                    *<x:ValidPrinterInfo />* +
                    *<x:VerticalResolution>600</x:VerticalResolution>* +
                *</x:Print>* +
                *<x:Selected />* +
                *<x:DoNotDisplayGridlines />* +
                *<x:ProtectObjects>False</x:ProtectObjects>* +
                *<x:ProtectScenarios>False</x:ProtectScenarios>* +
            *</x:WorksheetOptions>* +
        *</ss:Worksheet>*;
        return result;
    }
});
我觉得可以考虑用javascript调用Excel组件来实现
function CellAreaExcel()
{
  var oXL = new ActiveXObject("Excel.Application");
  var oWB = oXL.Workbooks.Add();
  var oSheet = oWB.ActiveSheet;
  var Lenr = PrintA.rows.length;
  for (i=0;i<Lenr;i++)
  {
   var Lenc = PrintA.rows(i).cells.length;
   for (j=0;j<Lenc;j++)
   {
    oSheet.Cells(i+1,j+1).value = PrintA.rows(i).cells(j).innerText;
   }
  }
  oXL.Visible = true;
}//指定页面区域
通过 Grid 的 record 得到数据的 id 编号，从数据库将数据查询出来在使用 jxl 插入到数据库，即快又安全，不要考虑用 Ext 导入 Excel ，想想 js 代码要操作客户端的文件那要涉及到很大的访问权限了。我的意思就是通过要导入的数据将这些数据获取这些数据的 id 编号，传入后台，在后台从数据库查询出来在导入到 Excel 中，我就是这样做的。