LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

EXtraire données Labview vers Excel

Bonjour,

 

J'utilise un Digital Signal Oscilloscope (DSO 5200) connecté à mon ordi. Le but de mon travail est d'afficher dans labview l'évolution de mon signal venant d'un GBF puis de récupérer la tension et le temps pour les mettre dans un fichier txt et Excel.

 

Mon problème est que je n'arrive toujours pas à obtenir ni un fichier texte ni excel correct, j'obtient toujours des tonnes de pages de chiffres en fichier texte et je n'arrive pas à les classer dans un fichier Excel. Je voudrais pourtant simplement pouvoir récupérer les X et Y de mon graphe pour en faire un tableau de valeur.

 

Je vous joinds mon programme actuel, en espérant que quelqu'un pourra m'aider.

 

Merci d'avance ! 

0 Kudos
Message 1 of 3
(2,369 Views)

En pièce jointe mon VI

0 Kudos
Message 2 of 3
(2,342 Views)

Hello,

 

You're in the English section. Please post here if you want to write in French.

 

Your code would need to be improved and refactored because it's hard to read and you have parts of code which are not necessary.

 

You can use "Write to Spreadsheet File.vi" if you wish. In this case, here an example which uses this VI :

 

LabVIEW: Write and Read from Spreadsheet File without the Report Generation toolkit

 

You can also use "Write to Text File" function in order to write your data since Excel files are only a .txt with values which are separated by a tabulation.

If you choose this solution, there is an example provided in LabVIEW ("Write to Text File and Read from Text.vi" in "labview\examples\File IO\Text (ASCII)" directory)

 

You can also take a look at those examples :

 

Read/Write From/To Binary/Text File

 

Write Data to a Text File When it is a Multiple of X

 

Write Array of Data to Text File with Headers

 

In fact, there are lot of ways to create your report. You can choose the way you prefer but I suggest you to write in your loop rather than outside. It will allow you to customize each line and it will avoid you to lose all your data if you abort the VI's execution.

 

I attached to this post a simple example I created for writing two 1D arrays in a Spreadsheet File.

 

Be careful. Excel may be not fit for analyzing large volumes of scattered data. If you plan to store large amounts of data, you can take a look at NI DIAdem.

 

Regards

Jérémy C.
NI France

0 Kudos
Message 3 of 3
(2,323 Views)