Jump to content

Sending data from Excel


Cartoony

Recommended Posts

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?

Link to comment
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.