Skip to Content

Register Login

Industry Online Support

Technical Forum

Navigation

Export DB to Excel file

Created by: Andrzej at: 11/11/2005 9:47 AM (21 Replies)

Rating (4)

Thanks 6

Result pages:: |; 1 | 2 | 3; |

22 Entries

Entries per page: 10 | 20 | all

11/11/2005 9:47 AM	Rate (0)
Andrzej Posts: 23 Rating: (1)	Hello, I'm looking for a solution of simply export DB to Excel file. I know that there is a way to import DB from Excel to Step7. Thank You for response. Andrzej
Andrzej Posts: 23 Rating: (1)
Suggestion To thank Quote Answer

11/11/2005 6:42 PM	Rate (0)
Denilson Pegaia Platinum Member Joined: 9/23/2005 Last visit: 1/17/2025 Posts: 4394 Rating: (1463)	I suggest you select the DB data view and use Ctrl C + Ctrl V to transfer the definitions to Excel.
	Denilson Pegaia Siemens Industry Sector Technical Support
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users northop

3/4/2007 6:09 PM	Rate (0)
Late Platinum Expert Joined: 1/7/2006 Last visit: 12/23/2024 Posts: 2705 Rating: (320)	Hi, I have looked on the page but there is only information about the functions, not about the programming. Are there possibilitys to work with the engineering packages, or is it like S7 Lite, only to use for small PLCs and without any networking, drives and all special cards. If it is only for the DBs then I could earn easally the money by doing it with the tool that Siemens have by there own. How do you import an Excel list with STEP 7 variables into a data block?
	I hope that the answer will help, if you have still questions, don't hesitate to ask me. All the best, Late Never say never, think in solutions, not in trouble......
Suggestion To thank Quote Answer

4/27/2007 4:03 PM	Rate (0)
Mi-k-l Posts: 41 Rating: (1)	Hello!! I've read all post in this topic. It's very clear. I've read the FAQ in the post above. It is a good help. I would like to know If it is possible to export my DB's data step by step into an excel file. In fact, I have a function which has as aim to log date, time and informations on 8bytes. This function is called in 4 FB. when it has been called, the function writes a package of information. What I want to do is when I send this package to my DB, I generate automatically one line in my excel file. Does a solution exist? Regards, Mi-k-l
Mi-k-l Posts: 41 Rating: (1)
Suggestion To thank Quote Answer

4/28/2007 3:30 PM	Rate (1)
Late Platinum Expert Joined: 1/7/2006 Last visit: 12/23/2024 Posts: 2705 Rating: (320)	Mi-k-l I would like to know If it is possible to export my DB's data step by step into an excel file. In fact, I have a function which has as aim to log date, time and informations on 8bytes. This function is called in 4 FB. When it has been called, the function writes a package of information. What I want to do is when I send this package to my DB, I generate automatically one line in my excel file. Please look for the next link: STEP 7 InfoBrowser V1.0 - Exporting STEP 7 project data to MS-Excel and accessing information in Online Support This will help you to the right way I think.
	I hope that the answer will help, if you have still questions, don't hesitate to ask me. All the best, Late Never say never, think in solutions, not in trouble......
Suggestion To thank Quote Answer
This contribution was helpful to 1 thankful Users how come

2/20/2008 10:57 AM	Rate (0)
littleboy Posts: 2 Rating: (0)	Oh ! thanks.
littleboy Posts: 2 Rating: (0)
Suggestion To thank Quote Answer

5/2/2011 1:02 PM	Rate (0)
eemi Posts: 30 Rating: (0)	s7xp.com Check S7XP Manager: www.s7xp.com 1. Write online plc data block values back to step 7 project 2. Export datablock to excel or csv 3. Data logger functionality 4. Trending All based on original step 7 project files. -------------------------------------------------------------------- Hi the page www.s7xp.com not found. Please give me the right address
eemi Posts: 30 Rating: (0)	Last edited by: eemi at: 5/2/2011 1:03 PM
Suggestion To thank Quote Answer

5/3/2011 7:02 AM	Rate (0)
umencho Diamond Member Joined: 3/21/2006 Last visit: 1/14/2025 Posts: 10239 Rating: (1182)	Hello, Send me your email.Want to know you that this tool is not so good according to my expirience. Even look at this software is dead and out of date. the site is down. a my friend had bought this two years ago , and some things do not work. Thrown money ! do not ask about this. Best regards, Hristo Mihalev

Suggestion To thank Quote Answer

5/26/2011 9:31 AM	Rate (0)
SteBo Platinum Member Joined: 10/3/2010 Last visit: 1/14/2025 Posts: 1563 Rating: (194)	I'm interested too, I tried the STEP 7 InfoBrowser tool but it fails to load the full project, displaying an error, see attached screenshot. Copy/paste is also not good cause it doesn't include the address column Opened an older project with STEP 7 InfoBrowser and it works, so probably the newer project uses resources that STEP 7 InfoBrowser doesn't know. Attachment STEP 7 InfoBrowser Error.jpg (1274 Downloads)
	Last edited by: SteBo at: 5/26/2011 9:39 AM B r g d s , S t e B o SIMATIC HMI in Online Support Forum
Suggestion To thank Quote Answer

5/26/2011 9:55 AM	Rate (0)
gre_m Posts: 947 Rating: (45)	Hi! I know two solutions: 1. use command interface for step7 for write macros Excel, and 2.if you want to transfer data from DB - generate source code, export it to text file and open it in Excelwith a file with delimiter
gre_m Posts: 947 Rating: (45)
Suggestion To thank Quote Answer

|

Share this page:

Share this page on...

Follow us on