如何在excel中导出extjs网格值 [英] How to export extjs grid value in excel

问题描述

在Extjs中我在Extgrid中使用渲染

假设我在网格中显示员工记录

Sql字段是：

[name]类型varchar，

[性别]类型位（女性为0，男性为1）



我在网格中显示男性/女性（0/1）。它运作良好。问题是，当我在excel中导出这些数据时，它在性别栏中显示（0和1）。

如何显示（男/女）而不是（0和1）



我想在Excel文件中输出这种类型

In Extjs I am using rendering in Extgrid
Suppose I am displaying employee record in grid
Sql Fields are :
[name] type varchar,
[gender] type bit (0 for female and 1 for male)

I am showing male/female in grid not(0/1). It's working good. Problem is that when I am exporting this data in excel it's showing (0 and 1) in gender column.
How to show (male /female) instead of (0 and 1)

I want this type of Output In Excel File

|Name||Gender|	  
|----||------|	
| XX ||Female| 	
| XX ||Female| 	
| XX ||Female| 	
| XX ||Male  | 	
| XX ||Male  | 	
| XX ||Male  |	

但输出看起来像

But Output Looking Like that

|Name||Gender|	  
|----||------|	
| XX ||  0   | 	
| XX ||  0   | 	
| XX ||  0   | 	
| XX ||  1   | 	
| XX ||  1   | 	
| XX ||  1   |	

我该怎么办请帮助我

提前谢谢



我尝试过：

What Should I do please help me
Thanks In advance

What I have tried:

{ header: 'name', dataIndex: 'Name', width: 180, type: 'String'},
{ header: 'Gender', dataIndex: 'Gender', width: 180, type: 'String', renderer: this.eventTypeRenderer }

eventTypeRenderer: function (value, model, record) {
        return value ? "Male" : "Female";
	},

推荐答案

您应通过将位值转换为男/女值来更改输入json源。

You shall change the input json source by converting the bit value to the Male/Female Value.

var input = [{ Name: 'xx', Gender: 0 },
       { Name: 'xx', Gender: 0 },
       { Name: 'xx', Gender: 0 },
       { Name: 'xx', Gender: 1 },
       { Name: 'xx', Gender: 1 },
       { Name: 'xx', Gender: 1 }];

       for (var i = 0; i < input.length; i++) {
           input[i].GenderValue = input[i].Gender ? "Male" : "Female";
       }

和标题配置为

and the header config as

{ header: 'Gender', dataIndex: 'GenderValue', width: 180, type: 'String'},

这篇关于如何在excel中导出extjs网格值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！