How do save the edited file?

Question

Hi All,

I have imported an excel file into Yed and have defined an hierarchy.  After which, I made changes to the data using Yed(basically some deletions).  How do I write it back to excel?  Is there a way to store it in excel format or xml format?  If yes, please let me know.

Thanks

Sunil Kumar

Answer 1

yEd does not support Excel as an export format.

However, GraphML, yEd's native file format, is an XML based format. So, if you need XML, then GraphML is the way to go.

Comments

Thanks for your quick response!

However, I lose the original excel data after storing in .graphml format.  It would be great, if the excel data is stored in xml format. :-)

Do we have such an option?  If yes, can you please let me know.

Thanks
Sunil Kumar

---

No, there is no way to save Excel data that was not imported in the first place. (yEd simply discards all data that is not used when importing.)

---

If thats the case, then why do I see the data as part of the properties view for each object?

Thanks.

---

There seems to have been a misunderstanding here.
When importing data from Excel, you can define how to import that data. You may/must specify which data defines the graph structure, which data is imported into custom properties, and which data is simply ignored.
In any case, after yEd has finished the import, any ignored data or data yEd could not handle is discarded and cannot be reproduced in any way when saving to GraphML format. But, of course, all data that *was* imported (including custom properties) will be stored in GraphML. In other words, any information that is available in yEd *after* the import is also available in GraphML.

---

Thats good news.  However, I am not seeing the imported data in .graphml file.  Am I missing anything here?

Thanks in advance!
Sunil Kumar

---

Pasting an extract below.   
<data key="d9">
        <y:PolyLineEdge>
          <y:Path sx="0.0" sy="15.0" tx="0.0" ty="-15.0"/>
          <y:LineStyle color="#000000" type="line" width="1.0"/>
          <y:Arrows source="none" target="standard"/>
          <y:EdgeLabel alignment="center" distance="2.0" fontFamily="Dialog" fontSize="12" fontStyle="plain" hasBackgroundColor="false" hasLineColor="false" height="18.701171875" modelName="six_pos" modelPosition="tail" preferredPlacement="anywhere" ratio="0.5" textColor="#000000" visible="true" width="10.673828125" x="2.000016469804109" y="5.6494140625">3</y:EdgeLabel>
          <y:BendStyle smoothed="false"/>
        </y:PolyLineEdge>
      </data>

---

You are looking at the wrong place. Try to search for a distinct text value of a custom property to see how custom properties are stored in GraphML.

---

Thank Thomas.  By the way, any idea, if there would be feature be implemented wherein it allows to to save in excel format in future?  If yes, then when it likely to be in the product?

Thanks
Sunil Kumar

---

And more importantly, is there any way, I can get the data from the GraphML into excel?  Straight forward, import into excel doesn't help me much.  

Can you please let me know the minimum steps to be done(tweaking in GraphML) in order to view the data in excel.

Thanks in advance!
Sunil Kumar

---

> ... if there would be feature be implemented wherein it allows to to save
> in excel format in future?

No, we do not plan to add Excel export to yEd.


> Can you please let me know the minimum steps to be done (tweaking
> in GraphML) in order to view the data in excel.

Unfortunately, I do not know of any way to view GraphML in Excel. As far as I know, you cannot import graph structures into Excel in a sensible way.

To be honest, I do not understand what you are trying to do here. You cannot use yEd to impose a structure on your data for use in Excel.

---

Primarily, I have data in excel or xml format.  Currently, I am using Yed as a viewer, and I am looking for an option of updating the data(primarly deletion of nodes) and then save it back in excel or xml format.

Please let me know, on this.  I hope, I am clear.

Thanks
Sunil Kumar

---

I do not  think yEd is the right tool for editing your data. Use yEd as a viewer only and stick to Excel for deleting data.

---

Thanks Thomas for the clarification.  Would certainly miss this feature very much. :-(

By the way, is there is any other alternate free tool, that is both a viewer and editor as well?

Thanks again
Sunil Kumar

---

yEd *is* an editor - you can edit (or rather modify) GraphML files just fine. It is just not an editor for Excel/generic XML files.

Unfortunately,  I do not know if there is an application that does what you want.

---

Thank you very much for your quick response!