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

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

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

Yyoucef_ali Hi team, i would like to record an analog signal of 70mghz frequency min, how do...

onky•5/15/24, 9:55 AM

What kind of setup do you have? LabView with NI hardware might help. Or do you want to build your own hardware for this?

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

Yes, i have nothing starting from zero

Oonky What kind of setup do you have? LabView with NI hardware might help. Or do you w...

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

Yes, i have nothing starting from zero

onky•5/15/24, 9:57 AM

So I assume, you want design your own electronics.

onky•5/15/24, 2:00 PM

As per Nyquist criterion, your sampling frequency must be twice of measuring frequency, so your signal is 70 MHz, so fsample must be 140MHz, in this case you need ADC with 250Ms/s atleast, and depends on your measuring instrument memory you will have to transfer the measured data to larger memory multiple times in 16 mins as DSOs does not have large memory, this changes with resolution of ADC. Lower resolution lower data.

Saßì•5/15/24, 2:53 PM

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

youcef_ali•5/15/24, 3:14 PM

team i want to export this library to eclipse so i can use in a microcontroller please advise https://github.com/quiet/libfec/tree/master

GitHub

GitHub - quiet/libfec: Clone of Phil Karn's libfec with capability ...

Clone of Phil Karn's libfec with capability to build on x86-64 - quiet/libfec

Yyoucef_ali team i want to export this library to eclipse so i can use in a microcontroller ...

techielewOP•5/15/24, 5:05 PM

Mvoing to #coders-only-chat

aymen ammari•5/15/24, 7:44 PM

aymen ammari•5/15/24, 7:45 PM

Who can solve this quiz

techielewOP•5/15/24, 8:23 PM

Hey DevHeads, we want your feedback on the server structure. Can you cast your vote by thumbs upping or thumbs downing the proposal in the #announcements channel by Sunday, 5/19 at 15:00 GMT?

ezpz•5/16/24, 1:33 AM

Hey Guys,

I am currently working on a side project, where I images and text via nfc and display it on E-paper display. I am currently using arduino and pervasive epaper display. But I am not able to display png images. What image format should i use to transfer images via nfc?

Eezpz Hey Guys, I am currently working on a side project, where I images and text vi...

techielewOP•5/16/24, 3:44 AM

Have you tried jpg?

Aaymen ammari Click to see attachment

techielewOP•5/16/24, 3:45 AM

I added the letter comments so I can't vote

what you say, @PCB & Analog?

aymen ammari•5/16/24, 11:45 AM

Hi Devs, I want to share with you my experiment today, so my friend wanted to print a pcb with the fastes way possible, with high quality, and we didn't want to use Ink and iron method, so I came up with thus idea, to cut adhesive warp with plotter machine and remove the excess then apply it to copper board then pure the solution... And this was the result,
what do you think about it

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

Similar Threads

Similar Threads

Similar Threads