1. transferring data from sequence to excel table
- Posted by tapueu at hotmail.com Jan 02, 2002
- 454 views
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> </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> </DIV> <DIV><FONT face=Arial size=2>ex.</FONT></DIV> <DIV><FONT face=Arial size=2>seq={{"Holmes","John"},{"Asian","Carrera"}}</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2>and it should give a table like this:</FONT></DIV> <DIV> </DIV> <DIV><FONT face=Arial size=2> A B</FONT></DIV> <DIV><FONT face=Arial size=2>1 Holmes John</FONT></DIV> <DIV><FONT face=Arial size=2>2 Asian Carrera</FONT></DIV> <DIV> </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> </DIV> <DIV><FONT face=Arial size=2>regards and thanks already,</FONT></DIV> ------=_NextPart_000_0009_01C1942C.29551C00--
2. Re: transferring data from sequence to excel table
- Posted by thinkways at YAHOO.COM Jan 06, 2002
- 474 views
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
3. Re: transferring data from sequence to excel table
- Posted by encephalon1 at msn.com Jan 06, 2002
- 454 views
------=_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> </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> </DIV>============ The Euphoria Mailing List ============<BR><BR>you might try an ODBC connection.<BR>--- tapueu at hotmail.com wrote:<BR>><BR>> Hello!<BR>><BR>> I need to transfer data from sequence to excel<BR>> table. how can I do it?<BR>><BR>> ex.<BR>> seq={{"Holmes","John"},{"Asian","Carrera"}}<BR>><BR>> and it should give a table like this:<BR>><BR>> A B<BR>> 1 Holmes John<BR>> 2 Asian Carrera<BR>><BR>> Now what I want is first to start my euphoria<BR>> program and create the sequence (already done). then<BR>> let my .exw program run, click myself to excel and<BR>> then by pressing some keys together (like Ctrl+T) my<BR>> proggie would automatically transfer all data to<BR>> excel and ------=_NextPart_001_0001_01C196B2.C0F2B080--