Does anyone know how to create and write data in .xlsx file into the SD card using any microcontroll

Does anyone know how to create and write data in .xlsx file into the SD card using any microcontrollers like stm32, esp32?

Aaymen ammari You're an engineer you have to own at least a corner to learn techniques like so...

Hasib•5/13/24, 10:53 AM

I have financial problems sir

I depend on scholarship for fees payments

aymen ammari•5/13/24, 10:56 AM

Yeah that's would be a problem, but I hope you'll get threw it

Aaymen ammari Yeah that's would be a problem, but I hope you'll get threw it 🤍

Hasib•5/13/24, 10:58 AM

are there any side hustles?

aymen ammari•5/13/24, 10:58 AM

Half time job

Hasib•5/13/24, 10:59 AM

Like?

Hasib•5/13/24, 11:04 AM

Example

Hasib•5/13/24, 11:16 AM

aymen ammari•5/13/24, 11:17 AM

Like freelance work, Home Electricity

aymen ammari•5/13/24, 11:17 AM

Online jobs

Hasib•5/13/24, 11:24 AM

Where can I find this?

aymen ammari•5/13/24, 11:27 AM

In your area, ofc

Hasib•5/13/24, 11:28 AM

Thanks

Hasib•5/13/24, 11:29 AM

Now what I can learn online?

Hasib•5/13/24, 11:29 AM

For skills

NNaren_QCOM Does anyone know how to create and write data in .xlsx file into the SD card usi...

techielew•5/13/24, 11:33 AM

I don’t understand the question can you please clarify?

Ttechielew I don’t understand the question can you please clarify?

Naren_QCOMOP•5/13/24, 12:23 PM

I'm trying to write different frequencies of data into excel workbook in SD card using STM32 uC. I want to write different frequencies of data in different sheets in a same excel workbook.

I want to do this using STM32, how can I do that?

NNaren_QCOM Does anyone know how to create and write data in .xlsx file into the SD card usi...

Renuel Roberts•5/13/24, 12:52 PM

Step 1: Set up the necessary hardware and connections.

- Connect the SD card module to the appropriate SPI (Serial Peripheral Interface) pins on your STM32 microcontroller.
- Ensure that you have the necessary hardware support for SD card communication, such as an SD card slot or an SD card breakout board.

Step 2: Install the required libraries and drivers.

- For the STM32 microcontroller, you can use the STM32Cube software suite provided by STMicroelectronics, which includes a library called "FatFs" for SD card communication.
- Additionally, you'll need to download and install the appropriate library for Excel file manipulation.

Renuel Roberts•5/13/24, 12:52 PM

Step 3: Initialize the SD card and establish communication.

- Use the FatFs library to initialize the SD card and establish communication with the microcontroller.
- Refer to the FatFs library documentation and examples for detailed instructions on how to initialize the SD card and mount the file system.

Step 4: Create a new Excel workbook file on the SD card.

- Use the Excel file manipulation library to create a new Excel workbook file in memory.
- Some popular libraries for Excel manipulation are OpenXML (for creating Office Open XML-based files) and ExcelDataReader/ExcelWriter (for writing to Excel binary format).
- Follow the documentation and examples provided by the library you choose to create a new workbook file and set up the necessary data structure.

Step 5: Write the data for each frequency to a different sheet in the Excel workbook.

- Use the same Excel file manipulation library to generate the XML code for each sheet and append it to the Excel file.
- Create a new sheet for each frequency and populate it with the corresponding data.
- Repeat this process for each frequency you want to write.

Step 6: Close the Excel workbook file on the SD card and release resources.

- Use the appropriate functions from the Excel file manipulation library to close the workbook file and release any allocated resources.
- Ensure that all data has been properly saved and closed before proceeding.

Required Libraries:
- STM32Cube software suite (FatFs library): To manage the communication with the SD card.
- OpenXML SDK or ExcelDataReader/ExcelWriter: Choose one of these libraries for Excel file manipulation.
-

RRenuel Roberts Step 3: Initialize the SD card and establish communication. - Use the FatFs lib...

Naren_QCOMOP•5/13/24, 12:54 PM

