LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

labview excel with activex

Solved!
Go to solution

Hello everyone,

during my intership i have a project where i have to add some data to an excel file which already exist, i have to use activex but no idea how to use it, is there some vi available where i can give a file and the coordinates of cells where to writte

using labview 2014, beginer on labview
0 Kudos
Message 1 of 27
(9,576 Views)
Solution
Accepted by topic author louis293

 

Try This

 

ExcelAccess.png

Pazhanivel Thiruvenkadam,
CertifiedLabVIEWArchitect|| CertifiedTestStandDeveloper,
Currently able to Access LV2015&LV2017
Message 2 of 27
(9,561 Views)

thanks a lot, do you by chance have the vi so that i can dowland it ?

using labview 2014, beginer on labview
Message 3 of 27
(9,549 Views)

i don't manage to drag and paste, can somebody put the VI file  please ? thanks in advance

using labview 2014, beginer on labview
0 Kudos
Message 4 of 27
(9,524 Views)

Hi Louis,

 

left-click the image to start the image viewer of the NI forum.

Then you will see a download button below the image: save the image to your harddrive.

Drag the image file from your harddrive into an empty VI block diagram.

Finished.

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO
0 Kudos
Message 5 of 27
(9,512 Views)

Thanks

well the probleme now is that i have the labview 2014, doesn't work with this file.

using labview 2014, beginer on labview
0 Kudos
Message 6 of 27
(9,509 Views)
Solution
Accepted by topic author louis293

Hi Louis,

 

here you go.

(You could state your LabVIEW version in your signature to aid other to provide VIs in the needed version…)

 

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO
Message 7 of 27
(9,502 Views)

thanks a lot, but it still doesn't work but i think it is an individual error (it will probably work on other computers), when i run an error occur , and when i open the excel file after it didn't change as expected and it is suddenly only lecture mode available

the error is error -2147352565 index not valid

 

using labview 2014, beginer on labview
0 Kudos
Message 8 of 27
(9,496 Views)

Hi Louis,

 

index not valid

The VI will select a certain Excel sheet: you have to provide a valid sheet name!

Best regards,
GerdW


using LV2016/2019/2021 on Win10/11+cRIO
0 Kudos
Message 9 of 27
(9,474 Views)

i think i gave a valid one, i used the path button to specify the file, i don't know what i can do better

using labview 2014, beginer on labview
0 Kudos
Message 10 of 27
(9,468 Views)