Forum Discussion
baxatob
8 years agoCommunity Hero
If you need to do it with the help of TestComplete, please check this topic: https://support.smartbear.com/viewarticle/69443/
However you can use an external bindings like openpyxl for Python and so on.
- Raj278 years agoOccasional Contributor
thank you, But I need to upload some values into the excel sheet that are fetched from a windows application
- altemann8 years agoContributor
Hey! Maybe something like this will help you:
var values = [info coming from your app...]; function TextExcel() { var excel = Sys.OleObject("Excel.Application"); excel.DisplayAlerts = false; //No messages var book = app.Workbooks.Open("C:\\EXCELFILE"); //Path to your excel file var sheet = book.Sheets("Plan1"); //Name of the sheet for (x = 0; x < values.length; x++) { sheet.Cells(1, x+1) = values[x]; } book.Save(); app.Quit(); }
- Raj278 years agoOccasional Contributor
Could u update for VB Script
Related Content
Recent Discussions
- 4 hours agoSubhraDas
- 18 hours agoJacobjacob44