复制excel工作簿到另一个
本文关键字:另一个 工作簿 excel 复制 | 更新日期: 2023-09-27 18:09:58
我已经编写了代码来获取工作表的副本到一个新的excel文件。下面是我的c#代码,问题是一些命名单元格缺失,我已经在Excel-2010中检查了这一点。
c#代码:string strPath=@"C:'NewFolder'somexcelfile.xls";
Excel.Workbook souWorkbook = xCel.Workbooks.Open(strPath);
Excel.Workbook destWorkbook = xCel.Workbooks.Add();
foreach (Excel.Worksheet wkSheet in souWorkbook.Worksheets)
{
wkSheet.Copy(destWorkbook.Worksheets[1]);
}
destWorkbook.SaveCopyAs("C:'NewFolder'copy.xls");
如果需要复制已命名的单元格,可以使用以下代码示例
Sub Copy_All_Defined_Names()
' Loop through all of the defined names in the active
' workbook.
For Each x In ActiveWorkbook.Names
' Add each defined name from the active workbook to
' the target workbook ("Book2.xls" or "Book2.xlsm").
' "x.value" refers to the cell references the
' defined name points to.
Workbooks("Book2.xls").Names.Add Name:=x.Name, _
RefersTo:=x.Value
Next x
End Sub