parsing tree from excel sheet

alb al.basili at gmail.com
Wed Jan 28 11:12:02 CET 2015


Hi everyone,

I've a document structure which is extremely simple and represented on a 
spreadsheet in the following way (a made up example):

subsystem | chapter | section | subsection | subsubsec |
    A     |         |         |            |           |
          | func0   |         |            |           |
          |         |interface|            |           |
          |         |latency  |            |           |
          |         |priority |            |           |
          | func1   |         |            |           |
          |         |interface|            |           |
          |         |latency  |            |           |
          |         |priority |            |           |
          |         |depend   |            |           |
          |         |         | variables  |           |
          |         |         |            | static    |
          |         |         |            | global    |
          |         |         | functions  |           |
          |         |         |            | internal  |
          |         |         |            | external  |

And I'd like to get a tree like this:

    A
    +-------> func0
    |           +---> interface
    |           +---> latency
    |           \---> priority
    \-------> func1
                +---> interface
                +---> latency
                +---> priority
                \---> depend
                         +---> variables
                         |         +---> static
                         |         \---> local
                         \---> functions
                                   +---> internal
                                   \---> external

I know about the xlrd module to get data from excel and I'm also aware 
about the ETE toolkit (which is more specific for bioinformatics, but I 
guess can suitable fill the need).

Does anyone recommend any other path other than scripting through these 
two modules?

Is there any more suitable module/example/project out there that would 
achieve the same result?

The reason for parsing is because the need behind is to create documents 
edited in excel but typeset in LaTeX, therefore my script will spill out 
\chapter, \section and so forth based on the tree structure.

Every node will have some text and some images with a very light markup 
like mediawiki that I can easily convert into latex.

Hope I've not been too confusing.
Thanks for any pointer/suggestion/comment.

Al

p.s.: I'm not extremely proficient in python, actually I'm just starting 
with it!

-- 
A: Because it messes up the order in which people normally read text.
Q: Why is top-posting such a bad thing?
A: Top-posting.
Q: What is the most annoying thing on usenet and in e-mail?



More information about the Python-list mailing list