topic Re: Qlikview - export text box in excel in QlikView

Qlikview - export text box in excel

Wed, 25 Nov 2020 16:16:04 GMT

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?

Re: Qlikview - export text box in excel

rupamjyotidas — Thu, 29 Sep 2016 18:20:20 GMT

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

Re: Qlikview - export text box in excel

santiago_respane — Thu, 29 Sep 2016 18:23:06 GMT

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,

Re: Qlikview - export text box in excel

Fri, 30 Sep 2016 06:19:28 GMT

I want to do that using modul...

Re: Qlikview - export text box in excel

Anonymous — Fri, 30 Sep 2016 07:04:52 GMT

Hi papepape,

Regards!

Re: Qlikview - export text box in excel

avinashelite — Fri, 30 Sep 2016 07:09:16 GMT

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

Re: Qlikview - export text box in excel

Fri, 30 Sep 2016 07:13:31 GMT

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...

Re: Qlikview - export text box in excel

rajpreeths — Fri, 30 Sep 2016 07:18:01 GMT

Hello..

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

Re: Qlikview - export text box in excel

santiago_respane — Fri, 30 Sep 2016 16:55:11 GMT

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,

Re: Qlikview - export text box in excel

Sat, 01 Oct 2016 05:14:35 GMT

Thanks a lot!!!!!!

Re: Qlikview - export text box in excel

Anonymous — Wed, 19 Oct 2016 18:06:16 GMT

How can I send multiple textbox to excel without losing the format?, is that possible?