Re: transferring data from sequence to excel table

new topic     » goto parent     » topic index » view thread      » older message » newer message 

------=_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 thread      » older message » newer message

Search



Quick Links

User menu

Not signed in.

Misc Menu