C#asp.net生成 Excel的问题

Excel.dll在Excel安装程序下，
using Microsoft.Office.Interop.Excel;

using Microsoft.Office.Interop.Excel;
只有Microsoft..CSharp另外Excel.dll在已安装的office文件夹下？还是别的地方呢？

可以用ado.net操作数据库的方法的

我在引用那里找到Microsoft.Office.Tools.Excel，这个怎么用呢？

添加using Microsoft.Office.Interop.Excel;这个引用即可
工程--添加引用--com 下面去找只要你装了office应该就有这个了~

com 下面去有很多的microsort 的组件，至于哪个才能有using Microsoft.Office.Interop.Excel这个命名空间呢

找到了Excel，但我想打开为保存的，让用户自己选择是否已经保存，如何做呢？

給你一個類，可以實現LZ說的功能：
using System;
using System.Data;
using System.Configuration;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.IO;
using System.Text;
using System.Threading;
using System.Web;public class ExportToExcel
{
    public ExportToExcel()
    {    }
    #region excelHeader    private const string excelHeader =
        @"<html xmlns:o=""urn:schemas-microsoft-com:office:office"" xmlns:x=""urn:schemas-microsoft-com:office:excel""
    xmlns:ss=""urn:schemas-microsoft-com:office:spreadsheet"" xmlns:html=""http://www.w3.org/TR/REC-html40""
    xmlns=""http://www.w3.org/TR/REC-html40"">
<head>
    <meta http-equiv=""Content-Type"" content=""text/html; charset=utf-8"">
    <meta name=""ProgId"" content=""Excel.Sheet"">
    <style>

</style>
    
</head>
<body>";    #endregion
    private const string excelTail = "</body></html>";
    private const string sheetHeader = "<table>";
    private const string sheetTail = "</table>";
    private const string rowHeader = "<tr>";
    private const string rowTail = "</tr>";
    private const string excelCell = "<td class=\"{0}\">{1}</td>";    public void Export(DataSet source, string fileName)
    {
        string tempName = DataSetToTextWriter(source);
        TransmitFile(tempName, fileName);
    }
    private string DataSetToTextWriter(DataSet source)
    {
        string tempName = Path.GetTempFileName();
        StreamWriter txtWriter = new StreamWriter(tempName);
        txtWriter.Write(excelHeader);
        if (source.Tables.Count == 0)
        {
            return "";
        }
        txtWriter.Write(sheetHeader);
        txtWriter.Write(rowHeader);        string[] columnArray;
        string[] columnText;
        int columnCount = source.Tables[0].Columns.Count;        columnArray = new string[columnCount];
        columnText = new string[columnCount];
        for (int i = 0; i < columnCount; i++)
        {
            columnArray[i] = source.Tables[0].Columns[i].ColumnName;
        }
        string columnName;
        for (int i = 0; i < columnCount; i++)
        {
            if (string.IsNullOrEmpty(columnText[i]))
            {
                columnName = columnArray[i];            }
            else
            {
                columnName = HttpUtility.UrlDecode(columnText[i]);
            }
            txtWriter.Write(excelCell, "BoldColumn", columnName);
        }
        string temp;
        object rowValue;
        DataView rows = source.Tables[0].DefaultView;
        foreach (DataRowView row in rows)
        {
            txtWriter.Write(rowHeader);
            for (int i = 0; i < columnCount; i++)
            {
                rowValue = row[columnArray[i]];
                switch (rowValue.GetType().FullName)
                {
                    case "System.String":
                        temp = rowValue.ToString();                        txtWriter.Write(excelCell, "StringLiteral", temp);
                        break;
                    case "System.DateTime":
                        DateTime dateTime = (DateTime)rowValue;
                        txtWriter.Write(
                            excelCell, "DateLiteral", dateTime.ToString("yyyy-MM-dd HH:mm:ss"));
                        break;
                    case "System.Boolean":
                        txtWriter.Write(excelCell, "StringLiteral", rowValue.ToString());
                        break;
                    case "System.Int16":
                    case "System.Int32":
                    case "System.UInt16":
                    case "System.UInt32":
                    case "System.Byte":
                        txtWriter.Write(excelCell, "Integer", rowValue.ToString());
                        break;
                    case "System.Int64":
                    case "System.UInt64":
                        temp = rowValue.ToString();
                        if (temp.Length > 15)
                        {
                            txtWriter.Write(excelCell, "StringLiteral", temp);
                        }
                        else
                        {
                            txtWriter.Write(excelCell, "Integer", temp);
                        }
                        break;
                    case "System.Decimal":
                        temp = rowValue.ToString();
                        if (temp.Contains("."))
                        {
                            txtWriter.Write(excelCell, "Float", temp);
                        }
                        else
                        {
                            if (temp.Length > 15)
                            {
                                txtWriter.Write(excelCell, "StringLiteral", temp);
                            }
                            else
                            {
                                txtWriter.Write(excelCell, "Integer", temp);
                            }
                        }
                        break;
                    case "System.Double":
                        txtWriter.Write(excelCell, "Float", rowValue.ToString());
                        break;
                    case "System.DBNull":
                        txtWriter.Write(excelCell, "StringLiteral", string.Empty);
                        break;
                    default:
                        txtWriter.Write(excelCell, "StringLiteral", rowValue.ToString());
                        break;
                }
            }
            txtWriter.Write(rowTail);
        }
        txtWriter.Write(sheetTail);
        txtWriter.Write(excelTail);
        txtWriter.Close();
        return tempName;    }

    #region TransferFile    /// <summary>
    /// 蔚Web督昢奻腔還奀恅璃換怀善諦誧傷ㄛ甜刉壺還奀恅璃﹝
    /// </summary>
    /// <param name="tempFilePath">湔婓逄督昢奻腔埭還奀恅璃﹝</param>
    /// <param name="desFileName">悵湔腔諦誧傷腔恅璃</param>
    public static void TransmitFile(string tempFilePath, string desFileName)
    {
        //迡善httpㄛ羲宎狟婥
        string encodeFileName = HttpUtility.UrlEncode(desFileName);
        HttpContext.Current.Response.Clear();
        HttpContext.Current.Response.ContentType = "application/ms-excel";
        HttpContext.Current.Response.ContentEncoding = Encoding.GetEncoding("UTF-8");
        HttpContext.Current.Response.AppendHeader("Content-Disposition", "attachment;filename=" + encodeFileName);
        HttpContext.Current.Response.TransmitFile(tempFilePath);
        HttpContext.Current.Response.Flush();
        //雄盄最燴還奀恅璃
        DeleteTempFile(tempFilePath, false);
        HttpContext.Current.Response.End();
    }    #endregion    #region DeleteTempFile    /// <summary>
    /// 雄盄最燴還奀恅璃ㄛ忑棒脹50鏃ㄛ楷珋恅璃淏婓妏蚚寀森綴藩30鏃郭彸刉壺珨棒ㄛ
    /// 僕郭彸10棒﹝
    /// </summary>
    /// <param name="tempFilePath">The temp file path.</param>
    /// <param name="deleteDirectory">岆瘁刉壺垀婓恅璃標</param>
    public static void DeleteTempFile(string tempFilePath, bool deleteDirectory)
    {
        if (!File.Exists(tempFilePath))
        {
            return;
        }
        Thread t = new Thread(delegate()
                              {
                                  int retry = 0;
                                  int interval = 50000; //忑棒脹渾50鏃
                                  while (retry < 12)
                                  {
                                      try
                                      {
                                          Thread.Sleep(interval);
                                          if (deleteDirectory)
                                          {
                                              string dir = Path.GetDirectoryName(tempFilePath);
                                              Directory.Delete(dir, true);
                                          }
                                          else
                                          {
                                              File.Delete(tempFilePath);
                                          }
                                          break;
                                      }
                                      catch (IOException)
                                      {
                                          //刉壺囮啖綴寀蔚脹渾奀潔离峈30鏃
                                          interval = 30000;
                                          retry++;
                                      }
                                      catch (Exception)
                                      {
                                          break;
                                      }
                                  }
                              });
        t.Start();
    }    #endregion
}

调试易

C#asp.net生成 Excel的问题

解决方案 »