C#中改变字体和DataGridView中的数据导出的方法

C#中改变dgv中的字体很简单的，只需要一个简单的方法，就OK了

View Code

 1  //改变字体
 2          private void btnFont_Click(object sender, EventArgs e)
 3         {
 4             try
 5             {
 6                 FontDialog fontDialog = new FontDialog();
 7                 fontDialog.Color = dgvHistroy.RowTemplate.DefaultCellStyle.ForeColor;
 8                 fontDialog.Font = dgvHistroy.RowTemplate.DefaultCellStyle.Font;
 9                 fontDialog.AllowScriptChange = true;
10                 if (fontDialog.ShowDialog() != DialogResult.Cancel)
11                 {
12                     dgvHistroy.RowTemplate.DefaultCellStyle.Font = fontDialog.Font;//将当前选定的文字改变字体
13                  }
14                 DataTable ds = (DataTable)dgvHistroy.DataSource;
15                 dgvHistroy.DataSource = null;
16                 dgvHistroy.DataSource = ds;
17                 ds.Dispose();
18             }

另外再导出dgv中的数据也是如此，暂且放在这里，以后用了会很方便的，呵呵

View Code

 1 /// <summary>   
 2         /// 将 DataGridView的数据导出Excel
 3         /// </summary>   
 4         /// <remarks>   
 5         /// using System.IO;   
 6         /// </remarks>   
 7         /// <param name="dgv"></param>   
 8          public static void DataGridViewToExcel(bxyztSkin.Editors.CDataGridView dgv)
 9         {
10 
11             SaveFileDialog dlg = new SaveFileDialog();
12             dlg.Filter = "Execl files (*.xls)|*.xls";
13             dlg.CheckFileExists = false;
14             dlg.CheckPathExists = false;
15             dlg.FilterIndex = 0;
16             dlg.RestoreDirectory = true;
17             dlg.CreatePrompt = false;
18             dlg.Title = "保存为Excel文件";
19             dlg.FileName = DateTime.Now.Ticks.ToString().Trim();
20 
21             if (dlg.ShowDialog() == DialogResult.OK)
22             {
23                 Stream myStream;
24                 myStream = dlg.OpenFile();
25                 StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));
26                 string columnTitle = "";
27                 try
28                 {
29                     //写入列标题   
30                      for (int i = 0; i < dgv.ColumnCount; i++)
31                     {
32                         if (i > 0)
33                         {
34                             columnTitle += "\t";
35                         }
36                         columnTitle += dgv.Columns[i].HeaderText;
37                     }
38                     sw.WriteLine(columnTitle);
39 
40                     //写入列内容   
41                     for (int j = 0; j < dgv.Rows.Count; j++)
42                     {
43                         string columnValue = "";
44                         for (int k = 0; k < dgv.Columns.Count; k++)
45                         {
46                             if (k > 0)
47                             {
48                                 columnValue += "\t";
49                             }
50                             if (dgv.Rows[j].Cells[k].Value == null)
51                                 columnValue += "";
52                             else
53                                 columnValue += dgv.Rows[j].Cells[k].Value.ToString().Trim();
54                         }
55                         sw.WriteLine(columnValue);
56                     }
57                     sw.Close();
58                     myStream.Close();
59                 }
60                 catch (Exception e)
61                 {
62                     MessageBox.Show(e.ToString());
63                 }
64                 finally
65                 {
66                     sw.Close();
67                     myStream.Close();
68                 }
69             }
70         }