CodeMorphis   
  Home » SCPs » My Account  |  Cart Contents  |  Checkout   
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
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
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
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
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
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
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 more
0 items
Notifications more
NotificationsNotify me of updates to Excel Interface SCP