Welcome to EDAboard.com

Welcome to our site! EDAboard.com is an international Electronic Discussion Forum focused on EDA software, circuits, schematics, books, theory, papers, asic, pld, 8051, DSP, Network, RF, Analog Design, PCB, Service Manuals... and a whole lot more! To participate you need to register. Registration is free. Click here to register now.

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

Status
Not open for further replies.

sathishnrao

Newbie level 3
Joined
Jul 15, 2010
Messages
3
Helped
1
Reputation
2
Reaction score
1
Trophy points
1,283
Location
bengaluru
Activity points
1,300
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

Newbie level 6
Joined
Jun 7, 2011
Messages
14
Helped
1
Reputation
2
Reaction score
1
Trophy points
1,283
Activity points
1,361
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

Newbie level 6
Joined
Jun 7, 2011
Messages
14
Helped
1
Reputation
2
Reaction score
1
Trophy points
1,283
Activity points
1,361
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.
AVR: How to use serial port in ATMEGA8 | Creative Electron
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

Member level 3
Joined
Nov 2, 2010
Messages
58
Helped
9
Reputation
18
Reaction score
9
Trophy points
1,288
Location
Pune, India
Activity points
1,549
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

Member level 5
Joined
Oct 13, 2010
Messages
89
Helped
3
Reputation
6
Reaction score
3
Trophy points
1,288
Activity points
1,906
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
 

Status
Not open for further replies.

Part and Inventory Search

Welcome to EDABoard.com

Sponsor

Top