Dear all,
I have written a program to read and write the data in the
excel using ActiveX sheet but crashes the Labview drastically when
executed.
Please go through the attached files.
Actually the program has to sort the data in ascending order in a
column in a
Specified worksheet and it should write the sorted data in another
worksheet in the same excel file itself. But while writing it should
neglect the repeating data and should write the corresponding data in
the other column with respect to sorted one.
For example , In datafile.xls in sheet1 cells are like below. Let a,
b & g are columns
a1=0.02, b1=2.1 , g1=0.1
a2=0.04, b2=4.2 , g2=0.3
a3=0.05, b3=4.2 , g3=0.35
a4=0.06, b4=4.3 , g4=0.43
a5=0.0
7, b5=7.1 , g5=0.43
a6=0.08, b6=7.2 , g6=0.43
a7=0.09, b7=7.2 , g7=0.75
a8=0.11, b8=7.4 , g8=0.75