Qlikview - export text box in excel

[#1]

Hi,

I need to export text box in excel. When I do that i get only the objectID instead of text.

I have

objectID = TX01

and

  text MyTextBox

I got TX01, and i need MyTextBox How to do that.

Any idea?

[rupamjyotidas]

Can you share the app. Seems to be working for me

[santiago_respane]

How are you exporting your text object?

If i right click on a text object, click send to excel it exports its value correctly not the ID.

Kind regards,

[#4]

I want to do that using modul...

[Anonymous]

Hi papepape,

Regards!

[avinashelite]

Did you tried the Right click and export to excel ?? it should work ...are you trying to export it in any other format ??

[#7]

I now for right click, but I have task to do that using modul. When press button i need to export text from text box in excel because i need modul...

[rajpreeths]

Hello..

Send to Excel option should work fine.Are you trying to export the data with macro ???

[santiago_respane · Accepted solution]

How about something like this:

sub ExportChart    

      set cs = ActiveDocument.GetSheetObject("TX01")

    msgbox cs.GetText()

      set XLApp = CreateObject("Excel.Application")

      XLApp.Visible = True

      set XLDoc = XLApp.Workbooks.Add

      XLDoc.Sheets(1).name = "Exported text object"

      set XLSheet = XLDoc.Worksheets(1)

      XLSheet.Range("A1") = cs.GetText()        

End Sub

This will open a new excel file and store the value of the text object with ID TX01 in the cell A1.

Please let me know if this helps or ir you need something else.

Kind regards,

[#10]

Thanks a lot!!!!!!