Note: an Empty attribute Names can cause errors later. (you can remove this duplicate later in Freeplane) To do that: right click on the sheet name you want to delete > Delete Sheet (OK)Ģ- you have to fix the issue of missing text (mentioned in previous post) to avoid later problems:īy copying the text from the cell (512,E) to (515,E). Open your excel file (for sourceforge.xls) in (LibreOffice Calc)ġ- the excel file (for sourceforge) has (3 sheets), so, you have to delete 2 sheets and keep only the one you want to export, which is (To import to Freeplane), until I was able to convert the file to (a Freeplane compitable node tree)įirst, I used (LibreOffice Calc), latest version, to export the Excel sheet to an XML file
etc)Īnd then I started to build a list of regular expressions search & replace terms, to remove unwanted tags & to organize the text structure & to mark (flag) attributes.
#FREEPLANE DESELECT ALL HOW TO#
I had to examine the XML file very well to understand its structure: (how attributes are represented in it, how nodes are represented, how to identify a node index (node level). The main idea is to change the structure of the XML file into a (Freeplane map tree), to copy the resulting text to Freeplane. (EditPad Pro) is used to conduct a series of search & replace operations in the XML file using Macros. The main point of using (LibreOffice Calc) is to export the excel sheet to an XML file, Trial Version, can be downloaded from here: EditPad Pro, a powerful text editor (specially in regex search & replace & macros).Latest version can be downloaded from here: (LibreOffice Calc), open source alternative to (Microsoft Office) here are the steps that I followed to convert the sheet back to Freeplane map.
0 kommentar(er)
