ExcelSheet class - Revision history

Administrator at 07:03, 2 July 2020

2020-07-02T07:03:01Z

← Older revision		Revision as of 07:03, 2 July 2020
Line 1:		Line 1:
	{{CGscriptClass_Template		{{CGscriptClass_Template
	\|Name=ExcelSheet		\|Name=<nowiki>ExcelSheet</nowiki>
	\|Description=An excel sheet		\|Description=<nowiki>An excel sheet</nowiki>
	\|Constructors=		\|InheritsFrom=object\|Constructors=
	{{CGscriptConstructors_Template\|Parameters=		{{CGscriptConstructors_Template\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=filename\|Description=Name of the file\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=isTemp\|Description=Is the file temporary}}		{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>filename</nowiki>\|Description=<nowiki>Name of the file</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=<nowiki>isTemp</nowiki>\|Description=<nowiki>Is the file temporary</nowiki>}}
	\|Description=Load a file from FileNamespace}}		\|Description=<nowiki>Load a file from FileNamespace</nowiki>}}
	\|Methods=		\|Methods=
	{{CGscriptMethods_Template\|ReturnType=array\|Name=ToArray\|Parameters=		{{CGscriptMethods_Template\|ReturnType=array\|Name=<nowiki>ToArray</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=sheetName\|Description=The sheet to convert\|Comma=,}}{{CGscriptParameters_Template\|Type=~~number~~\|Name=fromrow\|Description=Skip number of rows}}		{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>sheetName</nowiki>\|Description=<nowiki>The sheet to convert</nowiki>\|Comma=,}}{{CGscriptParameters_Template\|Type=int\|Name=<nowiki>fromrow</nowiki>\|Description=<nowiki>Skip number of rows</nowiki>}}
	\|Description=Convert the sheet to an array of equal sized arrays}}		\|Description=<nowiki>Convert the sheet to an array of equal sized arrays</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=array\|Name=ToHeaders\|Parameters=		{{CGscriptMethods_Template\|ReturnType=array\|Name=<nowiki>ToHeaders</nowiki>\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=sheetName\|Description=The sheet to convert}}		{{CGscriptParameters_Template\|Type=string\|Name=<nowiki>sheetName</nowiki>\|Description=<nowiki>The sheet to convert</nowiki>}}
	\|Description=Convert the first row to array of strings}}		\|Description=<nowiki>Convert the first row to array of strings</nowiki>}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=ToString\|Description=The string representation of the object.}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=<nowiki>ToString</nowiki>\|Inherited=object\|Description=<nowiki>The string representation of the object.</nowiki>}}
	\|Properties=		\|Properties=
	{{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=array\|Name=SheetNames\|HasGetter=1\|Description=Get list of sheets in the excel file}}		{{CGscriptProperties_Template\|ReturnType=array\|Name=<nowiki>SheetNames</nowiki>\|HasGetter=1\|Description=<nowiki>Get list of sheets in the excel file</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\|Inherited=object\|Description=<nowiki>Get information about this class.</nowiki>}}
	}}		}}

	~~=== Examples ===~~

	~~<source lang="javascript">~~
	~~string filename = "Upload2.xlsx";~~
	~~bool isTemp = true;~~
	~~ExcelSheet es = new ExcelSheet(filename, isTemp);~~
	~~string sheet1 = es.SheetNames.First(function(string a) { true; });~~
	~~array headers = es.ToHeaders(sheet1);~~
	~~array data = es.ToArray(sheet1, 1);~~
	~~ImportManager im = new ImportManager(headers, data, ...);~~
	~~Catglobe.File.Delete(filename, isTemp);~~
	~~</source>~~

Hoanghonhungocy at 03:51, 9 September 2016

2016-09-09T03:51:35Z

← Older revision		Revision as of 03:51, 9 September 2016
Line 27:		Line 27:
	ExcelSheet es = new ExcelSheet(filename, isTemp);		ExcelSheet es = new ExcelSheet(filename, isTemp);
	string sheet1 = es.SheetNames.First(function(string a) { true; });		string sheet1 = es.SheetNames.First(function(string a) { true; });
	array headers = es.ToHeaders();		array headers = es.ToHeaders(sheet1);
	array data = es.ToArray(sheet1, 1);		array data = es.ToArray(sheet1, 1);
	ImportManager im = new ImportManager(headers, data, ...);		ImportManager im = new ImportManager(headers, data, ...);
	Catglobe.File.Delete(filename, isTemp);		Catglobe.File.Delete(filename, isTemp);
	</source>		</source>

