利用SQL Server中的数据在MOSS 2007中创建和发布excel文件

-- 创建一个Excel文件
EXEC master..xp_cmdshell 'bcp "SELECT * FROM YourTable" queryout "C:\path\to\yourfile.xlsx" -c -T'

using System;
using System.Data;
using System.Data.SqlClient;
using Microsoft.Office.Interop.Excel;

public void GenerateExcelFile()
{
    // 连接SQL Server数据库
    string connectionString = "your_connection_string";
    SqlConnection connection = new SqlConnection(connectionString);
    connection.Open();

    // 查询数据
    string query = "SELECT * FROM YourTable";
    SqlCommand command = new SqlCommand(query, connection);
    SqlDataReader reader = command.ExecuteReader();

    // 创建Excel文件
    Application excelApp = new Application();
    Workbook workbook = excelApp.Workbooks.Add();
    Worksheet worksheet = workbook.Sheets[1];

    // 写入数据
    int row = 1;
    while (reader.Read())
    {
        for (int col = 0; col < reader.FieldCount; col++)
        {
            worksheet.Cells[row, col + 1] = reader[col];
        }
        row++;
    }

    // 保存文件
    workbook.SaveAs("C:\\path\\to\\yourfile.xlsx");
    workbook.Close();
    excelApp.Quit();

    // 关闭连接
    reader.Close();
    connection.Close();
}