I would like to read a file and display the results in a table containing both strings and numbers?

[papish]

Hi,

I just need a simple way of doing this as at the moment, i read one line at the time containing strings and numbers, whenever i convert this line to an array i loose the strings, if i want to display it, it displays as a group of lines while i would like to display it as a table with column headers. The file is an .xls worksheet.

Any suggestions?

Thanks
Me

[PauloM]

Hi,

How are you getting data from the file? Using ActiveX or reading directly?
It seems to me that you have to convert everything into strings, and then build an array of strings, that can be directly connected to the property node strings[] of the table.

Hope this helps,
Paulo

[papish]

Thanks for the reply,
Im reading directly from the file. If i have to convert everything to a file, how do i build the array out of lines of strings?? its pretty lengthy to do so, or im i mistaken?
One question please, u mentioned ActiveX, how do i use ActiveX to read from the file if its easier, can u help.

Thanks Paulo



Hi,

How are you getting data from the file? Using ActiveX or reading directly?
It seems to me that you have to convert everything into strings, and then build an array of strings, that can be directly connected to the property node strings[] of the table.

Hope this helps,
Paulo

[PauloM]

Hi,

Look at attach vi.
If this is not what you need please clarify.

With ActiveX you can Open Excel, interact with it (read and write values to cells...
But if you can read it this way, I think it's easier.

Hope this helps,
Paulo

[papish]

That's pretty much it, thanks for this. I have been doing some really exagerating and lengthy bloc diagram that can just be replaced by a simple and small bloc. Thanks again.

PS: I just wonder if you can enlighten me about the use of ActiveX in interacting with Excel.



Hi,

Look at attach vi.
If this is not what you need please clarify.

With ActiveX you can Open Excel, interact with it (read and write values to cells...
But if you can read it this way, I think it's easier.

Hope this helps,
Paulo

[PauloM]

There are examples shipped with LabVIEW that demonstrate that functionality.
Got to Help -- Find Examples, Then choose "Comunicating with external applications", "ActiveX", "Excel".
There are 3 apps there that can help you.

Hope this helps,
Paulo