Winform技巧：TreeView导入Excel

 1 
using System; 


 2 
using System.Collections.Generic; 


 3 
using System.ComponentModel; 


 4 
using System.Data; 


 5 
using System.Drawing; 


 6 
using System.Text; 


 7 
using System.Windows.Forms; 


 8 
using System.IO; 


 9    


10 
namespace 教务管理系统 


11 { 


12         
class DGVToExcel 


13         { 


14                 
public 
void SaveAs(DataTable dt) 
//另存新档按钮     导出成Excel 


15                 { 


16                         
try 


17                         { 


18                                 SaveFileDialog saveFileDialog = 
new SaveFileDialog(); 


19                                 saveFileDialog.Filter = 
“Execl files (*.xls)|*.xls”; 


20                                 saveFileDialog.FilterIndex = 0; 


21                                 saveFileDialog.RestoreDirectory = 
true; 


22                                 saveFileDialog.CreatePrompt = 
true; 


23                                 saveFileDialog.Title = 
“导出Excel到”; 


24                                 
if(saveFileDialog.ShowDialog()==DialogResult.OK) 


25                                 { 


26                                 Stream myStream; 


27                                 myStream = saveFileDialog.OpenFile(); 


28                                 StreamWriter sw = 
new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0)); 


29                                 
string str = “”; 


30                                 
try 


31                                 { 


32                                         
//写标题 


33                                        


34                                                 str +=dt.TableName; 


35                                         sw.WriteLine(str); 


36                                         
//写内容 


37                                         
for (
int j = 0; j < dt.Rows.Count; j++) 


38                                         { 


39                                                 
string tempStr = “”; 


40                                                 
for (
int k = 0; k < dt.Columns.Count; k++) 


41                                                 { 


42                                                         
if (k > 0) 


43                                                         { 


44                                                                 tempStr += 
“\t”; 


45                                                         } 


46                                                         tempStr += dt.Rows[j][k].ToString(); 


47                                                 } 


48                                                 sw.WriteLine(tempStr); 


49                                         } 


50                                         sw.Close(); 


51                                         myStream.Close(); 


52                                 } 


53                                 
catch 


54                                 { 


55    


56                                 } 


57                                 
finally 


58                                 { 


59                                         sw.Close(); 


60                                         myStream.Close(); 


61                                 } 


62                                 } 


63                         } 


64                         
catch 


65                         { } 


66                 }            


67    


68         } 


69 } 


70