Excel中Sheet复制

最新推荐文章于 2025-05-16 16:09:52 发布

原创最新推荐文章于 2025-05-16 16:09:52 发布 · 1.4k 阅读

1 ·

CC 4.0 BY-SA版权

文章标签：

#excel #null #string #exception #object #工作

Excel 专栏收录该内容

1 篇文章

订阅专栏

此工具通过C#实现多个Excel文件的指定工作表合并为一个文件的功能。程序首先创建一个新的工作簿，然后依次打开每个源文件并复制所有工作表到新工作簿中（除了第一个工作表）。最后保存为指定的目标文件。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

        public static bool MergeSheet(string fileName, List<string> sheetViewNameList,ref string message)
        {
            if (sheetViewNameList!=null&&sheetViewNameList.Count>0)
            {
                ApplicationClass appcls = new ApplicationClass();
                Workbook wkb = null;
                object missing = System.Reflection.Missing.Value;
                appcls.DisplayAlerts = false;
                appcls.Visible = false;
                try
                {
                    //新建一工作簿
                    wkb = appcls.Workbooks.Add(XlSheetType.xlWorksheet);
                    bool canDelete = true;
                    foreach (string file in sheetViewNameList)
                    {
                        Workbook wkbFrom = appcls.Workbooks.Open(file, missing, missing,
                                                      missing, missing, missing, missing,
                                                      missing, missing, missing, missing,
                                                      missing, missing);
                        Worksheet wst = null;

                        for (int i = 1; i <= wkbFrom.Sheets.Count; i++)
                        {
                            wst = null;
                            //取得sheet
                            wst = (Excel.Worksheet)(wkbFrom.Sheets.get_Item(i));
                            //将sheet复制到工作簿中
                            wst.Copy(missing, wkb.Worksheets[wkb.Worksheets.Count]);
                            if (canDelete)
                            {
                                //将第一个sheet即sheet1删除
                                ((Worksheet)wkb.Worksheets.get_Item(1)).Delete();
                                canDelete = false;
                            }
                        }
                        wst = null;
                        wkbFrom.Close(missing, missing, missing);
                        wkbFrom = null;
                    }
                    //选择第一个Sheet
                    ((Worksheet)wkb.Worksheets.get_Item(1)).Select(missing);
                    //保存工作簿
                    wkb.SaveAs(fileName, XlFileFormat.xlWorkbookNormal, missing, missing, missing, missing,
                                    Excel.XlSaveAsAccessMode.xlNoChange, missing, missing, missing, missing);
                    return true;
                }
                catch (Exception ex)
                {
                    message = ex.Message;
                    foreach (string filefrom in sheetViewNameList)
                    {
                        //源文件删除

                        FileInfo fileInfo = new FileInfo(filefrom);
                        if (fileInfo.Exists)
                        {
                            //只读属性先设置成普通属性再删除
                            fileInfo.Attributes = FileAttributes.Normal;
                            fileInfo.Delete();
                        }
                    }
                    return false;
                }
                finally
                {
                    if (appcls != null)
                    {
                        appcls.Quit();
                        Marshal.FinalReleaseComObject((Object)appcls);
                    }
                    appcls = null;
                    wkb = null;
                }
            }
            else
            {
                return false;
            }
        }