Tabulation exportToExcel - Revision history

Administrator: /* Arguments */

2018-10-15T04:21:39Z

Arguments

← Older revision		Revision as of 04:21, 15 October 2018
Line 19:		Line 19:

	* 2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)		* 2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)

			NOTE: Tables only show on same excel sheet when they have same columns:

			* Example case for showing tables on same sheet: {}x{X}, {A}x{X}, {B}x{X}, {C,D}x{X} or {}x{X,Y}, {A}x{X,Y}, {B}x{X,Y}, {C,D}x{X,Y}

			* Example case for showing tables on difference sheets: {A}x{X}, {A}x{Y} or {A}x{X}, {B}x{X,Y}

	== Return type ==		== Return type ==

Administrator at 04:01, 15 October 2018

2018-10-15T04:01:27Z

← Older revision		Revision as of 04:01, 15 October 2018
Line 10:		Line 10:
	== Arguments ==		== Arguments ==

	* string ''fileName''		- string ''fileName''

	* bool ''isTemporaryFile''		- bool ''isTemporaryFile''

	* constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)		- constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)

	- 1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)		* 1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)

	- 2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)		* 2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)

	== Return type ==		== Return type ==

Administrator at 04:00, 15 October 2018

2018-10-15T04:00:40Z

← Older revision		Revision as of 04:00, 15 October 2018
Line 16:		Line 16:
	* constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)		* constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)

	-1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)		- 1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)

	-2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)		- 2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)

	== Return type ==		== Return type ==

Administrator at 04:00, 15 October 2018

2018-10-15T04:00:28Z

← Older revision		Revision as of 04:00, 15 October 2018
Line 10:		Line 10:
	== Arguments ==		== Arguments ==

	- string ''fileName''		* string ''fileName''

	- bool ''isTemporaryFile''		* bool ''isTemporaryFile''

	- constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)		* constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)

	*1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)		-1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)

	*2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)		-2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)

	== Return type ==		== Return type ==

Administrator at 03:59, 15 October 2018

2018-10-15T03:59:54Z

← Older revision		Revision as of 03:59, 15 October 2018
Line 10:		Line 10:
	== Arguments ==		== Arguments ==

	- string ''fileName''		- string ''fileName''

	- bool ''isTemporaryFile''		- bool ''isTemporaryFile''

	- constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)		- constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)

Administrator: /* Arguments */

2018-10-15T03:59:32Z

Arguments

← Older revision		Revision as of 03:59, 15 October 2018
Line 10:		Line 10:
	== Arguments ==		== Arguments ==

	string ''fileName''		- string ''fileName''

	bool ''isTemporaryFile''		- bool ''isTemporaryFile''

	constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)		- constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)

	*1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)		*1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)

	*2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)		*2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)



	== Return type ==		== Return type ==

Administrator at 10:32, 7 August 2018

2018-08-07T10:32:55Z

← Older revision		Revision as of 10:32, 7 August 2018
Line 14:		Line 14:
	bool ''isTemporaryFile''		bool ''isTemporaryFile''

	constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on a sheet)		constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on separate sheet)

	*1: Tabulation_SheetDistribution_OneTabulationEach (each table show on a sheet)		*1: Tabulation_SheetDistribution_OneTabulationEach (each table show on separate sheet)

	*2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)		*2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)

Administrator: Created page with "Category:Diagram/report_generating_CGScript_functions = Tabulation_exportToExcel = Export tabulation to Excel == Syntax == Tabulation_exportToExcel(string fileName, boo..."

2018-08-07T10:26:24Z

Created page with "Category:Diagram/report_generating_CGScript_functions = Tabulation_exportToExcel = Export tabulation to Excel == Syntax == Tabulation_exportToExcel(string fileName, boo..."

New page

[[Category:Diagram/report_generating_CGScript_functions]]

= Tabulation_exportToExcel =
Export tabulation to Excel

== Syntax ==

Tabulation_exportToExcel(string fileName, bool isTemporaryFile[, constant worksheetDistribution]);

== Arguments ==

string ''fileName''

bool ''isTemporaryFile''

constant ''worksheetDistribution'': this is optional parameter. If not set will use default with option 1 (each table show on a sheet)

*1: Tabulation_SheetDistribution_OneTabulationEach (each table show on a sheet)

*2: Tabulation_SheetDistribution_ByHorizontalAxis (tables with same number of columns show on a sheet)

== Return type ==
Empty

== Example ==

<source lang="javascript">
//Example for each table show each sheet: not set third parameter
DCS_use(15645932);
createCrossDiagram({"Q1"},{"Gender"});
createCrossDiagram({"Q2"},{"Gender"});
string fileName = "test.xls";
Tabulation_exportToExcel(fileName, true);
print(getWebRoot()+ Catglobe.File.GetDownloadPath(fileName, true));
</source>

<source lang="javascript">
//Example for each table show each sheet: use third parameter with Tabulation_SheetDistribution_OneTabulationEach
DCS_use(15645932);
createCrossDiagram({"Q1"},{"Gender"});
createCrossDiagram({"Q2"},{"Gender"});
string fileName = "test.xls";
Tabulation_exportToExcel(fileName, true, Tabulation_SheetDistribution_OneTabulationEach);
print(getWebRoot()+ Catglobe.File.GetDownloadPath(fileName, true));
</source>
[[File:2018-08-07_16-49-48.png]]

<source lang="javascript">
//Example for tables with same columns show on same sheet: use third parameter with Tabulation_SheetDistribution_ByHorizontalAxis
DCS_use(15645932);
createCrossDiagram({"Q1"},{"Gender"});
createCrossDiagram({"Q2"},{"Gender"});
string fileName = "test.xls";
Tabulation_exportToExcel(fileName, true, Tabulation_SheetDistribution_ByHorizontalAxis);
print(getWebRoot()+ Catglobe.File.GetDownloadPath(fileName, true));
</source>
[[File:2018-08-07_16-51-42.png]]