about asp.net excel and clipboard

[ʹÃûÑï]

hi:

purpose: clone the firest sheet in Excel.xls into excel2.xls

here is my code
it well done in winform£º
-------------------------------
string SubFile=@"D:\Ex cel2.xls";
string MainFile=@"D:\E xcel.xls";
Excel.Applicati on ExcelMainFileAp p,ExcelSubFileA pp;
Excel._Workbook ExcelMainFileWo rkbook,ExcelSub FileWorkbook;
Excel._Workshee t ExcelMainFileWo rksheet,ExcelSu bFileWorksheet;
try
{
ExcelMainFileAp p = new Excel.Applicati on();

//open source
ExcelMainFileWo rkbook=ExcelMai nFileApp.Workbo oks.Open(MainFi le,Type.Missing ,
Type.Missing,Ty pe.Missing,Type .Missing,Type.M issing,Type.Mis sing,Type.Missi n
g,Type.Missing, Type.Missing,Ty pe.Missing,Type .Missing,Type.M issing,Type.Mis s
ing,Type.Missin g);
ExcelMainFileWo rksheet=(Excel. _Worksheet)Exce lMainFileWorkbo ok.ActiveSheet;
string name=ExcelMainF ileWorksheet.Na me;
ExcelMainFileWo rksheet.Cells.C opy(Type.Missin g);

ExcelSubFileApp = new Excel.Applicati on();
//destination
ExcelSubFileWor kbook=ExcelSubF ileApp.Workbook s.Open(SubFile, Type.Missing,Ty p
e.Missing,Type. Missing,Type.Mi ssing,Type.Miss ing,Type.Missin g,Type.Missing, T
ype.Missing,Typ e.Missing,Type. Missing,Type.Mi ssing,Type.Miss ing,Type.Missin g
,Type.Missing);
ExcelSubFileWor ksheet=(Excel._ Worksheet)Excel SubFileWorkbook .Sheets.Add(Exc e
lSubFileWorkboo k.Sheets[ExcelSubFileWor kbook.Sheets.Co unt],Type.Missing,T ype
..Missing,Type. Missing);
ExcelSubFileWor ksheet.Paste(Ty pe.Missing,Type .Missing);//failed in webform
,when in winform it's ok
foreach (Excel.Workbook book in ExcelSubFileApp .Workbooks)
{
book.Save();
}
ExcelMainFileAp p.Workbooks.Clo se();
ExcelSubFileApp .Workbooks.Clos e();
ExcelMainFileAp p.Quit();
ExcelSubFileApp .Quit();
}
catch( Exception theException )
{
}
finally
{

}
-------------------------------
but when in webform ,it's failed in "
ExcelSubFileWor ksheet.Paste(Ty pe.Missing,Type .Missing); "

i have configed the DCOM right about excel .
(run dcomcnfg.exe and config Microsoft Excel Application.)
but it's still fail :( (without config it failed in "ExcelMainFileA pp =
new Excel.Applicati on();")

anybody knows why?

[Alvin Bruney [Microsoft MVP]]

for staters you didn't say what was wrong. secondly, you don't need to
multi-post - this problem has nothing to do with dotnet.framewor k for
example. there is also a worksheet copy function that you can use to copy
but it uses the system clipboard and you need appropriate permissions

--
Regards
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
--------------------------------------------------
"ʹÃûÑï" <to************ *@hotmail.com> wrote in message
news:OO******** *****@TK2MSFTNG P12.phx.gbl...

hi:

purpose: clone the firest sheet in Excel.xls into excel2.xls

here is my code
it well done in winform£º
-------------------------------
string SubFile=@"D:\Ex cel2.xls";
string MainFile=@"D:\E xcel.xls";
Excel.Applicati on ExcelMainFileAp p,ExcelSubFileA pp;
Excel._Workbook ExcelMainFileWo rkbook,ExcelSub FileWorkbook;
Excel._Workshee t ExcelMainFileWo rksheet,ExcelSu bFileWorksheet;
try
{
ExcelMainFileAp p = new Excel.Applicati on();

//open source
ExcelMainFileWo rkbook=ExcelMai nFileApp.Workbo oks.Open(MainFi le,Type.Missing ,
Type.Missing,Ty pe.Missing,Type .Missing,Type.M issing,Type.Mis sing,Type.Missi n
g,Type.Missing, Type.Missing,Ty pe.Missing,Type .Missing,Type.M issing,Type.Mis s
ing,Type.Missin g);
ExcelMainFileWo rksheet=(Excel. _Worksheet)Exce lMainFileWorkbo ok.ActiveSheet;
string name=ExcelMainF ileWorksheet.Na me;
ExcelMainFileWo rksheet.Cells.C opy(Type.Missin g);

ExcelSubFileApp = new Excel.Applicati on();
//destination
ExcelSubFileWor kbook=ExcelSubF ileApp.Workbook s.Open(SubFile, Type.Missing,Ty p
e.Missing,Type. Missing,Type.Mi ssing,Type.Miss ing,Type.Missin g,Type.Missing, T
ype.Missing,Typ e.Missing,Type. Missing,Type.Mi ssing,Type.Miss ing,Type.Missin g
,Type.Missing);
ExcelSubFileWor ksheet=(Excel._ Worksheet)Excel SubFileWorkbook .Sheets.Add(Exc e
lSubFileWorkboo k.Sheets[ExcelSubFileWor kbook.Sheets.Co unt],Type.Missing,T ype
.Missing,Type.M issing);
ExcelSubFileWor ksheet.Paste(Ty pe.Missing,Type .Missing);//failed in webform
,when in winform it's ok
foreach (Excel.Workbook book in ExcelSubFileApp .Workbooks)
{
book.Save();
}
ExcelMainFileAp p.Workbooks.Clo se();
ExcelSubFileApp .Workbooks.Clos e();
ExcelMainFileAp p.Quit();
ExcelSubFileApp .Quit();
}
catch( Exception theException )
{
}
finally
{

}
-------------------------------
but when in webform ,it's failed in "
ExcelSubFileWor ksheet.Paste(Ty pe.Missing,Type .Missing); "

i have configed the DCOM right about excel .
(run dcomcnfg.exe and config Microsoft Excel Application.)
but it's still fail :( (without config it failed in "ExcelMainFileA pp
=
new Excel.Applicati on();")

anybody knows why?