[Therion] convert excel to therion

Tarquin Wilton-Jones tarquin.wilton-jones at ntlworld.com
Wed Dec 21 08:45:47 CET 2022


Step 1 would be to get the data out of Excel and into a text-based
format. Axel suggests copy & paste, which works very well.
Alternatively, in Excel, use "Save as" to save it as a CSV file. Then
open the CSV file in a text editor that has a find-&-replace function,
and replace all commas with spaces. Save the file as something.th

It's entirely up to you which approach you would prefer.

Step 2 is to add in the basic Therion wrapper that Axel suggested.

Cheers,
Tarquin

> u have to wrap it around some basic Therion code (survey/ centerline).
> As ure question suggest u have not worked before with Therion u might
> want to have a look at one of the dokumentations listet here:
> https://therion.speleo.sk/wiki/doku.php
> u want something like:
>   survey 1
>     centerline
>       date jjjj.mm.dd
>       data normal from to length compass clino left right up down
>       1.1  1.2  7.74  331  3.7  1.9  6.4  2  0
>       (copy&paste)
>       ...
>     endcenterline
>   endsurvey
> in a text file saved as *.th
> as stated before, pls have a look at the dokumentation. There are plenty
> listed: e.g. a step by step one for cavers:
> https://therion.speleo.sk/wiki/tfc
>  
> Axel


More information about the Therion mailing list