Excel-不同表格间复制的问题

2026年09月04日 03:37 发布来源：Excel学习网

如果要在不同表格间复制worksheet,前提必须是同一个workbooks打开的，否则会报0x800A03EC的错误。

 bool vFG = true; m_App.Visible = false; //m_App1.Visible = false; m_App.DisplayAlerts = false; //m_App1.DisplayAlerts = false; Workbooks vWorkbooks = m_App.Application.Workbooks; //Workbooks vWorkbooks1 = m_App1.Application.Workbooks; object vReadOnly = false; object vEditable = true; Workbook vWorkbook = vWorkbooks.Open( pFileName, m_Missing, vReadOnly, m_Missing, m_Missing, m_Missing, m_Missing, m_Missing, m_Missing, vEditable, m_Missing, m_Missing, m_Missing, m_Missing,m_Missing); bool vExist = false; for (int i = 1; i <= vWorkbook.Worksheets.Count; i++) { Worksheet vWorksheet = (Worksheet)vWorkbook.Worksheets; if (vWorksheet.Name.Equals("B票")) { vExist = true; break; } } if (!vExist) { if (this.m_WorkSheetOfMode == null) { Workbook vWorkbook1 = vWorkbooks.Open(this.txtModeOfBugList.Text, m_Missing, vReadOnly, m_Missing, m_Missing, m_Missing, m_Missing, m_Missing, m_Missing, vEditable, m_Missing, m_Missing, m_Missing, m_Missing,m_Missing); Worksheet vWorksheet1 = null; for (int i = 1; i <= vWorkbook1.Worksheets.Count; i++) { vWorksheet1 = (Worksheet)vWorkbook1.Worksheets; if (vWorksheet1.Name.Equals("B票")) { vExist = true; this.m_WorkSheetOfMode = vWorksheet1; break; } } if (!vExist) { vFG = false; } else { Worksheet vWorksheet2 = (Worksheet)vWorkbook.Worksheets[vWorkbook.Worksheets.Count]; vWorksheet1.Copy(m_Missing, vWorksheet2); } } else { Worksheet vWorksheet2 = (Worksheet)vWorkbook.Worksheets[vWorkbook.Worksheets.Count]; this.m_WorkSheetOfMode.Copy(m_Missing, vWorksheet2); } } vWorkbook.Save(); //vWorkbooks1[1].Save(); vWorkbooks.Close(); vWorkbooks = null; //vWorkbooks1.Close(); m_App.Quit(); //m_App1.Quit();

原创文章如转载请注明：转载自Excel学习网 [ https://www.excelxxw.com/]
需要保留本文链接地址：https://www.excelxxw.com/jiqiao/2661.html

上一篇：创建模板保存excel默认设置下一篇：返回列表