Excel/js

76 views
Skip to first unread message

Kim Skatun

unread,
Dec 6, 2012, 10:31:03 AM12/6/12
to tiddl...@googlegroups.com
I am trying to get my tiddlywiki to talk to excel, i pasted this code into a tiddler, but only the first msgBox shows up...

<html>

<head>
<script>
window.onClickAction = function myFunction()
{
alert('Hello from JavaScript!')
var exApp = new ActiveXObject("Excel.Application");
  

 exApp.Workbooks.Open("c:\\Test.xlsx");
 
 exApp.Visible = true;
 exApp.UserControl = true;
 exApp.Range("A2").Select()
 exApp.ActiveCell= "hello world"

  alert('Hello from JavaScript!')
}
</script>
</head>


<form name=myform>
<input type=button value="Try it now" 
onClick="onClickAction()">
</form>


</html>

whatever

unread,
Dec 6, 2012, 11:20:03 AM12/6/12
to TiddlyWiki
Hi!
ActiveXObject only works in Internet Explorer, if I'm not mistaken.
But if you do get it to work (even if just in IE), I'm sure plenty
people would be interested in seeing how you pulled it off.

w

Kim Skatun

unread,
Dec 6, 2012, 11:36:45 AM12/6/12
to tiddl...@googlegroups.com
Well i was using IE, but it didn't work....


--
You received this message because you are subscribed to the Google Groups "TiddlyWiki" group.
To post to this group, send email to tiddl...@googlegroups.com.
To unsubscribe from this group, send email to tiddlywiki+...@googlegroups.com.
For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en.




--
Kindly regards
Kim Skåtun
+47 950 53 328
ska...@gmail.com
5643 Strandvik
Norway

Kim Skatun

unread,
Dec 10, 2012, 7:53:10 AM12/10/12
to tiddl...@googlegroups.com
Maybe its easier to write to a xml file and then read the xml file in excel?
To unsubscribe from this group, send email to tiddlywiki+unsubscribe@googlegroups.com.

For more options, visit this group at http://groups.google.com/group/tiddlywiki?hl=en.

Reply all
Reply to author
Forward
0 new messages