C#將DataGridView中的數(shù)據(jù)保存到CSV和Excel中

第C#將DataGridView中的數(shù)據(jù)保存到CSV和Excel中MessageBox.Show("沒有數(shù)據(jù)可導(dǎo)出!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);

returnfalse;

SaveFileDialogsaveFileDialog=newSaveFileDialog();

saveFileDialog.Filter="CSVfiles(*.csv)|*.csv";

saveFileDialog.FilterIndex=0;

saveFileDialog.RestoreDirectory=true;

saveFileDialog.CreatePrompt=true;

saveFileDialog.FileName=null;

saveFileDialog.Title="保存";

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

Streamstream=saveFileDialog.OpenFile();

StreamWritersw=newStreamWriter(stream,System.Text.Encoding.GetEncoding(-0));

stringstrLine="";

//表頭

for(inti=0;idataGridView.ColumnCount;i++)

if(i0)

strLine+=",";

strLine+=dataGridView.Columns[i].HeaderText;

strLine.Remove(strLine.Length-1);

sw.WriteLine(strLine);

strLine="";

//表的內(nèi)容

for(intj=0;jdataGridView.Rows.Count;j++)

strLine="";

intcolCount=dataGridView.Columns.Count;

for(intk=0;kcolCount;k++)

if(k0kcolCount)

strLine+=",";

if(dataGridView.Rows[j].Cells[k].Value==null)

strLine+="";

else

stringcell=dataGridView.Rows[j].Cells[k].Value.ToString().Trim();

//防止里面含有特殊符號

cell=cell.Replace("\"","\"\"");

//cell="\""+cell+"\"";//每個元素值用引號包括

strLine+=cell;

sw.WriteLine(strLine);

sw.Close();

stream.Close();

MessageBox.Show("數(shù)據(jù)被導(dǎo)出到："+saveFileDialog.FileName.ToString(),"導(dǎo)出完畢",MessageBoxButtons.OK,MessageBoxIcon.Information);

catch(Exceptionex)

MessageBox.Show(ex.Message,"導(dǎo)出錯誤",MessageBoxButtons.OK,MessageBoxIcon.Information);

returnfalse;

returntrue;

}

二、保存到Excel

publicstaticbooldataGridViewToExcel(DataGridViewdataGridView)

if(dataGridView.Rows.Count==0)

MessageBox.Show("沒有數(shù)據(jù)可導(dǎo)出!","提示",MessageBoxButtons.OK,MessageBoxIcon.Information);

returnfalse;

stringfileName="";

stringsaveFileName="";

SaveFileDialogsaveDialog=newSaveFileDialog();

saveDialog.DefaultExt="xlsx";

saveDialog.Filter="Excel文件|*.xlsx";

saveDialog.FileName=fileName;

saveDialog.ShowDialog();

saveFileName=saveDialog.FileName;

if(saveFileName.IndexOf(":")0)

returnfalse;//被點了取消

Microsoft.Office.Interop.Excel.ApplicationxlApp=newMicrosoft.Office.Interop.Excel.Application();

if(xlApp==null)

MessageBox.Show("無法創(chuàng)建Excel對象，您的電腦可能未安裝Excel");

returnfalse;

Microsoft.Office.Interop.Excel.Workbooksworkbooks=xlApp.Workbooks;

Microsoft.Office.Interop.Excel.Workbookworkbook=

workbooks.Add(Microsoft.Office.Interop.Excel.XlWBATemplate.xlWBATWorksheet);

Microsoft.Office.Interop.Excel.Worksheetworksheet=

(Microsoft.Office.Interop.Excel.Worksheet)workbook.Worksheets[1];//取得sheet1

//寫入標題

for(inti=0;idataGridView.ColumnCount;i++)

{worksheet.Cells[1,i+1]=dataGridView.Columns[i].HeaderText;}

//寫入數(shù)值

for(intr=0;rdataGridView.Rows.Count;r++)

for(inti=0;idataGridView.ColumnCount;i++)

worksheet.Cells[r+2,i+1]=dataGridView.Rows[r].Cells[i].Value;

System.Windows.Forms.Application.DoEvents();

worksheet.Columns.EntireColumn.AutoFit();//列寬自適應(yīng)

MessageBox.Show(fileName+"資料保存成功","提示",MessageBoxButtons.OK);

if(saveFileName!="")

workbook.Saved=true;

workbook.SaveCopyAs(saveFileName);//fileSaved=true;

catch(Exceptionex)

{//fileSaved=false;

MessageBox.Show("導(dǎo)出文件