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 worksheet = workbook.Sheets(1)

'MsgBox worksheet.Cells(2,2)

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
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

---------------------------------------------------------------------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------------------------------------------------------------------

[ors]

Hi. Can u help me? How can I make a script to stop an infinit vbs loop?

[liameneuk]

Looks like this editor isn't a native MS product. The question therefore is is it safe and trustworthy in the first place?

[punithraj]

Sir please help it is urgent i need it to implement on my project

[punithraj]

Sir at which line should i need to mention Excel folder path