Excel data analysis in cvi

[krekeren123]

Hello! 

I have read some of the posts regarding Excel. 

Id like to write a program that can read an Excel sheet and do a sorting for it. 

for name = (user input) 

    for type = (user input) 

       for hours > (user input)  && hours < (user input) 

            for material = (user input) 

                      plotxy, scatter graph  y- materiel data, x - hours 

i know the column place of all of it, and the number of lines in the excel sheet, and i want it to do the cut. 

also, name isn't specific, it must include- the user can input - mike, but i want it to include mike, mikee, gmike, 950mike. 

whats the best way to do it? 

[RobertoBozzolo]

First of all, CVI cannot operate natively on Excel files, it relies on an instance of the program being installed on the PC where the application is executed instead: it connects to Excel via ActiveX and operates on that instance opening, reading, writing and saving files. This implies that you must have a full Excel install both on the developing machine and on the target machine, if they are different.

Given this, I suggest you to study excel2000dem example program that gives you a framework to start with for your final application. The sample program demonstrates how to read from an excel sheet and locate individual cells so you can adapt it to your needs.