Deal with .xls files.

[paul821102]

My LabVIEW vision is V7.1 ,in my case I have two files:

The first one such as:

SN:a

WL    PDL 

1590     0.32

1600     0.45

The second one such as:

SN:a

WL  PDL

1590    0.03

1600    0.04

I want to get a result the first file minus the second file such as:

SN:a

WL  PDL

1590  0.29                                             (0.32-0.03)This I don't need

1600  0.41                                             (0.45-0.04)

How can I get it? Any suggestion?

[Kenny_K]

You can open both files, index the array for the column that you want to subract, and then use the subract vi from the numeric pallete.  It will automatically subract the first element of array one from the first element of array 2, etc.

See the attached picture.

Kenny

[paul821102]

I have tried in the way you suggestion.

But the result I get in the file only has  the first row and the value is 0.

I don't know whether there is something wrong.

[Kenny_K]

I attached the vi with soime comments.  Let me know if you have any more questions.

Kenny

[elly.fan@ni.com]

index the array then substract the counterpart you needed

[paul821102]

Many thanks!