I already tried this. FATFS library is not supporting excel file format (.xlsx)

If possible, can you please provide any resource link or example?

NNaren_QCOM I already tried this. FATFS library is not supporting excel file format (.xlsx) ...

Renuel Roberts•5/13/24, 1:00 PM

I apologize for the confusion. You are right, the FatFs library does not support the Excel file format directly. You will need to use a separate library for Excel file manipulation.

One popular library for Excel file manipulation is the OpenXML SDK. You can find more information and examples on how to create an Excel workbook using OpenXML in the official documentation: https://docs.microsoft.com/en-us/office/open-xml/how-to-create-a-spreadsheet-document-by-providing-a-file-name

Another option is to use the ExcelDataReader/ExcelWriter library, which allows you to read and write Excel binary format (.xls) files. You can find more information and examples on how to use ExcelDataReader/ExcelWriter on the official GitHub repository: https://github.com/ExcelDataReader/ExcelDataReader

Please note that both options mentioned above require you to manually generate the XML code for the Excel file structure. This can be a complex task, so I recommend thoroughly reading the documentation and examples provided with each library to understand the process and adapt it to your specific requirements.

I hope this helps! Let me know if you have any further questions.

GitHub

GitHub - ExcelDataReader/ExcelDataReader: Lightweight and fast libr...

Lightweight and fast library written in C# for reading Microsoft Excel files - ExcelDataReader/ExcelDataReader

RRenuel Roberts I apologize for the confusion. You are right, the FatFs library does not support...

Naren_QCOMOP•5/13/24, 1:04 PM

Thank you so much man!

I'll try this, then tell my feedback to you

RRenuel Roberts I apologize for the confusion. You are right, the FatFs library does not support...

Hasib•5/13/24, 1:15 PM

Can you provide a roadmap for embedded system

NNaren_QCOM Does anyone know how to create and write data in .xlsx file into the SD card usi...

youcef_ali•5/13/24, 1:18 PM

I recommend using .csv it is easy and you can deal with it as it is a txt file

Yyoucef_ali I recommend using .csv it is easy and you can deal with it as it is a txt file

Naren_QCOMOP•5/13/24, 1:19 PM

Yes, I know very well. I'm doing some experiments. So that I want to use .xlsx format

HHasib Can you provide a roadmap for embedded system

Naren_QCOMOP•5/13/24, 1:19 PM

Hasib•5/13/24, 1:20 PM

Resources?

NNaren_QCOM Yes, I know very well. I'm doing some experiments. So that I want to use .xlsx f...

youcef_ali•5/13/24, 1:20 PM

Ok good luck, please share with us if you have figured out a solution

Naren_QCOMOP•5/13/24, 1:21 PM

Sure

HHasib Resources?

Hasib•5/13/24, 1:21 PM

electro_coco•5/13/24, 1:53 PM

For learning purpose i decided to write my own Ethernet drivers and at least get ip.
I picked up enc28j60
I got the driver working and i also was able to send arp request and it was seen in Wireshark as well
But i still cannot see my mac bound to ip in my router
I am using esp32 and enc28j60 sheild
Anyone wants to join me in this adventure are welcome

LMtx•5/13/24, 2:03 PM

What is the optimal team size to design and deliver a high-profile initiative?

I worked at several companies, leading teams of various sizes (from 1 to 15 developers, depending on the initiative). Based on my experience, what matters is the seniority of a development team, not the headcount.

Various team sizes enforce different strategies and introduce versatile risks.

Based on your experience, what is the optimal number of senior developers working on a global-scale SaaS IoT platform backend?

MMarvee Amasi Welcome @mbana , what's like the most complex hardware system you have worked on...

embeē🚀🎮•5/13/24, 2:09 PM

That will be a smart parking system. Integrated fully, the solution points drivers to empty car parking spots in a mall or cinema or busy spots in the city where it is integrated.

Looking to integrate into existing apps like Google maps, so the drivers don't need to download any other app...it just pops up in your phone screen when you approach a building that has the solution

Eembeē🚀🎮That will be a smart parking system. Integrated fully, the solution points drive...

