Uipath Studio 代码读取Excel表并赋值给变量输出以供使用

Dim MyConnection As System.Data.OleDb.OleDbConnection
Dim DtSet As System.Data.DataSet
Dim MyCommand As System.Data.OleDb.OleDbDataAdapter
Try
'连接，Provider 指定的OLEDB提供程序的名称
MyConnection = New System.Data.OleDb.OleDbConnection("provider = Microsoft.ACE.OLEDB.12.0;Data Source='"& Excel路径 &"'; Extended Properties=Excel 12.0;")
'查询休假加班信息一览sheet页
MyCommand = New System.Data.OleDb.OleDbDataAdapter("select*from["sheet页名称" $]",MyConnection)
MyCommand.TableMappings.Add("sheet页名称","TestTable")
DtSet = New System.Data.DataSet
MyCommand.Fill(DtSet)'填充
attendancetable = DtSet.Tables.Item(0)'赋值
MyConnection.Close()'关闭
Catch ex As Exception
MsgBox(ex.ToString)
End Try

需安装 AccessDatabaseEngine扩展