ExportSettingsExcelCsvFile class - Revision history

Administrator at 07:04, 2 July 2020

2020-07-02T07:04:30Z

Administrator at 10:26, 4 February 2020

2020-02-04T10:26:58Z

← Older revision		Revision as of 10:26, 4 February 2020
Line 5:		Line 5:
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
			\|Description=<nowiki>Add all questions to the export. Default ignore GDPR classified questions.</nowiki>}}
			{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
			{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>includeQuestionWithGDPRDate</nowiki>\|Description=<nowiki>Include questions marked as containing GDPR classified data</nowiki>}}
	\|Description=<nowiki>Add all questions to the export</nowiki>}}		\|Description=<nowiki>Add all questions to the export</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
	\|Description=<nowiki>Add all questions to the export</nowiki>}}		\|Description=<nowiki>Add all questions to the export. Default ignore GDPR classified questions.</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddQuestion</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddQuestion</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}

Administrator at 03:19, 17 October 2019

2019-10-17T03:19:04Z

← Older revision		Revision as of 03:19, 17 October 2019
Line 28:		Line 28:
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}
	\|Description=<nowiki>Return PresentAsText of question in export</nowiki>}}		\|Description=<nowiki>Return PresentAsText of question in export</nowiki>}}
			{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>SetExportOptionsAsMultipleColumnsForAllQuestions</nowiki>\|Parameters=
			{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionValue</nowiki>\|Description=<nowiki>Option value (true/false)</nowiki>}}
			\|Description=<nowiki>Set value of the OptionsAsMultipleColumns option for all questions whose type is Multi or MultiGrid</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}
	\|Properties=		\|Properties=
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>CsvFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>CsvFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
			{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExcelFileOptionsAddQuestionText</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if add question text to the file is enable</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExcelFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExcelFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportAddressInformation</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportAddressInformation</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}

Nguyenduyan at 08:59, 19 October 2017

2017-10-19T08:59:37Z

@@ Line 44: / Line 44: @@
 === <span style="color:#DF8621">'''Examples'''</span> ===
 <source lang="javascript">
 string ResourceName="test ExportManager type excel";
 number parentResourceId = 11088827;
 ExportManager EM = new ExportManager (ResourceName, parentResourceId );
 EM.AddQuestionnaire(15546533);
 ExportSettingsExcelCsvFile exportSetting = EM.ExportSettingsExcelCsvFile;
 number questionnaireResourceId = 15546533;
@@ Line 57: / Line 56: @@
 exportSetting.AddAllQuestions(questionnaireResourceId, presentAsText, exportToCsv, exportToExcel );
 exportSetting.ExcelFileOptionsUseCommaSeparatedFormat = true;
 EM.Language ="en-GB";
 exportSetting.ExportAddressInformation= true;
 exportSetting.ExportPhoneNumbers = true;
@@ Line 65: / Line 62: @@
 exportSetting.ExportUserEmail = true;
 //exportSetting.IsExcelFileExport = true;
 DateTime startTime = new DateTime ("2017-4-18");
 DateTime endTime = new DateTime ("2017-4-19");
@@ Line 71: / Line 67: @@
 EM.CGStartTimeFrameUTC = startTime;
 EM.CGEndTimeFrameUTC = endTime;
 EM.QasNotStarted = true;
 EM.QasPartly = true;
 EM.QasCompleted = true;
 EM.QasNormal = true;
 EM.QasQuotaFull = true;
@@ Line 81: / Line 75: @@
 EM.QasInterviewFailed = true;
 EM.QasInterviewSucceded = true;
 EM.IncludedTestData= false;
 EM.IncludedDeletedUsers = true;
@@ Line 87: / Line 80: @@
 EM.Save();
 EM.Export();
 </source>

Nguyenduyan at 07:24, 13 October 2017

2017-10-13T07:24:50Z

