想把一个在线填写好的表单以excell的文件保存,每一个表单以人名+ID为文件名保存成一张excell,存放到服务器根目录的"excell"文件夹下!目前来说我只知道如何保存到客户端.
请高手帮忙解决这个问题.现在正急着用呢.感谢!

up

up

http://blog.csdn.net/alan_whg/archive/2006/06/07/777959.aspx

你的意思是说生成一个excel 名字是用户名+id组成EXCEL的名字!
我刚刚看错了 帮你怎么把数据写入excel中了

要不你把你的代码发出来看看  研究一下!

谢了各位,先去咖啡不加糖兄弟的日志上看看回来再说.

//引用 microsoft word object 9.0 library
Word.ApplicationClass oWordApp = new Word.ApplicationClass(); //这里是产生错误的行!!!
object missing = System.Reflection.Missing.Value;
object filename = "c:\\myfile.doc";
Word.Document oWordDoc = oWordApp.Documents.Add(ref missing, ref missing, ref missing, ref missing);

oWordDoc.Activate();

oWordApp.Selection.TypeText("This is the text");
oWordApp.Selection.TypeParagraph();
oWordDoc.SaveAs(ref filename, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);

oWordApp.Application.Quit(ref missing, ref missing, ref missing);

在office2003中引用的是11
代码如下:
using MSWord = Microsoft.Office.Interop.Word;

private MSWord.Application _wordApp = null;
protected void Button1_Click(object sender, EventArgs e)
{
_wordApp = new MSWord.Application(); //这里是产生错误的行!!!

_wordApp.Visible = true;
Object missing = Type.Missing;

Object sFileName = Server.MapPath("text\\Sample.doc");

MSWord.Documents docs = _wordApp.Documents;

MSWord.Document doc = docs.Add(ref missing, ref missing, ref missing, ref missing);

doc.SaveAs(ref sFileName, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing, ref missing);

doc.Close(ref missing, ref missing, ref missing);
}

产生了错误: "检索 COM 类工厂中 CLSID 为 {000209FF-0000-0000-C000-000000000046} 的组件时失败，原因是出现以下错误: 80070005。"
我用的是vs2005 ,以上代码为什么会产生这种错误码.我试着修改过其权限,但还是报一样的错误码.office 2000跟office2003我都试过了.
望指教!

[此贴子已经被作者于2006-7-7 16:56:28编辑过]

up

你是不是准备把数据写入EXCEL中啊?要是写入的话,我已经帮你实现了?我用的是VS2003