Hoanghonhungocy at 04:48, 7 April 2015

2015-04-07T04:48:03Z

← Older revision		Revision as of 04:48, 7 April 2015
Line 1:		Line 1:
	{{CGscriptClass_Template		{{CGscriptClass_Template
	\|Name=~~<nowiki>~~ExcelSheet~~</nowiki>~~		\|Name=ExcelSheet
	\|Description=~~<nowiki>~~An excel sheet~~</nowiki>~~		\|Description=An excel sheet
	\|Constructors=		\|Constructors=
	{{CGscriptConstructors_Template\|Parameters=		{{CGscriptConstructors_Template\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=~~<nowiki>~~filename~~</nowiki>~~\|Description=~~<nowiki>~~Name of the file~~</nowiki>~~\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=~~<nowiki>~~isTemp~~</nowiki>~~\|Description=~~<nowiki>~~Is the file temporary~~</nowiki>~~}}		{{CGscriptParameters_Template\|Type=string\|Name=filename\|Description=Name of the file\|Comma=,}}{{CGscriptParameters_Template\|Type=bool\|Name=isTemp\|Description=Is the file temporary}}
	\|Description=~~<nowiki>~~Load a file from FileNamespace~~</nowiki>~~}}		\|Description=Load a file from FileNamespace}}
	\|Methods=		\|Methods=
	{{CGscriptMethods_Template\|ReturnType=array\|Name=~~<nowiki>~~ToArray~~</nowiki>~~\|Parameters=		{{CGscriptMethods_Template\|ReturnType=array\|Name=ToArray\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=~~<nowiki>~~sheetName~~</nowiki>~~\|Description=~~<nowiki>~~The sheet to convert~~</nowiki>~~\|Comma=,}}{{CGscriptParameters_Template\|Type=number\|Name=~~<nowiki>~~fromrow~~</nowiki>~~\|Description=~~<nowiki>~~Skip number of rows~~</nowiki>~~}}		{{CGscriptParameters_Template\|Type=string\|Name=sheetName\|Description=The sheet to convert\|Comma=,}}{{CGscriptParameters_Template\|Type=number\|Name=fromrow\|Description=Skip number of rows}}
	\|Description=~~<nowiki>~~Convert the sheet to an array of equal sized arrays~~</nowiki>~~}}		\|Description=Convert the sheet to an array of equal sized arrays}}
	{{CGscriptMethods_Template\|ReturnType=array\|Name=~~<nowiki>~~ToHeaders~~</nowiki>~~\|Parameters=		{{CGscriptMethods_Template\|ReturnType=array\|Name=ToHeaders\|Parameters=
	{{CGscriptParameters_Template\|Type=string\|Name=~~<nowiki>~~sheetName~~</nowiki>~~\|Description=~~<nowiki>~~The sheet to convert~~</nowiki>~~}}		{{CGscriptParameters_Template\|Type=string\|Name=sheetName\|Description=The sheet to convert}}
	\|Description=~~<nowiki>~~Convert the first row to array of strings~~</nowiki>~~}}		\|Description=Convert the first row to array of strings}}
	{{CGscriptMethods_Template\|ReturnType=string\|Name=~~<nowiki>~~ToString~~</nowiki>~~\|Description=~~<nowiki>~~The string representation of the object.~~</nowiki>~~}}		{{CGscriptMethods_Template\|ReturnType=string\|Name=ToString\|Description=The string representation of the object.}}
	\|Properties=		\|Properties=
	{{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=ObjectTypeName\|HasGetter=1\|Description=The name of the type of object.}}
	{{CGscriptProperties_Template\|ReturnType=array\|Name=~~<nowiki>~~SheetNames~~</nowiki>~~\|HasGetter=1\|Description=~~<nowiki>~~Get list of sheets in the excel file~~</nowiki>~~}}		{{CGscriptProperties_Template\|ReturnType=array\|Name=SheetNames\|HasGetter=1\|Description=Get list of sheets in the excel file}}
	{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=~~<nowiki>~~TypeInformation~~</nowiki>~~\|HasGetter=1\|Description=~~<nowiki>~~Get information about this class.~~</nowiki>~~}}		{{CGscriptProperties_Template\|ReturnType=TypeInformation\|Name=TypeInformation\|HasGetter=1\|Description=Get information about this class.}}
	}}		}}

	=== Examples ===		=== Examples ===

	<source lang="javascript">		<source lang="javascript">
	string filename = "Upload2.xlsx";		string filename = "Upload2.xlsx";
	bool isTemp = true;		bool isTemp = true;
	ExcelSheet es = new ExcelSheet(filename, isTemp);		ExcelSheet es = new ExcelSheet(filename, isTemp);
	string sheet1 = es.SheetNames.First();		string sheet1 = es.SheetNames.First(function(string a) { true; });
	array headers = es.ToHeaders();		array headers = es.ToHeaders();
	array data = es.ToArray(sheet1, 1);		array data = es.ToArray(sheet1, 1);
