导出Execl

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88

public static void ExportExcelFile(DevExpress.Xpf.Grid.TableView tableView)         {             if (tableView == null)             {                 MessageBox.Show("导出失败!", "错误提示", MessageBoxButton.OK, MessageBoxImage.Error);                 return;             }               SaveFileDialog saveFileDialog = new SaveFileDialog();             saveFileDialog.InitialDirectory = "c:\\";             saveFileDialog.Filter = "Excel(*.xls)|*.xls|Excel2007(*.xlsx)|*.xlsx";             saveFileDialog.RestoreDirectory = true;             saveFileDialog.FilterIndex = 1;             bool? result = saveFileDialog.ShowDialog();             if (result == true)             {                 string filename = saveFileDialog.FileName;                 int index = filename.IndexOf(".");                 string suffix = filename.Substring(index + 1);                 if (suffix == "xls")                 {                     tableView.ExportToXls(filename);                 }                 else                 {                     tableView.ExportToXlsx(filename);                 }                   MessageBox.Show("导出成功!", "信息提示", MessageBoxButton.OK, MessageBoxImage.Information);             }         }           public static void ExportExcelFile(DataTable dt)         {             if (dt == null) return;                             //gridControl.View.ExportToXlsx()               SaveFileDialog saveFileDialog = new SaveFileDialog();             saveFileDialog.InitialDirectory = "c:\\";             saveFileDialog.Filter = "Excel(*.xls)|*.xls|Excel2007(*.xlsx)|*.xlsx";             saveFileDialog.RestoreDirectory = true;             saveFileDialog.FilterIndex = 1;             bool? result = saveFileDialog.ShowDialog();             if (result == true)             {                                     string filename = saveFileDialog.FileName;                 //int index = filename.IndexOf(".");                 //string suffix = filename.Substring(index + 1);                   Workbook workbook = new Workbook();                 //清除页先 要不然 新建就有一个sheet                 workbook.Worksheets.Clear();                 workbook.Worksheets.Add(dt.TableName);                 Worksheet sheet = workbook.Worksheets[0];                 Cells cells = sheet.Cells;  //单元格                   int colnum = dt.Columns.Count;      //表格列数                 int rownum = dt.Rows.Count;         //表格行数                   //for (int x = 0; x < colnum; x++)                 //{                 //    cells[0, x].PutValue(dt.Columns[x].ColumnName);                 //}                 for (int x = 0; x < rownum; x++)                 {                     for (int y = 0; y < colnum; y++)                     {                         if (x == 0)                             cells[x, y].PutValue(dt.Columns[y].ColumnName);                                                   cells[x + 1, y].PutValue(dt.Rows[x][y].TrimOrNull());                     }                 }                   SetColumnWithAuto(sheet);                 workbook.Save(filename);                   MessageBox.Show("导出成功!", "信息提示", MessageBoxButton.OK, MessageBoxImage.Information);             }                           dt.Clear();             dt.Dispose();             dt = null;         }