Lire un fichier Excel sur labview

[ekrep]

Bonjour à tous, 

Je demande de l'aide car, j'essaye de dépanner un programme labview que je n'ai pas conçu. 

Le programme labview lis un fichier xlsx ou CSV (j'ai essayé dans les deux cas) afin d'envoyer plusieurs niveau de tension. 

Je tiens à préciser que le programme fonctionnait bien de base, mais du jour au lendemain plus rien, j'ai donc re installer excel reconfiguré au cas où il y avait une potentielle mise a jour de faite mais rien non plus de ce côté. J'ai beau avoir poncer les forums et les recherches mais rien de positif. 

 

 

[ekrep]

45 minutes ago, ekrep said:

Bonjour à tous, 

Je demande de l'aide car, j'essaye de dépanner un programme labview que je n'ai pas conçu. 

Le programme labview lis un fichier xlsx ou CSV (j'ai essayé dans les deux cas) afin d'envoyer plusieurs niveau de tension. 

Je tiens à préciser que le programme fonctionnait bien de base, mais du jour au lendemain plus rien, j'ai donc re installer excel reconfiguré au cas où il y avait une potentielle mise a jour de faite mais rien non plus de ce côté. J'ai beau avoir poncer les forums et les recherches mais rien de positif. 

 

 

 

[Gribo]

Make sure your office installation has the same bitness as LabVIEW. 64-bit office (most recent installations are 64 bits) won't work with LV 32bit.

[Rolf Kalbermatter]

20 hours ago, Gribo said:

Make sure your office installation has the same bitness as LabVIEW. 64-bit office (most recent installations are 64 bits) won't work with LV 32bit.

It could be made to work in the past. Basically the Office interfaces are all ActiveX based. ActiveX is very well able to invoke an ActiveX Automation Server out of process through an ActiveX proxy server process in the background. If the ActiveX Automation Server is properly registered this happens transparently in the background without extra user interactions. Unfortunately the so called Click to Run MS Office installers that are nowadays used, either forget to do the 32-bit registration of their Automation Server component or somehow bork it up. I have been in the past able to fix that on different machines by running a Repair Install from the Windows Applications control panel.

[ekrep]

On 12/10/2025 at 4:51 PM, Gribo said:

Make sure your office installation has the same bitness as LabVIEW. 64-bit office (most recent installations are 64 bits) won't work with LV 32bit.

Hello, 
When I try to debug I check the compatibility between the labview version and MS Office version there are no problem. 

 

[ekrep]

22 hours ago, Rolf Kalbermatter said:

It could be made to work in the past. Basically the Office interfaces are all ActiveX based. ActiveX is very well able to invoke an ActiveX Automation Server out of process through an ActiveX proxy server process in the background. If the ActiveX Automation Server is properly registered this happens transparently in the background without extra user interactions. Unfortunately the so called Click to Run MS Office installers that are nowadays used, either forget to do the 32-bit registration of their Automation Server component or somehow bork it up. I have been in the past able to fix that on different machines by running a Repair Install from the Windows Applications control panel.

Hello,
Yes I also check that there are no problem with ActiveX and I also try Repair Install but nothing happen, there are the same problem

[Rolf Kalbermatter]

On 12/12/2025 at 12:00 PM, ekrep said:

Hello,
Yes I also check that there are no problem with ActiveX and I also try Repair Install but nothing happen, there are the same problem

There is a good chance that Microsoft eventually dropped support in Office for 32-bit applications. What I wrote above was true 2015 - 2020. Haven't ever tried to use Excel from LabVIEW since, and generally use Libre Office anyhow if I need an Office application.

[ekrep]

19 hours ago, Rolf Kalbermatter said:

good

 

22 hours ago, Rolf Kalbermatter said:

There is a good chance that Microsoft eventually dropped support in Office for 32-bit applications. What I wrote above was true 2015 - 2020. Haven't ever tried to use Excel from LabVIEW since, and generally use Libre Office anyhow if I need an Office application.

What is the difference between libre office and MS office in labview ? Do you think that it will work correctly after this change ?  

[Rolf Kalbermatter]

On 12/15/2025 at 1:51 PM, ekrep said:

 

What is the difference between libre office and MS office in labview ? Do you think that it will work correctly after this change ?  

Libre Office/Open Office is an open source implementation of an Office suite of applications. It delivers similar application as the Microsoft Office package and they work in many ways similar but are not the same. If you are a seasoned Excel, Word or whatever user, they require a little bit of relearning and getting used to.

They support a 3rd party interface similar to the Microsoft Office Active X interface but it's not the same and will not work with the Report Generation Toolkit (RPT). One would need to write extra RPT plugins for that, except that while NI made the RPT plugin based, they kind of borked the instantiation of plugins by not making it easily extendable. The available plugins are hardwired in the implementation and extending that would require modifications to the NI implementation, which is considered by most developers a no go as you have to modify the Toolkit on every installation and reapply the modification anytime the Toolkit is reinstalled/updated by NI, which might or might not break your modifications too.

Edited Thursday at 10:04 AM by Rolf Kalbermatter

[Antoine Chalons]

En voyant le code, il me semble qu'il a été écrit pour lire un fichier csv, et il ne peut pas lire un fichier xls(x).

Si tu dis que ça marchait avant et que ça ne marche plus maintenant sans avoir changé le code, peut être as tu ouvert le fichier csv avec Excel et sauvé en xls(x)?

Vérifie le format de ton fichier, et le chemin du fichier lu par le logiciel.

 

Ensuite, si tu veux lire des données dans un fichier xls(x) au lieu de csv, il y a plusieurs méthodes, chacune a ses avantages et inconvénients..

- activeX, Windows only, nécessite Excel installé sur la machine 

- pandas, multi plateforme, nécessite python et pandas installé 

- vi de Darren (voir forum NI), ne marche pas avec toutes les versions d'excel, multi-platform

 

Bon courage !

 

[Lior Bilia]

For Libre/openOffice: