is it possible to add sheets to excel at runtime
- 2 Answers
- 4150 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / Ravikant Kumar
Microsoft Excel does not natively support adding sheets dynamically during runtime without manual intervention. However, you can use VBA (Visual Basic for Applications) macros or external libraries like EPPlus to automate the creation and manipulation of new worksheets within an Excel workbook.
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sadashivbyagi
using exportsheet syntax
datatable.exportsheet."path",1,1
| Is This Answer Correct ? | 1 Yes | 2 No |
I wnnt to learn about QTP Automation Framework,please give URL Address to get more information about AFW.
In QTP where i have to concentrate more in the Interview point of View
Can any body help me to write descriptive program to find a cell value (say 2 row, 3rd column) in a datatable which is creating dynamically and statically
In a WebTable 2nd row,3rd column contains one link and that link name is changing dynamically. How you will click the link?
what are the difference between qtp8.2 to 9.0 surya
How is a Step generator used in UFT?
what is the diff between manual test plan document and automation test plan doc.can u explain indetail.
It seems Interview questions from Ordain Solutions are almost BASIC LEVEL-Easy. I am asking one tough question..(I think.. May be easy for some people) In recorded script the - WebLink("cityinfo") In reality, the WebLink name is "generalinfo" How you can write function to click that changed web link. NOTE: This functin should work with any Dynamic text link. I will post the answer later.
This is Karthic and my mail id is karthic.venkitapathi@gmail.com, please give me an idea to crack qtp 10
1.How to find in which row or column,string "Hyderabad" exist in excel sheet? 2.How to find how many times character "a" repeated in a given string "Koteswararao"
what is virtual object?
How you know that a test case is a regression test case
WinRunner 
