Fine UI 中Grid导出真实Excel文件

来源：互联网发布：网络专业大学排名编辑：程序博客网时间：2024/05/19 17:08
此方法并不是写Html代码生成伪Excel文件，添加引用 using Microsoft.Office.Interop.Excel;
 /// <summary>        /// 导出Grid数据到excel        /// </summary>        /// <param name="gridView"></param>        private void ExportToExcel(Grid gridView)        {            if(gridView.Rows.Count == 0)            {                Alert.Show("No data");                return;            }            //First fetch all records from grid to dataset            DataSet dset = new DataSet();            dset.Tables.Add();            //First Add Columns from gridview to excel            for (int i = 0; i < columns.Length; i++) //GridView is id of gridview            {                dset.Tables[0].Columns.Add(columns[i]);            }            //add rows to the table             System.Data.DataRow dr1;            for (int i = 0; i < gridView.Rows.Count; i++)            {                dr1 = dset.Tables[0].NewRow();                string PortName = gridView.Rows[i].Values[1].ToString();                string BitHi = gridView.Rows[i].Values[2].ToString();                string BitLow = gridView.Rows[i].Values[3].ToString();                string Direction = gridView.Rows[i].Values[4].ToString();                string GroupName = gridView.Rows[i].Values[5].ToString();                string AliasInGroup = gridView.Rows[i].Values[6].ToString();                dr1[0] = PortName;                dr1[1] = BitHi;                dr1[2] = BitLow;                dr1[3] = Direction;                dr1[4] = GroupName;                dr1[5] = AliasInGroup;                dset.Tables[0].Rows.Add(dr1);            }            //below code is export dset to excel            Application excel = new Application();            Workbook wBook;            Worksheet wSheet;            wBook = excel.Workbooks.Add(System.Reflection.Missing.Value);            wSheet = (Worksheet)wBook.ActiveSheet;            System.Data.DataTable dt = dset.Tables[0];            System.Data.DataColumn dc = new DataColumn();            int colIndex = 0;            int rowIndex = 0;            foreach (DataColumn dcol in dt.Columns)            {                colIndex = colIndex + 1;                excel.Cells[1, colIndex] = dcol.ColumnName;            }            foreach (DataRow drow in dt.Rows)            {                rowIndex = rowIndex + 1;                colIndex = 0;                foreach (DataColumn dcol in dt.Columns)                {                    colIndex = colIndex + 1;                    excel.Cells[rowIndex + 1, colIndex] = drow[dcol.ColumnName];                }            }            wSheet.Columns.AutoFit();            String strFileName ="d:\\importExcel.xls"; //  File Path Where you want to save excel file.            Boolean blnFileOpen = false;            try            {                System.IO.FileStream fileTemp = File.OpenWrite(strFileName);                fileTemp.Close();            }            catch            {                blnFileOpen = false;            }            if (System.IO.File.Exists(strFileName)) //It checks if file exists then it delete that file.            {                System.IO.File.Delete(strFileName);            }            wBook.SaveAs(strFileName, XlFileFormat.xlExcel12, System.Reflection.Missing.Value, System.Reflection.Missing.Value                , false, false, XlSaveAsAccessMode.xlShared, XlSaveConflictResolution.xlLocalSessionChanges, false, System.Reflection.Missing.Value,                System.Reflection.Missing.Value, false);            Alert.Show("File has been saved in " + strFileName);        }
0 0