Announcements
..
Yes you can use javascript or even vbscript...Simply do a web search you will get articles in interacting with Excel.
not getting this from web please help me out from this can u please provide me a code regarding this like how to do that from java script
Javascript has better interaction for web pages.
Vbscript is better for Excel.
- Any specific reason you are looking for javascript?
- Will share code. Please show how your data in col1 is and what do you want to extract?
this is my data and i want to remove first three character of all data using js or vbscript anyone
could you please respond to all my questions for better understanding?
- How many rows are there in data table?
5000 rows
for knowledge purpose i want to do this with java script
you won't need any scripting.
Just search for the required string and replace it with blank values.
Text to replace is %""%
Hope the thread can be closed now :).
i know that but i want to do this with js and vb for knowledge purpose that i will aware about this and cant stuck in other task relating js and vb i will get the idea regarding this
vbscript to find and replace
https://devblogs.microsoft.com/scripting/how-can-i-replace-text-in-an-excel-spreadsheet/
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Jump in, show your community spirit, and win prizes!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Vish WR 386
Valantis 342
Haque 336