Hello guys, It's great to be here. I'm Manfred, A software developer with 3+ years experience. Looki

Hello guys, It's great to be here. I'm Manfred, A software developer with 3+ years experience. Looking forward to growing with y'all.

FFredObumma Hello guys, It's great to be here. I'm Manfred, A software developer with 3+ yea...

aymen ammari•5/13/24, 8:06 AM

Hi manfred, nice to have you here

youcef_ali•5/13/24, 9:07 AM

When we talk about wifi esp32 / esp8266 is the first choice, are ther other alternatives? There are any microcontrollers with built is wifi ?

Yyoucef_ali When we talk about wifi esp32 / esp8266 is the first choice, are ther other alte...

aymen ammari•5/13/24, 9:13 AM

Arduino MKR wifi
Raspberry pi ( for bigger projects)

Aaymen ammari Arduino MKR wifi Raspberry pi ( for bigger projects)

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

Raspberry pi we are talking about microprocessor and mpu this is heavy in price, energy consumption and need an os, you are right for bigger projects but what i'm looking for is for light weight applications (low energy, low cost, ...)

aymen ammari•5/13/24, 9:16 AM

Yeah then ARDUINO MKR WIFI 1010 is the best choice for you

Yyoucef_ali When we talk about wifi esp32 / esp8266 is the first choice, are ther other alte...

Umesh Lokhande•5/13/24, 9:18 AM

I used TI's CC3200 for evaluation purpose once

Hasib•5/13/24, 9:35 AM

HHasib Hi

aymen ammari•5/13/24, 9:53 AM

Heyaa

Hasib•5/13/24, 9:54 AM

Hello

Mouad•5/13/24, 9:55 AM

Hey everyone

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

Can you tell us about your technical background and what projects are you working on @Mouad @Hasibfrr

Aaymen ammari Can you tell us about your technical background and what projects are you workin...

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

I am a 2nd sem EEE student and I haven't done any project yet but I want to do

Mouad•5/13/24, 10:02 AM

I'm a master embedded degree student currently I'm working on academic project of building a smart greenhouse, nice to meet you

HHasib I am a 2nd sem EEE student and I haven't done any project yet but I want to do

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

What's on your mind, btw here in the community you can ask for help from anyone, there is me, wafa camila we're all down for any suggestions

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

As a EEE student what skills should I learn aside from college during persuing Btech

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

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

I am in 2nd sem now

MMouad I'm a master embedded degree student currently I'm working on academic project o...

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

Smart greenhouse, good that was my final project too, what microcontroller are using

HHasib As a EEE student what skills should I learn aside from college during persuing B...

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

First you have to learn the basic components all of them, how do they work, how do they interact with current and tension, then try board repair in the same time try understanding microcontrollers like atmega in arduinos, pic, and you will see are you a hardware person or software

Aaymen ammari First you have to learn the basic components all of them, how do they work, how ...

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

Basic components like resistor capacitor thermistor right??

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

Can you suggest a good YouTube channel?

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

For this kind of things

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

Yup, practically not theoretically

Aaymen ammari Yup, practically not theoretically

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

But how?

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

Make your own lab

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

You're an engineer you have to own at least a corner to learn techniques like soldering... Read schématiques... Test components

Naren_QCOM•5/13/24, 10:51 AM

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_QCOM•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_QCOM•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