← Older revision		Revision as of 07:24, 13 October 2017
Line 1:		Line 1:
	{{CGscriptClass_Template		{{CGscriptClass_Template
	\|Name=ExportSettingsExcelCsvFile		\|Name=<nowiki>ExportSettingsExcelCsvFile</nowiki>
	\|Description=Export settings for the Excel and Csv File format.		\|Description=<nowiki>Export settings for the Excel and Csv File format.</nowiki>
	\|Methods=		\|Methods=
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=AddAllQuestions\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=questionnaireResourceId\|Description=The questionnaire the question is located in\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=presentAsText\|Description=Export the option as the value or as the text\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=exportToCsv\|Description=Export to the given format\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=exportToExcel\|Description=Export to the given format}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
	\|Description=Add all questions to the export}}		\|Description=<nowiki>Add all questions to the export</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=AddQuestion\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=questionnaireResourceId\|Description=The questionnaire the question is located in\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=questionLabel\|Description=Label of the question\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=presentAsText\|Description=Export the option as the value or as the text\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=exportToCsv\|Description=Export to the given format\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=exportToExcel\|Description=Export to the given format}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
	\|Description=Add question to the export}}		\|Description=<nowiki>Add all questions to the export</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=Clear\|Description=Remove format from output}}		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddQuestion</nowiki>\|Parameters=
	{{CGscriptMethods_Template\|ReturnType=int\|Name=GridIndex\|Parameters=		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
	{{CGscriptParameters_Template\|Type=int\|Name=questionnaireResourceId\|Description=The questionnaire the question is located in\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=questionLabel\|Description=Label of the question}}		\|Description=<nowiki>Add question to the export</nowiki>}}
	\|Description=Return GridIndex of question in export}}		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddQuestion</nowiki>\|Parameters=
	{{CGscriptMethods_Template\|ReturnType=bool\|Name=IsQuestionExported\|Parameters=		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
	{{CGscriptParameters_Template\|Type=int\|Name=questionnaireResourceId\|Description=The questionnaire the question is located in\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=questionLabel\|Description=Label of the question}}		\|Description=<nowiki>Add question to the export</nowiki>}}
	\|Description=Return true if question is exported}}		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>Clear</nowiki>\|Description=<nowiki>Remove format from output</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=bool\|Name=PresentAsText\|Parameters=		{{CGscriptMethods_Template\|ReturnType=int\|Name=<nowiki>GridIndex</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=questionnaireResourceId\|Description=The questionnaire the question is located in\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=questionLabel\|Description=Label of the question}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}
	\|Description=Return PresentAsText of question in export}}		\|Description=<nowiki>Return GridIndex of question in export</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=ToString\|Description=The string representation of the object.}}		{{CGscriptMethods_Template\|ReturnType=bool\|Name=<nowiki>IsQuestionExported</nowiki>\|Parameters=
			{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}
			\|Description=<nowiki>Return true if question is exported</nowiki>}}
			{{CGscriptMethods_Template\|ReturnType=bool\|Name=<nowiki>OptionsAsMultipleColumns</nowiki>\|Parameters=
			{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}
			\|Description=<nowiki>Return OptionsAsMultipleColumns of question in export</nowiki>}}
			{{CGscriptMethods_Template\|ReturnType=bool\|Name=<nowiki>PresentAsText</nowiki>\|Parameters=
			{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}
			\|Description=<nowiki>Return PresentAsText of question in export</nowiki>}}
			{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}
	\|Properties=		\|Properties=
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=CsvFileOptionsUseCommaSeparatedFormat\|HasGetter=1\|HasSetter=1\|Description=Get/set if exporting to specific format with given option}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>CsvFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=ExcelFileOptionsUseCommaSeparatedFormat\|HasGetter=1\|HasSetter=1\|Description=Get/set if exporting to specific format with given option}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExcelFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=ExportAddressInformation\|HasGetter=1\|HasSetter=1\|Description=Get/set if exporting to specific format with given option}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportAddressInformation</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=ExportPhoneNumbers\|HasGetter=1\|HasSetter=1\|Description=Get/set if exporting to specific format with given option}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportPhoneNumbers</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=ExportUserAccountInformation\|HasGetter=1\|HasSetter=1\|Description=Get/set if exporting to specific format with given option}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportUserAccountInformation</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=ExportUserEmail\|HasGetter=1\|HasSetter=1\|Description=Get/set if exporting to specific format with given option}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportUserEmail</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=IsCsvFileExport\|HasGetter=1\|Description=Get if exporting to specific format}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>IsCsvFileExport</nowiki>\|HasGetter=1\|Description=<nowiki>Get if exporting to specific format</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=IsExcelFileExport\|HasGetter=1\|Description=Get if exporting to specific format}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>IsExcelFileExport</nowiki>\|HasGetter=1\|Description=<nowiki>Get if exporting to specific format</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=string\|Name=ObjectTypeName\|HasGetter=1\|Description=The name of the type of object.}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=TypeInformation\|HasGetter=1\|Description=Get information about this class.}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}
	}}		}}

	=== <span style="color:#DF8621">'''Examples'''</span> ===		=== <span style="color:#DF8621">'''Examples'''</span> ===
	<source lang="javascript">		<source lang="javascript">

Nguyenduyan at 09:20, 19 April 2017

2017-04-19T09:20:24Z

← Older revision		Revision as of 09:20, 19 April 2017
Line 32:		Line 32:
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=TypeInformation\|HasGetter=1\|Description=Get information about this class.}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=TypeInformation\|HasGetter=1\|Description=Get information about this class.}}
	}}		}}
			=== <span style="color:#DF8621">'''Examples'''</span> ===
			<source lang="javascript">
			string ResourceName="test ExportManager type excel";
			number parentResourceId = 11088827;
			ExportManager EM = new ExportManager (ResourceName, parentResourceId );

			EM.AddQuestionnaire(15546533);

			ExportSettingsExcelCsvFile exportSetting = EM.ExportSettingsExcelCsvFile;
			number questionnaireResourceId = 15546533;
			bool presentAsText = false;
			bool exportToCsv = false;
			bool exportToExcel = true;
			exportSetting.AddAllQuestions(questionnaireResourceId, presentAsText, exportToCsv, exportToExcel );
			exportSetting.ExcelFileOptionsUseCommaSeparatedFormat = true;

			EM.Language ="en-GB";

			exportSetting.ExportAddressInformation= true;
			exportSetting.ExportPhoneNumbers = true;
			exportSetting.ExportUserAccountInformation = true;
			exportSetting.ExportUserEmail = true;
			//exportSetting.IsExcelFileExport = true;

			DateTime startTime = new DateTime ("2017-4-18");
			DateTime endTime = new DateTime ("2017-4-19");
			EM.SelectTimeFrame =true;
			EM.CGStartTimeFrameUTC = startTime;
			EM.CGEndTimeFrameUTC = endTime;

			EM.QasNotStarted = true;
			EM.QasPartly = true;
			EM.QasCompleted = true;

			EM.QasNormal = true;
			EM.QasQuotaFull = true;
			EM.QasOutsideTarget = true;
			EM.QasInterviewFailed = true;
			EM.QasInterviewSucceded = true;

			EM.IncludedTestData= false;
			EM.IncludedDeletedUsers = true;
			EM.IncludedDisabledUsers = false;
			EM.Save();
			EM.Export();
			</source>

Nguyenduyan: Created page with "{{CGscriptClass_Template |Name=ExportSettingsExcelCsvFile |Description=Export settings for the Excel and Csv File format. |Methods= {{CGscriptMethods_Template|ReturnType=Empty..."

2017-03-28T09:31:36Z

Created page with "{{CGscriptClass_Template |Name=ExportSettingsExcelCsvFile |Description=Export settings for the Excel and Csv File format. |Methods= {{CGscriptMethods_Template|ReturnType=Empty..."

New page

{{CGscriptClass_Template
|Name=ExportSettingsExcelCsvFile
|Description=Export settings for the Excel and Csv File format.
|Methods=
{{CGscriptMethods_Template|ReturnType=Empty|Name=AddAllQuestions|Parameters=
{{CGscriptParameters_Template|Type=int|Name=questionnaireResourceId|Description=The questionnaire the question is located in|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=presentAsText|Description=Export the option as the value or as the text|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=exportToCsv|Description=Export to the given format|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=exportToExcel|Description=Export to the given format}}
|Description=Add all questions to the export}}
{{CGscriptMethods_Template|ReturnType=Empty|Name=AddQuestion|Parameters=
{{CGscriptParameters_Template|Type=int|Name=questionnaireResourceId|Description=The questionnaire the question is located in|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=questionLabel|Description=Label of the question|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=presentAsText|Description=Export the option as the value or as the text|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=exportToCsv|Description=Export to the given format|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=exportToExcel|Description=Export to the given format}}
|Description=Add question to the export}}
{{CGscriptMethods_Template|ReturnType=Empty|Name=Clear|Description=Remove format from output}}
{{CGscriptMethods_Template|ReturnType=int|Name=GridIndex|Parameters=
{{CGscriptParameters_Template|Type=int|Name=questionnaireResourceId|Description=The questionnaire the question is located in|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=questionLabel|Description=Label of the question}}
|Description=Return GridIndex of question in export}}
{{CGscriptMethods_Template|ReturnType=bool|Name=IsQuestionExported|Parameters=
{{CGscriptParameters_Template|Type=int|Name=questionnaireResourceId|Description=The questionnaire the question is located in|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=questionLabel|Description=Label of the question}}
|Description=Return true if question is exported}}
{{CGscriptMethods_Template|ReturnType=bool|Name=PresentAsText|Parameters=
{{CGscriptParameters_Template|Type=int|Name=questionnaireResourceId|Description=The questionnaire the question is located in|Comma=,}}{{CGscriptParameters_Template|Type=string|Name=questionLabel|Description=Label of the question}}
|Description=Return PresentAsText of question in export}}
{{CGscriptMethods_Template|ReturnType=string|Name=ToString|Description=The string representation of the object.}}
|Properties=
{{CGscriptProperties_Template|ReturnType=bool|Name=CsvFileOptionsUseCommaSeparatedFormat|HasGetter=1|HasSetter=1|Description=Get/set if exporting to specific format with given option}}
{{CGscriptProperties_Template|ReturnType=bool|Name=ExcelFileOptionsUseCommaSeparatedFormat|HasGetter=1|HasSetter=1|Description=Get/set if exporting to specific format with given option}}
{{CGscriptProperties_Template|ReturnType=bool|Name=ExportAddressInformation|HasGetter=1|HasSetter=1|Description=Get/set if exporting to specific format with given option}}
{{CGscriptProperties_Template|ReturnType=bool|Name=ExportPhoneNumbers|HasGetter=1|HasSetter=1|Description=Get/set if exporting to specific format with given option}}
{{CGscriptProperties_Template|ReturnType=bool|Name=ExportUserAccountInformation|HasGetter=1|HasSetter=1|Description=Get/set if exporting to specific format with given option}}
{{CGscriptProperties_Template|ReturnType=bool|Name=ExportUserEmail|HasGetter=1|HasSetter=1|Description=Get/set if exporting to specific format with given option}}
{{CGscriptProperties_Template|ReturnType=bool|Name=IsCsvFileExport|HasGetter=1|Description=Get if exporting to specific format}}
{{CGscriptProperties_Template|ReturnType=bool|Name=IsExcelFileExport|HasGetter=1|Description=Get if exporting to specific format}}
{{CGscriptProperties_Template|ReturnType=string|Name=ObjectTypeName|HasGetter=1|Description=The name of the type of object.}}
{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=TypeInformation|HasGetter=1|Description=Get information about this class.}}
}}

