ExtentionsOutFullJoin(Object, Object, String, String, FuncObject, Object, Object, Object, String) 方法
二维数组全连接,key接受逗号分隔的列号,左右无匹配项自动留空
arr.OutFullJoin(brr,1,1,function(a,b) {a.f1,b.f2})
不写结果选择器代表显示a+b所有列
命名空间： Excel880VSTO程序集： Excel880VSTO (在 Excel880VSTO.dll 中) 版本：1.5.8.0 (1.5.8.0)
public static IEnumerable<Object[]> OutFullJoin(
this Object[,] 源表,
Object[,] 查询表,
string 源表keys,
string 查询表keys,
Func<Object[], Object[], Object[]> 结果选择器 = null,
Object 空行显示 = "",
string keys分隔符 = "@^@"
)
<ExtensionAttribute>
Public Shared Function OutFullJoin (
源表 As Object(,),
查询表 As Object(,),
源表keys As String,
查询表keys As String,
Optional 结果选择器 As Func(Of Object(), Object(), Object()) = Nothing,
Optional 空行显示 As Object = "",
Optional keys分隔符 As String = "@^@"
) As IEnumerable(Of Object())
Dim 源表 As Object(,)
Dim 查询表 As Object(,)
Dim 源表keys As String
Dim 查询表keys As String
Dim 结果选择器 As Func(Of Object(), Object(), Object())
Dim 空行显示 As Object
Dim keys分隔符 As String
Dim returnValue As IEnumerable(Of Object())
returnValue = 源表.OutFullJoin(查询表,
源表keys, 查询表keys, 结果选择器, 空行显示, keys分隔符)
- 源表 Object
-
- 查询表 Object
-
- 源表keys String
-
- 查询表keys String
-
- 结果选择器 FuncObject, Object, Object (Optional)
-
- 空行显示 Object (Optional)
-
- keys分隔符 String (Optional)
-
IEnumerableObject在 Visual Basic 和 C# 中，这个方法可以当成为类型
Object 的实例方法来调用。在采用实例方法语法调用这个方法时，请省略第一个参数。请参考
扩展方法 (Visual Basic) 或
扩展方法 (C# 编程指南) 获取更多信息。