字符串Ｔo Excel

  public   void  ExportToExcel( string  fPath,  string  strBuffer) 
         ... { 
            string filePath="c:/"+fPath+".xls";
            object oMissing = System.Reflection.Missing.Value; 
            Excel.ApplicationClass xlApp = new Excel.ApplicationClass(); 
            try 
            ...{ 
                //新建一个excel表
                Excel.Application exc =new Excel.ApplicationClass();
                exc.Application.Workbooks.Add ( true ) ;
                exc.ActiveWorkbook.SaveAs(filePath, 
                    Excel.XlFileFormat.xlWorkbookNormal, Type.Missing, 
                    Type.Missing, Type.Missing, Type.Missing, 
                    Excel.XlSaveAsAccessMode.xlNoChange, Type.Missing, 
                    Type.Missing, Type.Missing, Type.Missing, Type.Missing); 
                exc.Quit();
                System.Runtime.InteropServices.Marshal.ReleaseComObject(exc); 
                exc = null; 

                // 打开Excel文件。以下为Office 2000. 
                Excel.Workbook xlWorkbook = xlApp.Workbooks.Open(filePath, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing, oMissing); 
                Excel.Worksheet xlWorksheet; 
                // 添加入一个新的Sheet页。 
                xlWorksheet = (Excel.Worksheet)xlWorkbook.Worksheets.Add(oMissing,oMissing,1,oMissing); 
                // 作为新加的Sheet页名。 
                xlWorksheet.Name = fPath; 
                // 利用系统剪切板 
                System.Windows.Forms.Clipboard.SetDataObject(""); 
                // 将stringBuffer放入剪切板。 
                System.Windows.Forms.Clipboard.SetDataObject(strBuffer); 
                // 选中这个sheet页中的第一个单元格 
                ((Excel.Range)xlWorksheet.Cells[1,1]).Select(); 
                // 粘贴！ 
                xlWorksheet.Paste(oMissing,oMissing); 
                // 清空系统剪切板。 
                System.Windows.Forms.Clipboard.SetDataObject(""); 
                // 保存并关闭这个工作簿。 
                xlWorkbook.Close( Excel.XlSaveAction.xlSaveChanges, oMissing, oMissing );   
                System.Runtime.InteropServices.Marshal.ReleaseComObject(xlWorkbook); 
                xlWorkbook = null; 
            } 
            catch(Exception ex) 
            ...{ 
                MessageBox.Show(ex.Message); 
            } 
            finally 
            ...{ 
                // 释放... 
                xlApp.Quit(); 
                System.Runtime.InteropServices.Marshal.ReleaseComObject(xlApp); 
                xlApp = null; 
                GC.Collect(); 
            } 
        }  

 

string strBuffer="服务站/t月租(30)/t月租(50)/t月租(60)/t月租(100)/t月租(折扣)/t免费/t/n"+insValue;