Marvee Amasi•5/13/24, 2:16 PM

Nice stuff, I would love to know much about how the system works , e.g , how does it detect empty parking spots , and how does it integrate with Google Maps to provide a seamless experience for drivers
@mbana

Mybear•5/13/24, 7:24 PM

Mybear•5/13/24, 7:25 PM

i build little websocket real time tracking robot on the maps and i wish programme arduino but i have many error of importation librairy

Mybear•5/13/24, 7:25 PM

C:\Users\duodj\Documents\Arduino\libraries\ArduinoWebsockets\src/tiny_websockets/internals/ws_common.hpp:4:10: fatal error: string: No such file or directory
#include <string>
^~~~
compilation terminated.
exit status 1

Mybear•5/13/24, 7:26 PM

exmple of error we can't see that talk about string that not includ i think dependance are not setup well

Saßì•5/14/24, 2:41 AM

@NovaKnight96 @Enthernet Code @Mouad @Hasibfrr @mbana

@scottA @816913 @vonfor Welcome to the community! We're eager to learn more about you. Can you introduce yourself and tell us about your professional life?

MMybear exmple of error we can't see that talk about string that not includ i think depe...

wafa_ath•5/14/24, 8:07 AM

Yes , i think just include the library by going to Sketch -> Include Library -> Manage Libraries.
Search for "String" or "Standard C++" and add it

Saßì•5/14/24, 8:32 AM

Friendly reminder about Upcoming Event
https://discord.com/invite/EAGj9WyK?event=1239564927912513589

youcef_ali•5/14/24, 8:42 AM

team what do you know about the battery management IC

SSaßì ** Friendly reminder about Upcoming Event** https://discord.com/invite/EAGj9WyK?...

wafa_ath•5/14/24, 10:13 AM

What it's going to be about this week

wafa_ath•5/14/24, 5:56 PM

I found a great website that keeps your electrical work

clean and meets all international quality standards in electricity

This website includes:

Various tools and equipment used by electricians, with all their specifications.

Everything related to APIs and their datasheets.

Summaries of all the rules and fundamentals of motors and their control.

Various installations in industrial electricity and BTE.

Explanation of various electrical standards NF C.

And the best thing about it is that it has Excel sheets, guides, and customizable templates to help you with power balance and calculate the parameters you need for your electrical work.

So, share with us a website that helps you with your electrical work..
https://www.volta-electricite.info/

Volta Electricite

Site dédié à l'électricité industrielle, bâtiment et bricolage. Les principaux savants, téléchargements gratuits de formulaires sous Excel, des schémas électriques, des infos sur l'appareillage électrique, forum d'aide, photos d'électricité gratuites, calculettes... Dépôt gratuit de petites annonces d'offre ou demande d'emploi.

Camila_99$$•5/14/24, 10:31 PM

Thanks @wafa_athmani

Saßì•5/15/24, 4:24 AM

@lene @Edgar René Pescador @scottA @816913 @NovaKnight96 Welcome to the community! We're eager to learn more about you. Can you introduce yourself and tell us about your professional life?

aymen ammari•5/15/24, 6:01 AM

Hi everyone, anyone has experience with battery chargers, I have 38v one, and label says : charging voltage 48v, and now I'm confused wich charger I can use for it.. And How I can wire it to the battery?

Accur4te•5/15/24, 7:07 AM

Hi devs , is there any way to read rs485 output , using a arduino ?

AAccur4te Hi devs , is there any way to read rs485 output , using a arduino ?

aymen ammari•5/15/24, 7:14 AM

Hi, sure you can read this article that talks about that
https://circuitdigest.com/microcontroller-projects/rs485-serial-communication-between-arduino-uno-and-arduino-nano

RS485 Serial Communication between Arduino Uno and Arduino Nano

youcef_ali•5/15/24, 9:39 AM

Hi team, i would like to record an analog signal of 70mghz frequency min, how do i proceed, the time is max 16 min of recording

Does anyone know how to create and write data in .xlsx file into the SD card using any microcontroll

Similar Threads

Similar Threads

Similar Threads