（一）C#使用DsoFramer操作Excel，获取Window、Workbook、WorkSheet、Range

柔情只为你懂 2022-08-13 13:52 649阅读 0赞

上一次已经在项目窗体中添加了DsoFramer控件，接下来该如何使用它进行Excel操作呢？

1.      在本项目中，该控件命名为afcExcel，加载Excel到控件中

sPath为Excel文件的路径，利用控件的Open方法加载Excel到控件上

afcExcel.Open(sPath);

2.      获取加载的当前文档、当前窗口、工作薄、工作表、选中区域等参数

获得加载的当前文档，利用该参数再来获取工作薄、工作表、选中区域等参数

object documentExcel= afcExcel.ActiveDocument;

2.1获得当前活动窗口（Window）

// 获得当前窗体
            public static Window GetActiveWindow(object Document)
            {
                if (Document == null)
                {
                    return null;
                }
    
                Workbook workbook = null;
                Worksheet worksheet = null;
                try
                {
                     获取当前工作薄
                    workbook = (Microsoft.Office.Interop.Excel.Workbook)Document;
                     获取当前工作页
                    worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.ActiveSheet;
                    Window window = null;
    
                    if (worksheet != null)
                    {
                         获取当前活动窗口
                        window = worksheet.Application.ActiveWindow;
                    }
    
                    return window;
                }
                catch
                {
                    return null;
                }
            }

2.2获得选中区域（Range）

/// <summary>
            /// 获取当前Excel鼠标的选中范围
            /// </summary>
            public static Range GetSelectionRange(object Document)
            {
                if (Document == null)
                {
                    return null;
                }
    
                Workbook workbook = null;
                Worksheet worksheet = null;
                try
                {
                    workbook = (Microsoft.Office.Interop.Excel.Workbook)Document;
                    worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.ActiveSheet;
    
                     获取选中区域
                    object obj = worksheet.Application.Selection;
                    Range range = null;
    
                    if (obj != null)
                    {
                         选中区域强制转化成Range
                        range = (Microsoft.Office.Interop.Excel.Range)obj;
                    }
    
                    return range;
                }
                catch
                {
                    return null;
                }
            }

2.3获得选中区域的第一个单元格

public static Range GetSelectionCell(object Document)
            {
                if (Document == null)
                {
                    return null;
                }
    
                Workbook workbook = null;
                Worksheet worksheet = null;
                try
                {
                    workbook = (Microsoft.Office.Interop.Excel.Workbook)Document;
                    worksheet = (Microsoft.Office.Interop.Excel.Worksheet)workbook.ActiveSheet;
                    Range range = null;
                    
                    if (worksheet != null)
                    {
                         获取所选区域的第一次选中的单元格
                        range = worksheet.Application.ActiveCell;
                    }
    
                    return range;
                }
                catch
                {
                    return null;
                }
    
            }

**获得了这些参数后，就能来实现Excel中的相关操作了……**