November 24th, 2020, 01:39 AM
I have shared the sample input XML, script, and generated excel in the following link. Please follow the steps written in ReadMe.txt attached in the same link to execute the excel writing.
I have...
November 11th, 2020, 03:00 AM
xml size is 48 KB and generated Excel will be around 10 MB.
In Task manager everything seems to be fine.
Vb script logic is simple like,reading the xml nodes and writing into excel cell.
November 10th, 2020, 01:48 AM
Below table is the bench marking time of excel writing in 3 different machine and added observation on same machine also(same machine also excel writing is taking different time Refer row1 and row2)....
November 9th, 2020, 11:51 PM
No, reading the xml which is there in the system only.
November 9th, 2020, 11:31 PM
Same script to read the same "xml and write it into excel" on same machine also taking different time.
November 9th, 2020, 08:05 AM
OS might be differ, but VB script is same for all machines.
And in same machine also we are facing the same issue.
November 9th, 2020, 07:28 AM
Excel writing time is inconsistent.
We are having vb script to read XML and write it into excel.In one machine excel writing is taking 15 mins in another
machine it is taking more than 1 hr....