没有啊,
using System.Windows.Forms;
using Microsoft.Office.Interop.Excel;
命名空间“Microsoft”中不存在类型或命名空间名称“Office”(是否缺少程序集引用?)
命名空间“System”中不存在类型或命名空间名称“Windows”(是否缺少程序集引用?)
这俩处都有问题。
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using System.IO;
using Microsoft.Office.Interop.Excel;
using System.Reflection;
namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
DataSet HeadDs = new DataSet();
System.Data.DataTable HeaderTable = new System.Data.DataTable("Header");
DataColumn header = new DataColumn("header", typeof(string));
header.MaxLength = 50;
HeaderTable.Columns.Add(header);
string[] DefaultHeader = { "a1","a2","a3","a4"};
for (int i = 0; i < DefaultHeader.Length; i++)
{
FillDataTable(HeaderTable, DefaultHeader[i]);
}
HeadDs.Tables.Add(HeaderTable);
string absFileName =@"d:\"+ DateTime.Now.ToString("yyyyMMddHHmmss") + ".xls";
//导出到Excel文件中
ExportToExcel(HeadDs.Tables[0], absFileName);