Import tabular data into CDendro

The menu command Collections/Import and convert tabular data to a .fh-collection file allows you to import data from various "spread-sheet programs" like the Open Office Calc program.

Please note, there is also a command "Write collection in tabular format" which does the inverse of the "Import and convert tab..." command.

In your spread-sheet program, select that region you want to import into CDendro and see that you transfer a copy of that data to the Clipboard (use the Edit/Copy command or just Ctrl-C).

Note, that we have year-numbers in the leftmost column above.

In CDendro, click the 1-button above to transfer the content of the Clipboard into the textbox!
See that you uncheck "Find sample identities in top row" in this case.

Then click the "Analyze data from textbox now!-button (5).

The analyzation says that we have 20 rows with index 0 to 19 and 8 columns with index 0 to 7.
Let us check that data has been imported as we suppose!
Enter 19 into the RowIndex textbox and 7 into the ColumnIndex textbox (a).
When you click the button "Get cell data" (b) the corresponding cell data is shown at (c).
0.95 is actually the value in the lower right corner of our original selection.

Note: You may now click the button "Copy column as .fh-data to clipboard". If you then enter a text editor and paste the Clipboard content into it (use Ctrl-V) you will see this data:

 
HEADER: 
KeyCode=H 
DateEnd=1932 
Length=20 
DATA:Tree 
    49    49    51    59    41    68    85    69    53    75 
    82    86    84    49    71    55    78    93    87    95 
I.e. the content of the rightmost column written in .fh format.
Click the "Try convert data read..." button (7) and save as a .fh file!
Open the .fh-file in a text editor to check the content!

Note: A .fh file can easily be written out from CDendro as a .rwl file if you want that format!



Copyright 2007, Cybis Elektronik & Data AB, www.cybis.se