Forum

Notifications
Clear all

Real Time Data from RFID reader to Excel 2016

3 Posts
3 Users
0 Reactions
637 Views
(@sswcharlie)
Posts: 2
Active Member
Topic starter
 

Hi

 

Would like advice where to locate info about using a PN532 RFID reader (earlier readers were called RC522)  which has various communication available, I2C, SPI and HSU (High-Speed UART).  Would like RTD to go direct into Excel 2016 spreadsheet with focus, for later manipulation of data.

Read a 10 digit Alpha/numeric string at max of 2 or 3 per second, with long intervals (10 mins) until next set of tag reads.

Reader:     http://qqtrading.com.my/nfc-rfid-reader-module-pn532-v3-w-anthenna

Is there in Excel 2016, suitable (including VBA), app or add-in, to achieve above. Prefer not to include a microcontroller (Arduino), between PN532 board and PC, and which form of communication (in Excel 2016 already) to PC does work the best/simplest, for Excel 2016 to retrieve.    I2C, SPI or HSU.

 

Thankyou

 

Charles Harris

 
Posted : 24/12/2018 8:12 pm
Anders Sehlstedt
(@sehlsan)
Posts: 970
Prominent Member
 

Hello Charlie,

My experience with using barcode and RFID scanners with Excel has not shown any problems other than that you sometimes need to define the cells you are scanning to to be formatted as text. Is it any special issue you are thinking of or is perhaps experiencing?

Merry Christmas!

 
Posted : 25/12/2018 11:22 am
Philip Treacy
(@philipt)
Posts: 1629
Member Admin
 

Hi Charlie,

If the manufacturer doesn't provide a means for you to get the device data into Excel then I'm not sure how you would do it.

Microsoft have produced an add-in that is supposed to get RTD into Excel but from the examples I've seen, they use Arduino as an interface

https://www.microsoft.com/en-us/download/details.aspx?id=56976

Regards

Phil

 
Posted : 28/12/2018 6:06 am
Share: