博客园  :: 首页  :: 新随笔  :: 联系 :: 订阅 订阅  :: 管理

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

Posted on 2008-10-20 13:27  懒人ABC  阅读(513)  评论(0编辑  收藏  举报

如果要在不同表格间复制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[i];
                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[i];
                        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();