C#中将DataGridView中数据导出至Excel

来源：互联网发布：海康网络摄像机电路图编辑：程序博客网时间：2024/04/30 13:11
        public DataGridView _DataGridView=null;        public void put(DataGridView _DataGridView)        {            SaveFileDialog saveFileDialog = new SaveFileDialog();            saveFileDialog.Filter = "Execl files (*.xls)|*.xls";            saveFileDialog.FilterIndex = 0;            saveFileDialog.RestoreDirectory = true;            saveFileDialog.CreatePrompt = true;            saveFileDialog.Title = "**数据";            saveFileDialog.ShowDialog();            if (saveFileDialog.FileName == "")                return;            Stream myStream;            myStream = saveFileDialog.OpenFile();            StreamWriter sw = new StreamWriter(myStream, System.Text.Encoding.GetEncoding(-0));             string str = "";            try            {                for (int i = 0; i < _DataGridView.ColumnCount; i++)                {                    if (i > 0)                    {                        str += "\t";                    }                    str += _DataGridView.Columns[i].HeaderText;                }                sw.WriteLine(str);                for (int j = 0; j < _DataGridView.Rows.Count; j++)                {                    string tempStr = "";                    for (int k = 0; k < _DataGridView.Columns.Count; k++)                    {                        if (k > 0)                        {                            tempStr += "\t";                        }                        tempStr += _DataGridView.Rows[j].Cells[k].Value.ToString();                    }                    sw.WriteLine(tempStr);                }                sw.Close();                myStream.Close();            }             catch (Exception ex)            {                MessageBox.Show(ex.ToString());            }            finally            {                sw.Close();                myStream.Close();                if (MessageBox.Show("导出成功!你想打开这个文件吗?", "导出到...", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.Yes)                {                    try                    {                        System.Diagnostics.Process process = new System.Diagnostics.Process();                        process.StartInfo.FileName = saveFileDialog.FileName;                        process.StartInfo.Verb = "Open";                        process.StartInfo.WindowStyle = System.Diagnostics.ProcessWindowStyle.Normal;                        process.Start();                    }                    catch                    {                        MessageBox.Show("你的计算机中未安装Excel,不能打开该文档!");                    }                }