Cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted

table exported to excel

Legend
Legend

Hello All,

 

i have 2 question regarding to exporting data to excelfile:

 

1). Is it possible to set format of excel (like text instead of standard) during exporting data from plantsimulation??

problem is : when i export table to excelfile then it changes the content of the original table(like: in excel it wrote 3 but original value is 03).. if i select format of excel is text(for all column) then it will show the original value(03).

it is difficult to change luanguage of excel for all pc. So, i cannot do it..

 

 

2). How is it possible to export and import subtable with main table?

Description : i am exporting many tables to 1 excel file (ofcourse with many sheets according to table name). But in all table, there is subtable.. So, How can i export main table with subtable ?..then i want to also import the same data to the same table(in which i exported)??

Can anyone suggest me better idea??..

 

thanks in advance

 

3 REPLIES 3

Re: table exported to excel

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

1. you could export the file in Plant Simulation as text file

--> for the import into excel you can use the text converting tool of excel, there you can select all you need

 

2. you may export/import it as xml file

 

I guess this is the only way

Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net

Re: table exported to excel

Legend
Legend

Hi @Steffen_B 

 

thanks for help

 

XML is good idea..Is it possible to export many tables(with subtable) to 1 xml file and then import these xml file to all tables(and subtables)--as it is..#first export then import to same table(in other model) by one xml file..Is it possible?

 

thanks in advance

 

Re: table exported to excel

Gears Esteemed Contributor Gears Esteemed Contributor
Gears Esteemed Contributor

the xml file need a "top" structure; this is the tableFile in Plant Simulation

If you copy all tables (with the sub-tables)  into one tableFile, then you can export it to one XML-File.

 

But you cannot copy several tableFile objects into one XML-File.

 

the xml-file you created you can import into a tableFile in another Plant Simulation model

Steffen Bangsow
freelance simulation specialist  
web: www.bangsow.eu
mail: steffen@bangsow.net