excel file to a lookup table

[Shehbaz Khan]

i have an excel file having a table of two columns….

It is a long file, and i want to import the table from that file to a cloverleaf look up table….

any ideas???

Topic

[Max Drown (Infor)]

You could export the spreadsheet into a .csv file and then use either perl or tcl to convert the file to a Cloverleaf table. Do you need some help with the script?

-- Max Drown (Infor)

[Robert Kersemakers]

If you don’t have a script or are not able to do make it yourself (or as me: you don’t have the time for it…), you could also use a text editor (or Word) to make the entries.

* export spreadsheet into .csv

* read .csv into text editor or Word

* replace all ‘‘ with ‘#‘

* you know have a correct representation of all entries for the table

* create a new table

* open this table with an editor (vi or notepad)

* insert the entries you made after the header of the table

You only need to change the defaults after this.

Zuyderland Medisch Centrum; Heerlen/Sittard; The Netherlands

[Author]

Replies