Hi,
How can I delete a column in excel, The code below doesn't work
function Test1()
{
var excelFile = Excel.Open("C:\\ELink\\Logs\\testlogs.xlsx");
var excelSheet = excelFile.SheetByTitle("Sheet1");
excelSheet.Range("2:2").Delete; // This doesn't work
excelFile["Save"]();
}
Any help would be appreciated.
Thanks,
Hina
My own preference is to skip unneeded data rather than deleting it. What are you trying to do in your test?
I am trying to compare 2 excel files, both excel files have datetime column that I don't want to compare. The tool I am using doesn't skip the column it compares the files as it is. So before using that tool, I am trying to get rid of datetime column from both excel files. Is there a way to delete the column through TestComplete.
Thanks,
Hina
