CodeMorphis - Visual Programming Tool

Products

Introducing Synopsis
Synopsis Demos
Download Synopsis
SCPs

Services

Consulting

Community

FAQ
Forums
Log In

Company

About CodeMorphis
Contact Us
Links

Other

Conditions of Use
Privacy Notice
Synopsis White Paper
Survey
Site Map

Excel Interface SCP

USD $50.00

Available Options:
Format:
File size:	662.2k

Contains one (1) component:

Excel Interface component: provides programmatic access and control of Microsoft Excel files (*.xls).

Product: Synopsis 2.0

Excel Interface Component

Component Tray Tab: Application

Usage

The Excel Interface component provides programmatic access and control of Microsoft Excel files.

The first service to call is either the Create service or the Open service.

Usage of this component requires that Microsoft Excel be installed on the target machine.

Properties

Property	Details
Active service	The component service to invoke.

Services

Service	Details
Add cell fmt cond	Add cell format condition.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
		1	Format	Condition format
		2	Value	Condition value
		3	Define font color	Define font color
		4	Font R	R color channel (0-255)
		5	Font G	G color channel (0-255)
		6	Font B	B color channel (0-255)
		7	Define border color	Define border color
		8	Border R	R color channel (0-255)
		9	Border G	G color channel (0-255)
		10	Border B	B color channel (0-255)
		11	Define interior color	Define interior color
		12	Interior R	R color channel (0-255)
		13	Interior G	G color channel (0-255)
		14	Interior B	B color channel (0-255)
	Output	0	Index	Format condition index
Add cur rng fmt cond	Add current range format condition. The service affects the current cell range as set by the Set cur rng service.
	Argument			Description
	Input	0	Format	Condition format
		1	Value	Condition value
		2	Define font color	Define font color
		3	Font R	R color channel (0-255)
		4	Font G	G color channel (0-255)
		5	Font B	B color channel (0-255)
		6	Define border color	Define border color
		7	Border R	R color channel (0-255)
		8	Border G	G color channel (0-255)
		9	Border B	B color channel (0-255)
		10	Define interior color	Define interior color
		11	Interior R	R color channel (0-255)
		12	Interior G	G color channel (0-255)
		13	Interior B	B color channel (0-255)
	Output	0	Index	Format condition index
Add rng fmt cond	Add range format condition.
	Argument			Description
	Input	0	Start cell coord	Starting cell coordinate, e.g. A1
		1	End cell coord	Ending cell coordinate, e.g. B5
		2	Format	Condition format
		3	Value	Condition value
		4	Define font color	Define font color
		5	Font R	R color channel (0-255)
		6	Font G	G color channel (0-255)
		7	Font B	B color channel (0-255)
		8	Define border color	Define border color
		9	Border R	R color channel (0-255)
		10	Border G	G color channel (0-255)
		11	Border B	B color channel (0-255)
		12	Define interior color	Define interior color
		13	Interior R	R color channel (0-255)
		14	Interior G	G color channel (0-255)
		15	Interior B	B color channel (0-255)
	Output	0	Index	Format condition index
Add sheet	Add a new spreadsheet.
	Argument			Description
	Input	0	Sheet name	Sheet name
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Close	Close the Excel file.
	Argument			Description
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Create	Create a new instance of Excel.
	Argument			Description
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Delete sheet	Delete a spreadsheet.
	Argument			Description
	Input	0	Sheet name	Sheet name
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Get cell date	Get cell date value.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
	Output	0	Value	Cell value
Get cell type	Get cell value type.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
	Output	0	Value type	Type to use to retrieve cell value
Get cell value	Get cell value.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
	Input	1	Value type	Type to use to retrieve cell value
	Output	0	Value	Cell value
Merge cur rng	Merge current range. The service affects the current cell range as set by the Set cur rng service.
	Argument			Description
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Merge rng	Merge range.
	Argument			Description
	Input	0	Start cell coord	Starting cell coordinate, e.g. A1
	Input	1	End cell coord	Ending cell coordinate, e.g. B5
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Num sheets	Get number of spreadsheets.
	Argument			Description
	Output	0	Num sheets	Number of sheets
Open	Open an existing Excel file.
	Argument			Description
	Input	0	Path	Path to existing Excel file
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Page setup	Open print page setup.
	Argument			Description
	Input	0	Orientation	Page orientation
	Input	1	Print gridlines	Show gridlines on print
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Rename sheet	Rename a spreadsheet.
	Argument			Description
	Input	0	Sheet name	Sheet name
	Input	1	New sheet name	New sheet name
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Save as	Save Excel file.
	Argument			Description
	Input	0	Path	Save path for Excel file
	Input	1	Overwrite	Overwrite exsiting file
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Select sheet	Select a spreadsheet.
	Argument			Description
	Input	0	Sheet name	Sheet name
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Set cell brd	Set cell border.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
		1	Border	Border type
		2	Line style	Border line style
		3	Width	Border width
		4	R	R color channel (0-255)
		5	G	G color channel (0-255)
		6	B	B color channel (0-255)
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Set cell col wd	Set cell column width.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
	Input	1	Width	Column width
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Set cell fmt cond brd	Set cell format condition border.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
		1	Index	Format condition index
		2	Border	Border type
		3	Line style	Border line style
		4	Width	Border width
		5	R	R color channel (0-255)
		6	G	G color channel (0-255)
		7	B	B color channel (0-255)
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Set cell fmt cond font	Set cell format condition font.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
		1	Index	Format condition index
		2	Font name	Font family name
		3	Font size	Font size
		4	R	R color channel (0-255)
		5	G	G color channel (0-255)
		6	B	B color channel (0-255)
		7	Italic	Italic
		8	Bold	Bold
		9	Strikethrough	Strikethrough
		10	Underline	Underline
		11	Subscript	Subscript
		12	Superscript	Superscript
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Set cell fmt cond int	Set cell format condition interior.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
		1	Index	Format condition index
		2	Pattern	Interior cell pattern
		3	R	R color channel (0-255)
		4	G	G color channel (0-255)
		5	B	B color channel (0-255)
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE
Set cell font	Set cell font.
	Argument			Description
	Input	0	Cell coord	Cell coordinate, e.g. A1
		1	Font name	Font family name
		2	Font size	Font size
		3	R	R color channel (0-255)
		4	G	G color channel (0-255)
		5	B	B color channel (0-255)
		6	Italic	Italic
		7	Bold	Bold
		8	Strikethrough	Strikethrough
		9	Underline	Underline
		10	Subscript	Subscript
		11	Superscript	Superscript
	Output	0	Succeeded	Operation succeeded: TRUE or FALSE

Currencies

Shopping Cart

0 items

Notifications

Notify me of updates to Excel Interface SCP