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:\Excel2.xls";
string MainFile=@"D:\Excel.xls";
Excel.Application ExcelMainFileApp,ExcelSubFileApp;
Excel._Workbook ExcelMainFileWorkbook,ExcelSubFileWorkbook;
Excel._Worksheet ExcelMainFileWorksheet,ExcelSubFileWorksheet;
try
{
ExcelMainFileApp = new Excel.Application();

//open source
ExcelMainFileWorkbook=ExcelMainFileApp.Workbooks.Open(MainFile,Type.Missing,
Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missin
g,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Miss
ing,Type.Missing);


ExcelMainFileWorksheet=(Excel._Worksheet)ExcelMainFileWorkbook.ActiveSheet;
string name=ExcelMainFileWorksheet.Name;
ExcelMainFileWorksheet.Cells.Copy(Type.Missing);

ExcelSubFileApp = new Excel.Application();


//destination
ExcelSubFileWorkbook=ExcelSubFileApp.Workbooks.Open(SubFile,Type.Missing,Typ
e.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,T
ype.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing,Type.Missing
,Type.Missing);
ExcelSubFileWorksheet=(Excel._Worksheet)ExcelSubFileWorkbook.Sheets.Add(Exce
lSubFileWorkbook.Sheets[ExcelSubFileWorkbook.Sheets.Count],Type.Missing,Type
..Missing,Type.Missing);
ExcelSubFileWorksheet.Paste(Type.Missing,Type.Missing);//failed in webform
,when in winform it's ok
foreach (Excel.Workbook book in ExcelSubFileApp.Workbooks)
{
book.Save();
}
ExcelMainFileApp.Workbooks.Close();
ExcelSubFileApp.Workbooks.Close();
ExcelMainFileApp.Quit();
ExcelSubFileApp.Quit();
}
catch( Exception theException )
{
}
finally
{

}
-------------------------------
but when in webform ,it's failed in "
ExcelSubFileWorksheet.Paste(Type.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 "ExcelMainFileApp =
new Excel.Application();")

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.framework 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

 

[ʹÃûÑï]

thank you
but for using the system clipboard in asp.net need which permissions?

i have config Microsoft Excel Application in dcomcnfg.exe and asp.net/iis
users is in administrator group.

and
ExcelMainFileWorksheet.Copy(ExcelSubFileWorkbook.Sheets[ExcelSubFileWorkbook
..Sheets.Count-1],Type.Missing); failed in winform now.
it seems copy function just can be used in one excel app with different
workbooks or one workbook.