Macro for: Export straight table into Excel file and create a drop down menu in one field

DataAnalytics — Sat, 16 Nov 2024 18:20:06 GMT

Hello guys,

I am trying to solve this issue - I have a straight table and I need to export it into Excel file and create a drop down menu in one field/column.

This is the table. It contains 'name' and 'type'. 'Type' field can be either empty, or it can already have some value in it.

name	type
John
Lucy
Stephen	B
Mary
Joe	A

The table above should be exported and the output Excel file should have a drop down menu in field 'type' as below:

type (drop down menu):

Please let me know your thoughts! Thank you in advance!!!

Re: Macro for: Export straight table into Excel file and create a drop down menu in one field

Brett_Bleess — Tue, 04 Aug 2020 20:29:01 GMT

You likely need to hit Microsoft forums, as you are going to need Excel APIs to do this, we have no API that is going to modify the Excel properties...

Here is a link to our QlikView APIs:

https://help.qlik.com/en-US/qlikview-developer/April2020/Subsystems/Automation/Content/QV_Automation/APIGuide/QlikViewComApiGuide.zip

Regards,
Brett

topic Re: Macro for: Export straight table into Excel file and create a drop down menu in one field in QlikView

Macro for: Export straight table into Excel file and create a drop down menu in one field

Re: Macro for: Export straight table into Excel file and create a drop down menu in one field