Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
hi
try this
=concat(CustomerID,'\n')
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
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
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
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 .
hi
see file