LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

labview excel with activex

Solved!
Go to solution
Highlighted

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
(4,776 Views)
Highlighted
Solution
Accepted by topic author louis293

 

Try This

 

ExcelAccess.png

Palanivel Thiruvenkadam,
CLA|| CTD
Message 2 of 27
(4,761 Views)
Highlighted

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
(4,749 Views)
Highlighted

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
(4,724 Views)
Highlighted

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 LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
0 Kudos
Message 5 of 27
(4,712 Views)
Highlighted

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
(4,709 Views)
Highlighted
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 LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
Message 7 of 27
(4,702 Views)
Highlighted

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
(4,696 Views)
Highlighted

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 LV2011SP1 + LV2017 (+LV2020 sometimes) on Win10+cRIO
0 Kudos
Message 9 of 27
(4,674 Views)
Highlighted

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
(4,668 Views)