Hi, Everybody knows that if you want to obtain the names of excel sheets you have to use Excel application scope, get the wb as variable and then wb.GetSheets. BUT! If you don’t have excel installed this will cause an exception. SO… How can we read the excel sheets with Invoke code activity and…

@KevinDS , Try with this code, Dim fileName = "C:\ExcelFile.xlsx" Dim connectionString = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & fileName & ";Extended Properties=""Excel 12.0;IMEX=1;HDR=NO;TypeGuessRows=0;ImportMixedTypes=Text""" Using conn = New OleDbConnection(connectionString…

GetSheets with code activity and vb.net

Help

Anthony_Humphries (Anthony Humphries) April 20, 2020, 2:18pm 2

These may help you get started. The first one shows how create and use an Excel workbook object, and the second shows how to read the sheets.

1 Like

Topic		Replies	Views
Invoke Code for ActiveSheet Name Help	3	2227	April 4, 2019
Get sheets without using excel scope Activities excel	5	1732	October 19, 2020
Get sheetname without scope Studio excel , activities	1	799	March 9, 2020
Invoke code activity in editing excel file Help	3	3090	January 14, 2019
REMOTE DESKTOP INVOKE CODE ACTIVITY VB.NET Code not working Something Else feedback	1	847	May 24, 2021

GetSheets with code activity and vb.net

Related topics