English
Xebia - Select Query Using OLED
Silver Certified
1 reviews
40
Summary
When we are working on huge data sources in .xlsx format, then Select Queries becomes inefficient on DataTables
Overview
Benefits
Published: 11 Jan 2021 | Updated: 11 Jan 2021
Trusted Source
License
MIT
Code Language
Visual Basic
Runtime
.NET Framework
Tags
Compatibility
2019.4.2 Community Version
Dependencies
i. OLEDB Driver should be installed in the system. ii. UiPath Database package should be installed in the Studio. The users need to provide the following information on Config Files and they can directly establish connection with Excel sheet with the help of OLEDB. i. File Path ii. SheetName iii. Header Required or not iv. SQL
Support
Email: vbhardwaj@xebia.com
Mon-Fri 8AM to 6PM IST; Response time: 2 business day; Resolution time: 10 days
Similar Listings
Xebia - SQL Query Builder
SQL Query Builder for "OR" or "AND" Statement which can be used in select query in Database or DataTable
339
Bronze Certified
Supported by Publisher
Xebia - DataTable to HTML Table Conversion
This activity is capable of exporting DataTables into HTML format
6 reviews
450
Silver Certified
FPT Software - Build Query For Filter DataTable
This snippet helps to build the query to filter DataTable variable by Linq
15
Bronze Certified
Power Search Activity
This activity checks if values are present in a DataTable. It returns a Boolean and multiple dictionaries. A boolean variable is True when all values are present and if not, the following dictionaries are created: Present Values, Missing Values, Rest Values.
3
Bronze Certified
