在c#中能不能动态的生成一个excel文件，向里边添加数据？

[yesman]

很急

[saucer]

看看这篇文章

http://support.microsoft.com/default.aspx?scid=kb;EN-US;Q302084

[wenzm]

可以吧，因为都是VBA编程啊
一下是一段C#中操作Word的代码，你看看有没有用
using System;
using System.Drawing;
using System.Collections;
using System.ComponentModel;
using System.Windows.Forms;
using System.Data;

if (this.openFileDialog1.ShowDialog() == DialogResult.OK)
{
object fileName = openFileDialog1.FileName;
object readOnly = false;
object isVisible = true;
object missing = System.Reflection.Missing.Value;

// WordApp.Activate();
WordApp.Visible = true;

Word.Document aDoc = WordApp.Documents.Open(ref fileName, ref missing,ref readOnly,
ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref isVisible);

aDoc.Activate();

WordApp.Selection.TypeText("Copyright C# Corner");
WordApp.Selection.TypeParagraph();

}

[dingsb]

using Excel;
class Excell
{ public static int Main()
{ Application exc = new Application();
Workbooks workbooks = exc.Workbooks;
_Workbook workbook = workbooks.Add(XlWBATemplate.xlWBATWorksheet);
Sheets sheets = workbook.Worksheets;
_Worksheet worksheet = (_Worksheet) sheets.get_Item(1);
Range range1 = worksheet.get_Range("C1","C1");
exc.Visible=true;
const int nCells = 1;
Object[] args1 = new Object[1];
args1[0] = nCells;
range1.Value2=100;
}

www.online.com.cn里面有