reading data from txt

[ander99]

i'm new to labview and currently i'm using labview 7.1. I got stuck on how to read data from .txt with few rows and 2 columns and once read from the .txt and how do i use the values obtain and add it to ms word. If possible to use the data after addition in ms word to obtain a graph based on the 2 columns value? Really need some ideas or help.

[MikeS81]

Hi ander99,

it sounds like the "Read From Spreadsheet File" function could help you. To write your data to word, you can use the Report Generation Toolkit.

Mike

[ander99]

Possible to create without using tat report generation kit? My problem is actually add the values in two files to produce values in a new sheet and based on the values to plot out a graph.

[MikeS81]

Hi ander99,

now i'm confused. Can you show what you have done since now and where you have problems? Where do you want to create a new sheet?

Mike

[ander99]

Sorry to cause confusion. this two files are generated by 2 different programs. I had to add the SP MH values in Test1.xls based on specific freq to Amp (dbm) in Test.doc and after adding generate a graph with freq vs amp(dbm).

[MikeS81]

Hi ander99,

you can use ActiveX functions to read the data from your excel file. For more information see this link, please. You can also use ActiveX to write your values to word.

Hope it helps.

Mike

[ander99]

I look thru that threads before. Thank anyway.

[ander99]

If possible to do without using ActiveX because i'm using LV7.1. Or someone is kind to give me an idea to do it.

[MikeS81]

Hi ander99,

you can use ActiveX with LV71. The example from the link before is for LV6 you can open them just fine with 71. The "ActiveX_for_Beginners.vi" shows how you can read your data. With some modifications you can read a range. If you change the data type at the "variant to data" block to a 2D array of what you need, then you have your data as an array in LabVIEW. The second part is to use Active X to create your diagram in word.

Where do you have currently problems? 

Mike

[ander99]

I'm having problem to read out data from the test1.xls which i upload.