LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

problem using ActiveX for excel app to determine row/col no.s

Solved!
Go to solution

hello,

I would like to develop an app, which would find out the total no. of rows and columns from a given excel sheet and read out the data in the same. I have made use of few vi's I found on forum, but having trouble runing them,

can anyone please suggest me what could I be doing wrong? I have never used activex before...

Now on LabVIEW 10.0 on Win7
Download All
0 Kudos
Message 1 of 12
(6,667 Views)

What error you are getting, when you are trying to execute it.

0 Kudos
Message 2 of 12
(6,659 Views)

Have a look on this example, might help.

 

http://zone.ni.com/devzone/cda/epd/p/id/3187

0 Kudos
Message 3 of 12
(6,657 Views)

Hello Puneet, I am usnig the same example as the link you posted.

I would like to perform foll:

 

The user would enter data into an excel file and I would like to read the same in labview program. Since the no. of rows and columns of the data file is not fixed, I would liek to find out

the no. of rows and cols first and then read the entire file.

 

 

Now on LabVIEW 10.0 on Win7
0 Kudos
Message 4 of 12
(6,638 Views)
Solution
Accepted by topic author LV_Enthu

Hi,

 

I would have used the Free Excel Toolkit. See some example with it here, here and here

 

The library contains premade Excel ActiveX functions. This function right here would have helped you alot:

Get last row & col.png   

Regards,
Even
_________________________________
Certified LabVIEW Associate Developer

Automated Test Developer
Topro AS
Norway
0 Kudos
Message 5 of 12
(6,633 Views)

Even Deejay, what about the data in the excel sheet? how to extract that?? I can find the last row and column, ...

 

Now on LabVIEW 10.0 on Win7
0 Kudos
Message 6 of 12
(6,614 Views)

Also, i downloaded the toolkit you made, how can i use it? how to install it?

Now on LabVIEW 10.0 on Win7
0 Kudos
Message 7 of 12
(6,612 Views)

HiSmiley Happy

 

Yesterday I sent an email to a guy, explaining how to install it. Download the toolkit and the instructions I have attached and you should be fine.

 

Regards,
Even
_________________________________
Certified LabVIEW Associate Developer

Automated Test Developer
Topro AS
Norway
Download All
Message 8 of 12
(6,606 Views)

awesome.. taht helps...

g8 job 🙂

Now on LabVIEW 10.0 on Win7
Message 9 of 12
(6,594 Views)

You can also check ou tthe Excel Active X board where many items and examples are avaliable: There is really great stuff in there.

 

http://forums.ni.com/t5/BreakPoint/Excel-Board/td-p/379682

Tim
GHSP
0 Kudos
Message 10 of 12
(6,535 Views)