How to reed data from 18F4550 EEPROM into EXCEL via PC USB interface?

[Bruce]

See this thread on USB changes to PBP 2.6: http://www.picbasic.co.uk/forum/show...5&daysprune=-1

I haven't used USB with PBP 2.6 yet, but there have been changes, and you may need a newer version of EasyHID also.

I dropped the .ocx in Windows/system, and just left the other vbskin files in the VB6 directory with the VB project files.

[ardhuru]

Hi, here are a few thoughts, some, all, or none of which might be of use.

1) The folks at Parallax have a free application, PLX DAQ (earlier StampDaq) that directly takes in data from the serial port and inserts them in a spreadsheet; you might have to play around with the data frame structures; http://www.parallax.com/tabid/393/Default.aspx If you use the CDC mode, the app might be able to take your data directly from the virtual com port, eliminating a USB-to-serial chip / adapter.

2) As Dave pointed out, again using CDC, you could spit out the data in your 3 columns in a 31 iteration loop, grab it on the PC with a terminal emulator (one that recognises virtual com ports), and simply copy-paste it into Excel. This technique I have tried (not with USB, with serial) to plot the discharge curve of a battery and works fine.

3) Take a look at Windmill software, http://www.windmill.co.uk/ as also another product from Parallax, http://www.parallax.com/ProductInfo/...1/Default.aspx

Regards,

Anand

[chuck]

Hi, here are a few thoughts, some, all, or none of which might be of use.

1) The folks at Parallax have a free application, PLX DAQ (earlier StampDaq) that directly takes in data from the serial port and inserts them in a spreadsheet; you might have to play around with the data frame structures; http://www.parallax.com/tabid/393/Default.aspx If you use the CDC mode, the app might be able to take your data directly from the virtual com port, eliminating a USB-to-serial chip / adapter.

2) As Dave pointed out, again using CDC, you could spit out the data in your 3 columns in a 31 iteration loop, grab it on the PC with a terminal emulator (one that recognises virtual com ports), and simply copy-paste it into Excel. This technique I have tried (not with USB, with serial) to plot the discharge curve of a battery and works fine.

3) Take a look at Windmill software, http://www.windmill.co.uk/ as also another product from Parallax, http://www.parallax.com/ProductInfo/...1/Default.aspx

Regards,

Anand

I was going to suggest that, But you would have to get written permission for bussiness use has you can us it and alter it for free for private use. If i remember there is one file that cannot be altered due to copyrights.
May be worth e-mailing them to ask and see what they say

[jellis00]

I was going to suggest that, But you would have to get written permission for bussiness use has you can us it and alter it for free for private use. If i remember there is one file that cannot be altered due to copyrights.
May be worth e-mailing them to ask and see what they say

Thanks, Chuck for ideas. Are you referring to Parralax or Windmill?

[chuck]

Thanks, Chuck for ideas. Are you referring to Parralax or Windmill?

I was referring to Parralax has this is a freeware not sure about the windmill software.
I've used the Parralax many of times and it really easy to use.

[jellis00]

I was referring to Parralax has this is a freeware not sure about the windmill software.
I've used the Parralax many of times and it really easy to use.

Thanks, Chuck. As I have said before, however, I must use it on a USB intereface for this particular application. Have you (or anyone else that might answer) ever been able to get Parralax to work with a USB interface between the PC and the PIC?? If I can verify that is doable I am going to give it a try.

[ardhuru]

From what I hear, USB-to-serial adapters work fine with PLX DAQ, BUT you have to make sure Windows assigns a lower com number (1 to 4) to the virtual serial port.

Regards,

Anand

[chuck]

Thanks, Chuck. As I have said before, however, I must use it on a USB intereface for this particular application. Have you (or anyone else that might answer) ever been able to get Parralax to work with a USB interface between the PC and the PIC?? If I can verify that is doable I am going to give it a try.

Sorry I have not tired the USB way, But I just used an RS232 chap and uploaded it via USB-to-serial cable and this works spot on. This was becasue the laptop does not a a serial port on it.
I have treid to do a search for usb into excel but never found anything, I shall carry and look and have ago at doing my own has USB is the way forwardm I susspose it easy to so once you have mastered it.