I have watched many tutorials and read a lot of blogs but couldn't find any solution. Does anyone know how I can "send and read an excel file from Esp8266 to Esp8266 via UART? Thanks
"Excel file" could mean a wide variety of things. Ultimately any file is just a stream of bytes and should offer no impediments to byte by byte transfer. Why do you think there might be a problem?I have watched many tutorials and read a lot of blogs but couldn't find any solution. Does anyone know how I can "send and read an excel file from Esp8266 to Esp8266 via UART? Thanks
thanks, is there any library for that?If what you mean is that you would like to send a whole load of data that can be loaded into Excel, then send it as a .csv file - that’s easy!
I don’t know - I don’t use software libraries, I write my own software.thanks, is there any library for that?
You can send any Excel (size restricted) file as a binary file from ESP to ESP over serial. To actually do something with the file means you need to decode the file format:I have watched many tutorials and read a lot of blogs but couldn't find any solution. Does anyone know how I can "send and read an excel file from Esp8266 to Esp8266 via UART? Thanks
The file is just binary. It can be sent by a variety of methods in the format. If you want to open and read the values in the spreadsheet, that's a different question because you would need to know the file format- and Microsoft hasn't published file formats for their files types in a number of decades (used to be everywhere).I have watched many tutorials and read a lot of blogs but couldn't find any solution. Does anyone know how I can "send and read an excel file from Esp8266 to Esp8266 via UART? Thanks
I am not sure what you are referring to, but the Office file formats have open documentation. For example, the XLS format. These docs are updated as version changes are made.The file is just binary. It can be sent by a variety of methods in the format. If you want to open and read the values in the spreadsheet, that's a different question because you would need to know the file format- and Microsoft hasn't published file formats for their files types in a number of decades (used to be everywhere).
Hey, @djsfantasi don’t forget X-Modem! I didn’t know if it was going to be X-Modem, X-Modem, or Kermit but I knew there would be at least one of those as an Arduino library.How did the Excel file get on the first ESP8266 in the first place? I don’t know if any version of Excel that runs on an ESP8266…
It then becomes a simple process of sending a binary file across a serial connection. I’m absolutely certain that you can find code to do that. Just as I am certain your won’t find a library…