Line 31:		Line 32:
	Catglobe.File.Delete(filename, isTemp);		Catglobe.File.Delete(filename, isTemp);
	</source>		</source>

	~~[[Category:Classes]]~~

Tungocman at 04:44, 7 April 2015

2015-04-07T04:44:36Z

← Older revision		Revision as of 04:44, 7 April 2015
Line 22:		Line 22:
	=== Examples ===		=== Examples ===
	<source lang="javascript">		<source lang="javascript">
	string filename = "~~abc~~";		string filename = "Upload2.xlsx";
	bool isTemp = true;		bool isTemp = true;
	ExcelSheet es = new ExcelSheet(filename, isTemp);		ExcelSheet es = new ExcelSheet(filename, isTemp);

Tungocman at 04:42, 7 April 2015

2015-04-07T04:42:02Z

← Older revision		Revision as of 04:42, 7 April 2015
Line 22:		Line 22:
	=== Examples ===		=== Examples ===
	<source lang="javascript">		<source lang="javascript">
			string filename = "abc";
			bool isTemp = true;
			ExcelSheet es = new ExcelSheet(filename, isTemp);
			string sheet1 = es.SheetNames.First();
			array headers = es.ToHeaders();
			array data = es.ToArray(sheet1, 1);
			ImportManager im = new ImportManager(headers, data, ...);
			Catglobe.File.Delete(filename, isTemp);
	</source>		</source>

	[[Category:Classes]]		[[Category:Classes]]

Tungocman: Created page with "{{CGscriptClass_Template |Name=ExcelSheet |Description=An excel sheet |Constructors= {{CGscriptConstructors_Template|Parameters= {{CGscriptPa..."

2015-04-07T04:40:58Z

Created page with "{{CGscriptClass_Template |Name=<nowiki>ExcelSheet</nowiki> |Description=<nowiki>An excel sheet</nowiki> |Constructors= {{CGscriptConstructors_Template|Parameters= {{CGscriptPa..."

New page

{{CGscriptClass_Template
|Name=<nowiki>ExcelSheet</nowiki>
|Description=<nowiki>An excel sheet</nowiki>
|Constructors=
{{CGscriptConstructors_Template|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>filename</nowiki>|Description=<nowiki>Name of the file</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=bool|Name=<nowiki>isTemp</nowiki>|Description=<nowiki>Is the file temporary</nowiki>}}
|Description=<nowiki>Load a file from FileNamespace</nowiki>}}
|Methods=
{{CGscriptMethods_Template|ReturnType=array|Name=<nowiki>ToArray</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>sheetName</nowiki>|Description=<nowiki>The sheet to convert</nowiki>|Comma=,}}{{CGscriptParameters_Template|Type=number|Name=<nowiki>fromrow</nowiki>|Description=<nowiki>Skip number of rows</nowiki>}}
|Description=<nowiki>Convert the sheet to an array of equal sized arrays</nowiki>}}
{{CGscriptMethods_Template|ReturnType=array|Name=<nowiki>ToHeaders</nowiki>|Parameters=
{{CGscriptParameters_Template|Type=string|Name=<nowiki>sheetName</nowiki>|Description=<nowiki>The sheet to convert</nowiki>}}
|Description=<nowiki>Convert the first row to array of strings</nowiki>}}
{{CGscriptMethods_Template|ReturnType=string|Name=<nowiki>ToString</nowiki>|Description=<nowiki>The string representation of the object.</nowiki>}}
|Properties=
{{CGscriptProperties_Template|ReturnType=string|Name=<nowiki>ObjectTypeName</nowiki>|HasGetter=1|Description=<nowiki>The name of the type of object.</nowiki>}}
{{CGscriptProperties_Template|ReturnType=array|Name=<nowiki>SheetNames</nowiki>|HasGetter=1|Description=<nowiki>Get list of sheets in the excel file</nowiki>}}
{{CGscriptProperties_Template|ReturnType=TypeInformation|Name=<nowiki>TypeInformation</nowiki>|HasGetter=1|Description=<nowiki>Get information about this class.</nowiki>}}
}}

=== Examples ===
<source lang="javascript">

</source>

[[Category:Classes]]