1. transferring data from sequence to excel table

This is a multi-part message in MIME format.

------=_NextPart_000_0009_01C1942C.29551C00
	charset="iso-8859-1"

Hello!

I need to transfer data from sequence to excel table. how can I do it?

ex.
seq={{"Holmes","John"},{"Asian","Carrera"}}

and it should give a table like this:

             A                    B
1       Holmes             John
2        Asian             Carrera

Now what I want is first to start my euphoria program and create the sequence
(already done). then let my .exw program run, click myself to excel and then by
pressing some keys together (like Ctrl+T) my proggie would automatically transfer
all data to excel and create table like I described above.

regards and thanks already,
--Talvitie

------=_NextPart_000_0009_01C1942C.29551C00
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content="text/html; charset=iso-8859-1" http-equiv=Content-Type>
<META content="MSHTML 5.00.2614.3500" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>Hello!</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>I need to transfer data from sequence to excel 
table. how can I do it?</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>ex.</FONT></DIV>
<DIV><FONT face=Arial 
size=2>seq={{"Holmes","John"},{"Asian","Carrera"}}</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>and it should give a table like this:</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial 
size=2>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
B</FONT></DIV>
<DIV><FONT face=Arial size=2>1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Holmes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
John</FONT></DIV>
<DIV><FONT face=Arial size=2>2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Asian&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 
Carrera</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>Now what I want is first to start my euphoria 
program and create the sequence (already done). then let my .exw program run, 
click myself to excel and then by pressing some keys together (like Ctrl+T) my 
proggie would automatically transfer all data to excel and create table like I 
described above.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=Arial size=2>regards and thanks already,</FONT></DIV>

------=_NextPart_000_0009_01C1942C.29551C00--

new topic     » topic index » view message » categorize

2. Re: transferring data from sequence to excel table

you might try an ODBC connection.
--- tapueu at hotmail.com wrote:
> 
> Hello!
> 
> I need to transfer data from sequence to excel
> table. how can I do it?
> 
> ex.
> seq={{"Holmes","John"},{"Asian","Carrera"}}
> 
> and it should give a table like this:
> 
>              A                    B
> 1       Holmes             John
> 2        Asian             Carrera
> 
> Now what I want is first to start my euphoria
> program and create the sequence (already done). then
> let my .exw program run, click myself to excel and
> then by pressing some keys together (like Ctrl+T) my
> proggie would automatically transfer all data to
> excel and create table like I described above.
> 
> regards and thanks already,
> --Talvitie
> 
>
> 
> 
>
> 


=====
ThinkWays! a  modular and distributed technical information environment from
Modular Reality systems.
http://www.geocities.com/SiliconValley/Lab/7577
Live: Useless Web Camera
http://www.geocities.com/SiliconValley/Lab/7577/camera.htm
Commuter Hell!
http://www.geocities.com/SiliconValley/Lab/7577/commute/commute.htm

new topic     » goto parent     » topic index » view message » categorize

3. Re: transferring data from sequence to excel table

------=_NextPart_001_0001_01C196B2.C0F2B080

I'm not sure if there are any API's for this in Euphoria, but you could also
link to excel as an activeX object; I've done this with vbscript, but then again
vbscript was made for that purpose.

----- Original Message -----
From: thinkways at YAHOO.COM
Subject: Re: transferring data from sequence to excel table


you might try an ODBC connection.
--- tapueu at hotmail.com wrote:
>
> Hello!
>
> I need to transfer data from sequence to excel
> table. how can I do it?
>
> ex.
> seq={{"Holmes","John"},{"Asian","Carrera"}}
>
> and it should give a table like this:
>
>              A                    B
> 1       Holmes             John
> 2        Asian             Carrera
>
> Now what I want is first to start my euphoria
> program and create the sequence (already done). then
> let my .exw program run, click myself to excel and
> then by pressing some keys together (like Ctrl+T) my
> proggie would automatically transfer all data to
> excel and create table like I described above.
>
> regards and thanks already,
> --Talvitie
>
>


=====
ThinkWays! a  modular and distributed technical information environment from
Modular Reality systems.
http://www.geocities.com/SiliconValley/Lab/7577
Live: Useless Web Camera
http://www.geocities.com/SiliconValley/Lab/7577/camera.htm
Commuter Hell!
http://www.geocities.com/SiliconValley/Lab/7577/commute/commute.htm




------=_NextPart_001_0001_01C196B2.C0F2B080
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: 8bit

<HTML><BODY STYLE="font:10pt verdana; border:none;"><DIV>I'm not sure if there
are any API's for this in Euphoria, but you could also link to excel as an
activeX object; I've done this with vbscript, but then again vbscript was made
for that purpose.</DIV> <DIV>&nbsp;</DIV> <BLOCKQUOTE style="PADDING-RIGHT: 0px;
PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid;
MARGIN-RIGHT: 0px"> <DIV style="FONT: 10pt Arial">----- Original Message
-----</DIV> <DIV style="BACKGROUND: #e4e4e4; FONT: 10pt Arial; COLOR:
black"><B>From:</B> thinkways at YAHOO.COM</DIV> <DIV style="FONT: 10pt
Arial"><B>Sent:</B> Sunday, January 06, 2002 12:22 PM</DIV> <DIV style="FONT:
10pt Arial"><B>To:</B> EUforum</DIV> <DIV style="FONT: 10pt
Arial"><B>Subject:</B> Re: transferring data from sequence to excel table</DIV>
<DIV>&nbsp;</DIV>============ The Euphoria Mailing List ============<BR><BR>you
might try an ODBC connection.<BR>--- tapueu at hotmail.com wrote:<BR>&gt;<BR>&gt;
Hello!<BR>&gt;<BR>&gt; I need to transfer data from sequence to excel<BR>&gt;
table. how can I do it?<BR>&gt;<BR>&gt; ex.<BR>&gt;
seq={{"Holmes","John"},{"Asian","Carrera"}}<BR>&gt;<BR>&gt; and it should give a
table like
this:<BR>&gt;<BR>&gt;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
A&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
B<BR>&gt; 1&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Holmes&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
John<BR>&gt; 2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Asian&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
Carrera<BR>&gt;<BR>&gt; Now what I want is first to start my euphoria<BR>&gt;
program and create the sequence (already done). then<BR>&gt; let my .exw program
run, click myself to excel and<BR>&gt; then by pressing some keys together (like
Ctrl+T) my<BR>&gt; proggie would automatically transfer all data to<BR>&gt; excel
and
------=_NextPart_001_0001_01C196B2.C0F2B080--

new topic     » goto parent     » topic index » view message » categorize

Search



Quick Links

User menu

Not signed in.

Misc Menu