LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

Two strings in two columns in Exel?

Hi. Again...
Now I have two strings I want to present in two columns in Exel. How do I do
this?
I have only managed to get them in one column, one string after the other...

/Peter Jansson,
Teracom Systemservice Malmoe Sweden
http://www.teracom.se
0 Kudos
Message 1 of 6
(3,777 Views)
Did you have a look in the NI Examples database? Search for
Excel and you'll find some interesting examples about that
fact, they helped me, hope thy'll help you so.

Gorka Larrea
glarrea_1@hotmail.com



* Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful
0 Kudos
Message 2 of 6
(3,777 Views)
I can´t seem to find a solution to tjis problem...
But here is a thought: If I take my two strings and wire the to some kind of
table. Will it work?
I´ve managed to get the two column headers correct by using a String Table.
But how do I wire String1 to column1 and string2 to column2?
I´ve looked aruond on the NatInst homepage, but I cuould´nt find any good
solution to this problem.
Thank´s again!

--
/Peter Jansson,
Teracom Systemservice Malmoe Sweden
http://www.teracom.se
"Peter Jansson, Teracom Malmoe" skrev i meddelandet
news:963492708.951375@proxy2...
> Hi. Again...
> Now I have two strings I want to present in two columns in Exel. How do I
do
> this?
> I have only managed to get them in one column, one string after the
ot
her...
>
> /Peter Jansson,
> Teracom Systemservice Malmoe Sweden
> http://www.teracom.se
>
>
0 Kudos
Message 3 of 6
(3,777 Views)
On Fri, 14 Jul 2000 09:09:31 +0200, "Peter Jansson, Teracom Malmoe"
wrote:

>I can´t seem to find a solution to tjis problem...
>But here is a thought: If I take my two strings and wire the to some kind of
>table. Will it work?
>I´ve managed to get the two column headers correct by using a String Table.
>But how do I wire String1 to column1 and string2 to column2?
>I´ve looked aruond on the NatInst homepage, but I cuould´nt find any good
>solution to this problem.
>Thank´s again!
>
I don't know if i understand your problem.
But to write a string in a desired cell, you can use
an invoke node of an worksheet. There you can select the
method "range". Set the range wherever you want and add
a property node. Here you can choose the "valu
e" item, which
is the content of the selected cell.
But this way to do is adopted from an NatInst example from
their website.
HTH Andreas
0 Kudos
Message 4 of 6
(3,777 Views)
Hi!
It´s seems like OverKill to me to use ActiveX...
I have my two strings, and want them in the cells next to each other in
separate columns.
It feels like it´s just to add a "column break" sign in my string.
Or am I just stupid here...?
Thanx.

--
/Peter Jansson,
Teracom Systemservice Malmoe Sweden
http://www.teracom.se
"Andreas Meyer" skrev i meddelandet
news:396f04dc.22540171@news.ri.dasa.de...
> On Fri, 14 Jul 2000 09:09:31 +0200, "Peter Jansson, Teracom Malmoe"
> wrote:
>
> >I can´t seem to find a solution to tjis problem...
> >But here is a thought: If I take my two strings and wire the to some kind
of
> >table. Will it work?
> >I´ve managed to get the two column headers correc
t by using a String
Table.
> >But how do I wire String1 to column1 and string2 to column2?
> >I´ve looked aruond on the NatInst homepage, but I cuould´nt find any good
> >solution to this problem.
> >Thank´s again!
> >
> I don't know if i understand your problem.
> But to write a string in a desired cell, you can use
> an invoke node of an worksheet. There you can select the
> method "range". Set the range wherever you want and add
> a property node. Here you can choose the "value" item, which
> is the content of the selected cell.
> But this way to do is adopted from an NatInst example from
> their website.
> HTH Andreas
0 Kudos
Message 5 of 6
(3,777 Views)
"Peter Jansson, Teracom Malmoe" wrote:

> Hi!
> It´s seems like OverKill to me to use ActiveX...
> I have my two strings, and want them in the cells next to each other in
> separate columns.
> It feels like it´s just to add a "column break" sign in my string.
> Or am I just stupid here...?
> Thanx.
>
> --
> /Peter Jansson,
>

I am not entirely sure I understand what you want to do.
Strings can be a bit tricky in Excel since it generally tries
to convert them to numbers.
You can try a couple of things:
write to strings to a file and seperate them with a comma.
the file should be filename.csv. The csv extension
tells Excel that this file has Comma Seperated Values.
Open the file with EXCEL and see if the strings are in the right places.
You c
ould try this using a TAB but will probably have to run the
Inport wizard.

If none of this works you may have to go with Active X.
Kevin Kent
0 Kudos
Message 6 of 6
(3,777 Views)