GridView查询结果如excel

        this.gridView1.OptionsCustomization.AllowQuickHideColumns = false;//禁止列隐藏 
        this.efDevGrid1.ShowSelectionColumn = true;               //设置选择是否可见 
        this.efDevGrid1.ShowContextMenu = true;                   //设置右键菜单是否显示
        this.efDevGrid1.ShowContextMenuAddCopyNew = false;
        this.efDevGrid1.ShowContextMenuAddNew = false;
        this.efDevGrid1.ShowContextMenuAddCopyNew = false;       //右键复制新增
        this.efDevGrid1.ShowContextMenuAddNew = false;           //右键新增
        this.efDevGrid1.ContextMenuChooseAllEnable = true;        //右键全选
        this.efDevGrid1.ContextMenuChooseEnable = true;           //右键单选
        this.efDevGrid1.ContextMenuSaveAsEnable = true;           //右键另存为
        this.efDevGrid1.ContextMenuUnChooseAllEnable = true;      //右键全不选
        this.efDevGrid1.ContextMenuUnChooseEnable = true;         //右键不选

        this.efDevGrid1.IsUseCustomPageBar = true;                //设置分页条工具栏是否显示
        this.efDevGrid1.ShowPageButton = true;                    //翻页按钮是否显示
        this.efDevGrid1.NextPageButtonEnable = false;             //初始化时下一页按钮不可用
        this.efDevGrid1.PrePageButtonEnable = false;              //初始化时上一页按钮不可用
        this.efDevGrid1.FirstPageButtonEnable = false;            //初始化时首页按钮不可用
        this.efDevGrid1.LastPageButtonEnable = false;             //初始化时翻尾页按钮不可用
        this.efDevGrid1.ShowAddCopyRowButton = false;              //复制新增按钮
        this.efDevGrid1.ShowAddRowButton = false;                  //新增按钮
        this.efDevGrid1.ShowFilterButton = true;                  //过滤行按钮
        this.efDevGrid1.ShowGroupButton = true;                   //分组按钮


        this.efDevGrid1.EFMultiSelect = true;
        gridView1.OptionsSelection.MultiSelectMode =     DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CellSelect;

        
        GC.PM_utility2.DEV_Init_LayoutGroup_where_size(layoutControlGroup2, this.efDevGrid2);