• Locked Locked
  • Replies 2 replies
  • Subscribers 79 subscribers
  • Views 915 views
  • Users 0 members are here
Support feedback
Options
Options
Related

This thread has been locked.

If you have a related question, please click the "Ask a related question" button in the top right corner. The newly created question will be automatically linked to this question.

How to read an excel file

sam22
Prodigy 170 points


hi,

  I want to develop an application in which i have to read data from excel file & transmit it via serial port. I have the code for serial data transmit ready. Can anyone tell me how to read the excel using MATLAB or IAR.

 

Thanks

 

Regards

Sid

  • TI__Guru 70192 points

    Sid,

    there is a pretty easy method that you might be able to utilize. Simply export your Excel file as a *.CSV file (Comma Separated Values) by selecting the appropriate file type in Excel's "Save As..." dialog box. You can then parse the created file using scanf() function calls or so. Regarding your overall system, it might makes sense (more efficient) to do the *.CSV-file parsing on the PC side, and simply send the extracted binary data over to the MSP430 using your serial link.

    Regards,
    Andreas

  • in reply to Andreas Dannenberg
    Prodigy 170 points

    CSV has 3 options which 1 do i select comma delimites Ms-dos 3rd is MAC. Can you tell me how to parse the file. I am a newbie & dont hv much clue abt it.

     

    Thanks.

    Regards

    Sid

**Attention** This is a public forum