Contributions
Re: delete a row in an excel file
Alex, I found that I need to access the excel com directly to at least delete a row. using this wkbExported = appExcel.Workbooks.Open("\\\\network\\\\folder1\\\\folder2\\\\folder3\\\\datafile_20210113.csv"); wkbExported.ActiveSheet.Range("1:1").Delete(); or to delete columns using this: wkbExported.ActiveSheet.Range("J:J").Delete(); Is there a paste option when copying from one file to another? I need to paste a large amount of data from one spreadsheet to another. Please advise.1.7KViews0likes2CommentsRe: delete a row in an excel file
Data from Excel 1 and Excel 2 come from outside data sources. Excel 3 contains formulas which will compute the information from Excel 1 and Excel 2. The data itself is not actually important, I just need to delete specific rows from the spreadsheet.1.8KViews0likes0CommentsRe: delete a row in an excel file
Actually the task is a little bit trickier then that. I have three excel files. I need to manipulate each one, for example Excel1 - delete the first five rows and the last row of data, then copy all data in three columns and paste into Excel3. Excel 2 - copy data from three columns and then paste into Excel3 This kind of task was doable in UFT, but now that I am using Test Complete, it's a lot different. Any help is appreciated.1.8KViews0likes2Commentsdelete a row in an excel file
I am attempting to use this line of code from a very old post: oWorkbook.ActiveSheet.Rows(2).Delete; This doesn't seem to work. The Test Complete type ahead only contains Cell, CelCount and Row Count. I simply want to delete one row or a range of rows from an excel file. Any assistance is appreciated.Solved1.8KViews0likes9Comments