VBScript Excel Object Model | Read a cell value and display it | OpenExcelFile-ReadData from Excel

Code :

Set excelObject = CreateObject("Excel.Application")
excelObject.DisplayAlerts = False
Set objShell = CreateObject("Wscript.Shell")
excelFolderPath = objShell.CurrentDirectory
Set workbook = excelObject.Workbooks.Open(excelFolderPath&"\testExcel.xlsx")
Set worksheet = workbook.Sheets(1)

'MsgBox worksheet.Cells(2,2)

rows = worksheet.UsedRange.rows.count
columns = worksheet.UsedRange.columns.count

For i = 1 To rows
For j = 1 To columns
temp = temp & worksheet.Cells(i,j) & vblf
Next
Next

MsgBox temp

Set objShell = Nothing
Set worksheet = Nothing
Set workbook = Nothing
Set excelObject = Nothing

Excel Visual Basic (VBA) for Beginners
How to Import Excel into DataGridView Visual Basic
VBA in Excel - 103 Read a cell value and display it
VBScript Excel Object Model
VBScript-OpenExcelFile-ReadData from it-Excel File handling using VB Script
VBScript 10 Excel handling
Excel object model reference / open and save excel file by vbscript
Reading the data from excel sheets without hard coding row number and column number


#readExcel
#excelobjectmodel
#vbscript
#excelobjectmodelreference
#excel
#readDataFromExcel

Video Tags

0:00 - Introduction to read Excel Data from Vbscript
1:00 - VbsEdit Introduction
1:50 - Creating an Excel Object
3:40 - Creating a wscript.shell Object
4:53 - Creating a workbook Object
6:07 - Creating a worksheet Object
8:08 - Creating rows and columns objects
9:11 - Using For loop for rows and columns to print values
10:31 - Printing Excel Values
10:49 - Releasing memory for all the created objects
12:27 - End Tags and Subscription to the channel

Next Steps :

---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------
Must Watch Playlists

► 1. Javascript - https://youtube.com/playlist?list=PLO2l2fYgN805CokP5kaOWOhqP3-2vyXdS
► 2. Puppetter - https://youtube.com/playlist?list=PLO2l2fYgN805E5fbSnvtFM3K9c92ePS8e
► 3. Cypress - https://youtube.com/playlist?list=PLO2l2fYgN807KRpLfvvrqa1MSX8XdYxkV
► 4. Tech works - https://www.youtube.com/watch?v=ZNAdt4Oe5Sw&list=PLO2l2fYgN807CQ5H3ER__7x7LeEA10T2Z
► 5. Vbscript Basics To Advanced - https://www.youtube.com/watch?v=z_ctZDolyG0&list=PLO2l2fYgN805CuD-90ESrxRqX__-YJMym
► 6. Jmeter - https://youtube.com/playlist?list=PLO2l2fYgN806eNr5cr-TMTX8xGTW7Mtcn
► 7. Excel - https://youtube.com/playlist?list=PLO2l2fYgN806piZ2fD0bYNi3ExoPJlcqj
---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------