Exchange data with Microsoft Excel (Need some people to test this...)

Bean

I'm working on a project to document how to handle communications between the Propeller and Microsoft Excel.

If some of you guys (and gals) could test this and give me some feedback I would appreciate it.

Bean

This project will show how to transfer data between your propeller demo board and Microsoft Excel.

Step one - Program the Propeller Demo board with the "Excel Test.spin" code.
           This simple program simply receives a value and send back the value * 4
           Leave the demo board connected to the PC.

Step two - Start Microsoft Excel.
           Click on "tools->Options->Security->Macro Security..."
           On the "Security Level" tab, you must choose either "Medium" or "Low".
           Click "OK" to close the dialog boxes.


Step three - Open the "Excel Test.xls" file in Microsoft Excel.
             If you get are asked, you must click the "Enable Macros" button.
             Click on the "Test" button.

             To see the "Test" button VBA code press Alt-F11 and double-click on "Sheet1".
             To see the communication module code double-click on "Module1"

John Abshier

Worked on Windows 7 64 bit, Excell 2003, security set to medium

Edit: Excell is 32 bit version.

John Abshier

max72

Had to add "PtrSafe " to all declare. I received the error because I'm running the 64 bit version.
Now it works.

Massimo

Bean

Massimo,
I will correct that.

Thanks.

Bean

tdlivings

Ran fine on a Propeller Platform USB , Vista , Excel 2007.
It keeps plotting a line, I assume that is what is intended.
I did not know how to stop it , I clicked on the enable button in Parallax
Serial Term and it said no way that port is too busy so I clicked again on
your button in Excel that said working and Excel went dim indicating no longer
responding so I used task manager to kill it.

Interesting project
Tom

Bean

Tom,
No that is not what is should do.
It should draw the line once and then stop.
I'm not sure what happened there, but I'll explore it.

P.S. If it stops working before the Prop_Close is execute it won't be able to open the port. Simply unplug the usb cable and plug it back it and it will work.

Bean

GerryKeely

Hi

Works fine on proto board, windows vista home & excel 2007.

Gerry

tdlivings

I tried it again without the Parallax serial terminal running and it draws one line and stops.
I closed everything and repeated again with Parallax serial terminal now running if I click on
PST window a fight for the port appears to happen and I cannot get Excel back it goes to
Excel not responding mode.
Tom