public void writeexcel (Dataset ds, string path) { try { SaveFileDialog saveFileDialog = new SaveFileDialog (); saveFileDialog.Filter = "execl files (*.xls) |*.xls"; savefiledialog.filterindex = 0; savefiledialog.restoredirectory = true; savefiledialog.createprompt = false; saveFileDialog.Title = "Export Excel file to"; saveFileDialog.FileName = path; if (Savefiledialog.showdialog () == dialogresult.ok) { Stream myStream; mystream = savefiledialog.openfile (); &nbsP; streamwriter sw = new streamwriter (myStream, Encoding.GetEncoding ("gb2312")); stringbuilder sb = new stringbuilder (); for (Int k = 0; k < ds. Tables[0]. columns.count; k++) { &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;SB. Append (ds. Tables[0]. COLUMNS[K]. Columnname.tostring () + "\ T"); } &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;SB. Append (Environment.NewLine); for (Int i = 0; i < ds. Tables[0]. rows.count; i++) { for (int j = 0; j < ds. Tables[0]. columns.count; j++) { &NBSP;&NBSP;&NBSP;&NBSP;SB. Append (ds. Tables[0]. ROWS[I][J]. ToString () + "\ T"); } &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;SB. Append (Environment.NewLine);//Line wrapping after each line of data } &NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;&NBSP;SW. Write (sb.) ToString ()); &NBSP;&NBSP;&NBSP;&NBSP;SW. Flush (); &NBSP;&NBSP;&NBSP;SW. Close ();//Release Resources &Nbsp; killspecialexcel (); MessageBox.Show ("The specified Excel file has been generated!"); } } catch (Exception ex) { messagebox.show (ex. Message); } }
StreamWriter (DataSet) export Excel