It depends on whether you are old enough to know that not getting everything you want in life is not actually going to kill you. 

If so, read on.

It will not kill you to use a text editor (notepad, notepad++ for example) to edit SCL / STL exported from your PLC logic.

To export other blocks, you need TIA Openness which can export as XML, which still is not "to excel" in most people's minds, but hey, it will not kill you, so it is ok.

kiran p

Hi,

I want to export FC or FB from TIA V14 to excel and also want import from excel to TIA v14 after doing modification. Please anyone help me for doing this?

As was just posted above, you can open the DB in TIA Portal, select all rows/columns, and then you can paste directly into excel.

There is also the TIA Openness application included with the portal license and on the DVD containing portal software.  It can export to XML, which you can open in excel.  If you have a favorite xml -> xls converter, you can try that and see if it gives you the results you need.

Beyond that, you may need to custom write some code or cobble some tools together to help automate this.

Auto-IT, WinBatch, and a lot of other macro / automation tools exist.  Ask your I.T. people what solution they might have that accepts xml, and converts nicely to excel/xls.   

kiran p

 

jacek d

The question arises: why not to the Paint?

Maybe better tell us what you want to achieve?

 Hi ,

Please tell, at least is it possible to export and import DB to excel from TIA V14. Because I want to create alarm DB. Because I am importing this excel sheet to some other SCADA. So i create alarms in excel and I will import this excel sheet to SCADA. And in this same way I want to import excel sheet data to alarm DB in TIA V14.

So please tell me is it possible to import and export excel sheet to TIA 14.