数据库excel表格怎么

1.sql导出excel 如何提供客户端下载

C#.NET实现EXCEL操作类 - .NET读取和设置EXCEL电子表格单元的参考代码

using System;

using Excel;

namespace ExcelExample

{

/// <summary>

/// Summary description for Class1.

/// </summary>

class ExcelClass

{

/// <summary>

/// The main entry point for the application.

/// </summary>

[STAThread]

static void Main(string[] args)

{

Excel.Application excelApp = new Excel.ApplicationClass(); // Creates a new Excel Application

excelApp.Visible = false; // Makes Excel visible to the user.

// The following line adds a new workbook

Excel.Workbook newWorkbook = excelApp.Workbooks.Add(XlWBATemplate.xlWBATWorksheet);

// The following code opens an existing workbook

string workbookPath = "c:/SomeWorkBook.xls"; // Add your own path here

Excel.Workbook excelWorkbook = excelApp.Workbooks.Open(workbookPath, 0,

false, 5, "", "", false, Excel.XlPlatform.xlWindows, "", true,

false, 0, true, false, false);

// The following gets the Worksheets collection

Excel.Sheets excelSheets = excelWorkbook.Worksheets;

// The following gets Sheet1 for editing

string currentSheet = "Sheet1";

Excel.Worksheet excelWorksheet = (Excel.Worksheet)excelSheets.get_Item(currentSheet);

// The following gets cell A1 for editing

Excel.Range excelCell = (Excel.Range)excelWorksheet.get_Range("A1", "A1");

// The following sets cell A1's value to "Hi There"

excelCell.Value2 = "Hi There";

}

}