Cartoony Posted September 1, 2016 Share Posted September 1, 2016 Apologies, I'm a complete novice so please be gentle! Default Send data from excel in php? Apologies for my ignorance, I feel that this should be possible but I have no idea how! I am building an electronic scoreboard, & the control program runs on a Raspberry Pi (running apache which serves it as a webpage to the control device - phone, laptop etc), which sends data to an Arduino Uno which controls the LEDs When you update the score on the control program (accessed through a web page interface), the Raspberry Pi builds a string of numbers separated by commas, & then sends this string to the Uno. The string is called 'tempstring' in the php file. Here's the php code: //$tempString="4,".$batsmana.",".$total.",".$batsmanb.",".$overs.",".$wicketsOnes.",".$target."#"; $tempString="4,".$batsmana.",".$total.",".$batsmanb.",".$wicketsOnes.",".$overs.",".$target."#"; echo $tempString; #echo($tempString." "); $serial->deviceOpen(); $serial->sendMessage($tempString); $serial->deviceClose(); Now, I have an Excel workbook that is a complete scoring program, not just a simple scoreboard controller. I have modified the workbook to create the data string in the exact same format as the Pi does. And now the question...... Is it possible to get Excel to send this string to either the Pi or the Uno (via the Pi) so that the scoreboard updates? Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.