如何以编程方式将工作表从一个工作簿复制到另一工作簿

问题描述

先生，
我有一本具有N张工作表的工作簿，每张工作表都有一个模板文件.现在我需要创建一个新工作簿并使用c#将工作表从现有工作簿复制到新创建的工作簿，我该怎么办?我对excel工作表的编程一点都不熟悉，请帮助我，先生?

Sir,
I have a workbook having N number of sheets, each sheet is having a template file. Now i need to create a new workbook and copy sheets from existing workbook to newly created one using c#.How can i do that?I am not at all familiar with programming with excel sheets, so please help me sir?

推荐答案

xlWorkbookFrom = xlApp.Workbooks.Open(fullFilenameFrom, 0, false, 5, "", "",
                    false, XlPlatform.xlWindows, "",
                    true, false, 0, true, false, false);
xlWorkbookTo = xlApp.Workbooks.Open(fullFilenameTo, 0, false, 5, "", "",
                    false, XlPlatform.xlWindows, "",
                    true, false, 0, true, false, false);


xlSheetsFrom = xlWorkbookFrom.Sheets as Sheets;
xlSheetsTo = xlWorkbookTo.Sheets as Sheets;

foreach(var sheet in xlSheetsFrom)
{
    xlNewSheet = (Worksheet)xlSheetsTo.Add(sheet , Type.Missing, Type.Missing,    Type.Missing);
    xlNewSheet.Name = sheet.Name;
}
xlWorkbookTo .Save();
xlWorkbookTo .Close(Type.Missing,Type.Missing,Type.Missing);
...//etc

但我真的不确定，这是否行得通，我从不尝试.

But I really don''t sure, that thiswill work, I never try.

这篇关于如何以编程方式将工作表从一个工作簿复制到另一工作簿的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！