C#生成Excel文件

[Joe-Peng]

Hi:
各位大侠 怎样用C#来编写程序，生成一个Excel文件。

[Joe-Peng]

想要以类库的方式去实现生成一个excel

[sxbluebird]

类库实现还是使用表格控件实现。 如果是表格控件实现，我推荐您使用Spread 表格--Winform、ASP.NET、WPF等平台都有。 http://www.gcpowertools.com.cn/products/sheet.htm 我曾经写过一篇博客，供您参考： 开发复用之表格控件：研发成本降低途径

[wanzi_1434761013]

C#创建保存Excel文件示例 private void btn_Create_Click(object sender, EventArgs e) { string P_str_path = txt_Path.Text;//记录路径 Microsoft.Office.Interop.Excel.Application excel = new Microsoft.Office.Interop.Excel.Application();//实例化Excel对象 Microsoft.Office.Interop.Excel.Workbook newWorkBook = excel.Application.Workbooks.Add(true);//添加新工作簿 object missing = System.Reflection.Missing.Value;//获取缺少的object类型值 newWorkBook.Worksheets.Add(missing, missing, missing, missing);//向Excel文件中增加工作表 if (P_str_path.EndsWith("\\"))//判断路径是否\结尾 newWorkBook.SaveCopyAs(P_str_path + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");//保存Excel文件 else //CodeGo.net// newWorkBook.SaveCopyAs(P_str_path + "\\" + DateTime.Now.ToString("yyyyMMddhhmmss") + ".xls");//保存Excel文件 MessageBox.Show("Excel文件创建成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);//弹出提示信息 System.Diagnostics.Process[] excelProcess = System.Diagnostics.Process.GetProcessesByName("EXCEL");//实例化进程对象 foreach (System.Diagnostics.Process p in excelProcess) p.Kill();//关闭进程 }

[三杨]

//将dt导出到excel
        public void DataToExcel(DataTable m_DataTable,string s_FileName)
        {
            SaveFileDialog kk = new SaveFileDialog();
            kk.Title = "保存EXECL文件";
            kk.Filter = "EXECL文件(*.xls) |*.xls |所有文件(*.*) |*.*";
            kk.FilterIndex = 1;
            //if (kk.ShowDialog() == DialogResult.OK)
            if(true)
            {
                string FileName = "D:\\" + s_FileName + ".xls";
                if (File.Exists(FileName))
                    File.Delete(FileName);
                FileStream objFileStream;
                StreamWriter objStreamWriter;
                string strLine = "";
                objFileStream = new FileStream(FileName, FileMode.OpenOrCreate, FileAccess.Write);
                objStreamWriter = new StreamWriter(objFileStream, System.Text.Encoding.Unicode);
                for (int i = 0; i < m_DataTable.Columns.Count; i++)
                {
                    strLine = strLine + m_DataTable.Columns[i].Caption.ToString() + Convert.ToChar(9);
                }
                objStreamWriter.WriteLine(strLine);
                strLine = "";

                for (int i = 0; i < m_DataTable.Rows.Count; i++)
                {
                    for (int j = 0; j < m_DataTable.Columns.Count; j++)
                    {
                        if (m_DataTable.Rows[i].ItemArray[j] == null)
                            strLine = strLine + " " + Convert.ToChar(9);
                        else
                        {
                            string rowstr = "";
                            rowstr = m_DataTable.Rows[i].ItemArray[j].ToString();
                            if (rowstr.IndexOf("\r\n") > 0)
                                rowstr = rowstr.Replace("\r\n", " ");
                            if (rowstr.IndexOf("\t") > 0)
                                rowstr = rowstr.Replace("\t", " ");
                            strLine = strLine + rowstr + Convert.ToChar(9);
                        }
                    }
                    objStreamWriter.WriteLine(strLine);
                    strLine = "";
                }
                objStreamWriter.Close();
                objFileStream.Close();
                //MessageBox.Show("","保存EXCEL成功", "提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
        }

文件路径那可以改改，让用户自己选择路径，把注释去掉就OK了。

[qzyf1992]

com组件，aspose,npoi,openxml..

[crazeox1]

谢谢，我也在找，受益了！

[快乐起航2020]

学习了，楼主

[新手入门_高手请帮忙]

public static void ExeclExport(DataTable dt, string Title, string[] ColumnsTitle, string[] ColumnsparameterValues)
{
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.Filter = "XLS格式|*.xls";
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
//Microsoft.Office.Interop.Excel.Range range;

FileStream fs = new FileStream(saveFileDialog1.FileName, FileMode.OpenOrCreate);
StreamWriter sw = new StreamWriter(fs, System.Text.Encoding.GetEncoding("GB2312"));
sw.WriteLine(Title);
for (int i = 0; i < ColumnsTitle.Length; i++)
{

sw.Write(ColumnsTitle[i] + "\t");
}
sw.Write("\n");

foreach (DataRow row in dt.Rows)
{
string values = "";
for (int j = 0; j < ColumnsparameterValues.Length; j++)
{
try
{
float.Parse(row[ColumnsparameterValues[j]].ToString());
values += "=TEXT(" + row[ColumnsparameterValues[j]] + ",\"0\")\t";
}
catch (Exception)
{

values += row[ColumnsparameterValues[j]] + "\t";
}
}

sw.WriteLine(values);
}

sw.Close();
fs.Close();
}
}


简单易懂。

[於黾]

看看这个