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?

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


"ʹÃûÑï" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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?
>
>