Text Object

[smilingjohn]

Hi All, 

I have one requirement like . 

If you can please look into my attachment . I have a straight table with only one column WHich in real time I will hide it below any other chart . and i want a text object or action button upon single clik it should give me the values on the excel sheet . (Customer ID) . 

I have to hide my one column excel sheet , thats the reason I want to have a button to eport to excel. 

Thanks in Advance

[felcar2013]

hi

try this

=concat(CustomerID,'\n')

[smilingjohn]

Thank @felcar2013 

This work as i desired . Now how do i export this values to excel sheet ? 

Thanks

[felcar2013]

I think you can do the following:

you can export the text box contente to excel. Click on the text box, then right click, press on "export to excel". In excel you will get the content in only one cell "A1". You can unstack the cell content into many cells (different columns) then you transpose it. Finally you get only one column. Hope it helps  

[smilingjohn]

Hi 

I want to click and it has to print all the values . Is it possible as I have to provide a action button and Need to print one fiel value in an excel . 

Tahnks

[felcar2013]

How exaclty is your requirement? what is the output?

you can create an action button to export the text box content, then in excel use data transformation to get what you need in excel

[smilingjohn]

Hi @felcar2013  

If you can please look into my attachment . I have a straight table with only one column WHich in real time I will hide it below any other chart . and i want a text object or action button upon single clik it should give me the values on the excel sheet . (Customer ID) . 

I have to hide my one column excel sheet , thats the reason I want to have a button to eport to excel. 

Thanks . 

[felcar2013 · Accepted solution]

hi

see file