← Older revision		Revision as of 10:26, 4 February 2020
Line 5:		Line 5:
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
			\|Description=<nowiki>Add all questions to the export. Default ignore GDPR classified questions.</nowiki>}}
			{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
			{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>includeQuestionWithGDPRDate</nowiki>\|Description=<nowiki>Include questions marked as containing GDPR classified data</nowiki>}}
	\|Description=<nowiki>Add all questions to the export</nowiki>}}		\|Description=<nowiki>Add all questions to the export</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
	\|Description=<nowiki>Add all questions to the export</nowiki>}}		\|Description=<nowiki>Add all questions to the export. Default ignore GDPR classified questions.</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddQuestion</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddQuestion</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}

← Older revision		Revision as of 03:19, 17 October 2019
Line 28:		Line 28:
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>questionLabel</nowiki>\|Description=<nowiki>Label of the question</nowiki>}}
	\|Description=<nowiki>Return PresentAsText of question in export</nowiki>}}		\|Description=<nowiki>Return PresentAsText of question in export</nowiki>}}
			{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>SetExportOptionsAsMultipleColumnsForAllQuestions</nowiki>\|Parameters=
			{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionValue</nowiki>\|Description=<nowiki>Option value (true/false)</nowiki>}}
			\|Description=<nowiki>Set value of the OptionsAsMultipleColumns option for all questions whose type is Multi or MultiGrid</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}
	\|Properties=		\|Properties=
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>CsvFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>CsvFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
			{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExcelFileOptionsAddQuestionText</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if add question text to the file is enable</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExcelFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExcelFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportAddressInformation</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>ExportAddressInformation</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}

← Older revision		Revision as of 07:04, 2 July 2020
Line 2:		Line 2:
	\|Name=<nowiki>ExportSettingsExcelCsvFile</nowiki>		\|Name=<nowiki>ExportSettingsExcelCsvFile</nowiki>
	\|Description=<nowiki>Export settings for the Excel and Csv File format.</nowiki>		\|Description=<nowiki>Export settings for the Excel and Csv File format.</nowiki>
	\|Methods=		\|InheritsFrom=object\|Methods=
	{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=		{{CGscriptMethods_Template\|ReturnType=Empty\|Name=<nowiki>AddAllQuestions</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>presentAsText</nowiki>\|Description=<nowiki>Export the option as the value or as the text</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionsAsMultipleColumns</nowiki>\|Description=<nowiki>Export the options as multiple columns</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToCsv</nowiki>\|Description=<nowiki>Export to the given format</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>exportToExcel</nowiki>\|Description=<nowiki>Export to the given format</nowiki>}}
Line 34:		Line 34:
	{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionValue</nowiki>\|Description=<nowiki>Option value (true/false)</nowiki>}}		{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>questionnaireResourceId</nowiki>\|Description=<nowiki>The questionnaire the question is located in</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>optionValue</nowiki>\|Description=<nowiki>Option value (true/false)</nowiki>}}
	\|Description=<nowiki>Set value of the OptionsAsMultipleColumns option for all questions whose type is Multi or MultiGrid</nowiki>}}		\|Description=<nowiki>Set value of the OptionsAsMultipleColumns option for all questions whose type is Multi or MultiGrid</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Description=<nowiki>The string representation of the object.</nowiki>}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Inherited=object\|Description=<nowiki>The string representation of the object.</nowiki>}}
	\|Properties=		\|Properties=
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>CsvFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>CsvFileOptionsUseCommaSeparatedFormat</nowiki>\|HasGetter=1\|HasSetter=1\|Description=<nowiki>Get/set if exporting to specific format with given option</nowiki>}}
Line 46:		Line 46:
	{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>IsExcelFileExport</nowiki>\|HasGetter=1\|Description=<nowiki>Get if exporting to specific format</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=bool\|Name=<nowiki>IsExcelFileExport</nowiki>\|HasGetter=1\|Description=<nowiki>Get if exporting to specific format</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=string\|Name=<nowiki>ObjectTypeName</nowiki>\|HasGetter=1\|Description=<nowiki>The name of the type of object.</nowiki>}}
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Description=<nowiki>Get information about this class.</nowiki>}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=<nowiki>TypeInformation</nowiki>\|HasGetter=1\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}
	}}		}}