将工作表从一个工作簿复制到另一个工作簿并保留源工作表格式 [英] copy sheet from one workbook to other and retain the source sheet format

问题描述

您好我正在尝试将工作表中的工作簿复制到另一个工作簿。下面是我使用过的代码。使用此代码，我可以复制整张表，但问题是它没有在源表中携带格式



C＃使用的代码：

 objSourceWorkbook = ExcelApp.Workbooks.Open（  Source Workbook Path，Type.Missing， true ，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing ，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing）; 
 objDestWorkbook = ExcelApp.Workbooks.Open（  Dest Workbook Path，Type.Missing，  true ，Type.Missing， 打开工作簿的密码，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing，Type.Missing）; 
 objSheet =（Excel.Worksheet）objSourceWorkbook.Sheets [ 工作表名称]; 
 ExcelApp.DisplayAlerts =  false ; 
 objSheet.Copy（（Excel.Worksheet）objSourceWorkbook.Sheets [ 1 ]，Type.Missing）; 
 objDestWorkbook.Save（）; 
 ExcelApp.DisplayAlerts =  true ; 

请帮助我在哪里做错了。 />


谢谢，

-Dileep

解决方案

这可能会有所帮助 - 如何：以编程方式跨工作表复制数据和格式化 [ ^ ]。

Hi I am trying to copy a sheet from one workbook to another workbook.Below is the code i had used. With this code i am able to copy the whole sheet but the problem is it is not carrying the formatting in the source sheet

C# Code used:

objSourceWorkbook = ExcelApp.Workbooks.Open("Source Workbook Path", Type.Missing, true, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing);
objDestWorkbook = ExcelApp.Workbooks.Open("Dest Workbook Path", Type.Missing, true, Type.Missing,"Password to open the workbook", Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing, Type.Missing, Type.Missing, Type.Missing, Type.Missing,Type.Missing);
objSheet = (Excel.Worksheet)objSourceWorkbook.Sheets["Sheet Name"];
ExcelApp.DisplayAlerts = false;
objSheet.Copy((Excel.Worksheet)objSourceWorkbook.Sheets[1], Type.Missing);
objDestWorkbook.Save();
ExcelApp.DisplayAlerts = true;

Please help me where am i doing wrong.

Thanks,
-Dileep

解决方案

This might help - How to: Programmatically Copy Data and Formatting across Worksheets[^].

这篇关于将工作表从一个工作簿复制到另一个工作簿并保留源工作表格式的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！