Load excel column into text object

[Anonymous]

Hi, in my script I have a loaded a spreadsheet with 5 columns.  I want to be able to create a text object that only pulls one of those columns.  I've tried an if statement, only statement and nothing is working.  Help?

[giakoum]

=concat(yourColumn, ',')

[maxgro · Accepted solution]

maybe

=concat(oneofthecolumn & chr(10))

[Anonymous]

Thank you.  And if I wanted to show the values of 2 columns???

Column 1     Column 2

Value 1          Value 2

[Peter_Cammaert]

Create two text objects and align them in such a way that they appear as one.

Peter

[awhitfield]

Using something other tan a text object would be best

Andy

[Peter_Cammaert]

Andrew is right.

For example, you can give a Table Box the appearance of a text object by giving all cell borders the same color as the background. Nobody will notice that your are playing tricks

Peter

[Anonymous]

Thank you all.