to aquire the data sent from 8051 and save it on an excel sheet

[sathishnrao]

hi iam sathish,
iam doing a project on 8051 1 want to aquire the data serially and save the data on an excel sheet
pls help in getting an solution
thank u

 

[Seetha09]

Hi Sathish
Download a software called 'COM port tool kit' which is a serial window and it gives u an option to save the serially sent/receive data from microcontroller in PC in.txt format

 

[Seetha09]

Hi
M sorry i dint give u the complete information regarding the interface between PC and microcontroller. Please follow the below link for further details.
**broken link removed**
Interface circuit between controller and PC is common. so try to make this on a small general purpose board(MAX 232 and DB9 connector)
Regards
AK

 

[JayantD]

You may also use Hyperterminal to save your serial data as a text file. Use the "Capture Text" option in "Transfer" menu. This file can then be imported into excel either manually or by using a macro. The file can be saved as an excel file.

 

[Zwilorg]

Or you can use a Visual basic interface using a 232 serial comm and program it to keep saving files on excel

something like

---

Code Visual Basic - [expand]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Imports Excel = Microsoft.Office.Interop.Excel
 
(...)
 
    Private Sub Button3_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button3.Click
 
        APP = New Excel.Application
 
        workbook = APP.Workbooks.Open("C:\Users\...\...\...\Excel\excel_1.xlsm")
 
        worksheet = workbook.Worksheets("sheet1")
 
end sub
 
   Private Sub Button5_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button5.Click
        APP.Run("Save_ChartAsImage")
        workbook.Save()
        workbook.Close()
        APP.Quit()
    End Sub

---

i also use alot of macros in excel/word files for everything like printing in pdf, save as pictures(graphs etc...) and you can also activate these within the visual basic program. it is all automatic

with hyper terminal you need to receive *.txt file, open excel, import data, do whatever you want, export graphs print or whatever and save.... :S it is just too many clicking and button pushing hehe.


Beware that there are ways to auto detect in wich "sheet" on excel you are working and to activate that one. in the code i sent you it is already hardcoded to sheet1 only


Best regards,
Zwi

 

[dv_sa559]

Hi
I think this address be useful : **broken link removed**