Ict.Common.IO.TExcel Class Reference

This contains some functions to write into Excel via remote calls constants from http:www.p6c.com/CommonTypelibs/O2000_EXCEL9.CSV More...

Public Member Functions
	TExcel ()
	Instantiate Microsoft Excel More...
System.Object	NewSheet (String sheetName)
	todoComment More...
System.Object	GetRange (System.Int32 column, System.Int32 row)
	Get a range object that contains cell (column, row). More...
System.Object	GetRange (System.Int32 column, System.Int32 row, System.Int32 col2, System.Int32 row2)
	todoComment More...
void	SetValue (System.Object range, System.Object value)
	Write value in cell. More...
void	SetFormula (System.Object range, String formula)
	Write formula in cell. More...
void	AddChart (String chartSheetName, String title, System.Object valueRange, XlChartType typeOfChart)
	add a chart with dimensions and referencing range More...
void	Show ()
	overload More...
void	GiveUserControl ()
	leave Excel to the user, disconnect this program of it More...

Detailed Description

This contains some functions to write into Excel via remote calls constants from http:www.p6c.com/CommonTypelibs/O2000_EXCEL9.CSV

Constructor & Destructor Documentation

TExcel()

Ict.Common.IO.TExcel.TExcel ( )

inline

Instantiate Microsoft Excel

Returns

void

Member Function Documentation

AddChart()

void Ict.Common.IO.TExcel.AddChart ( String  chartSheetName, String  title, System.Object  valueRange, XlChartType  typeOfChart  )

inline

add a chart with dimensions and referencing range

Returns

void

GetRange() [1/2]

System.Object Ict.Common.IO.TExcel.GetRange ( System.Int32  column, System.Int32  row  )

inline

Get a range object that contains cell (column, row).

Returns

void

GetRange() [2/2]

System.Object Ict.Common.IO.TExcel.GetRange ( System.Int32  column, System.Int32  row, System.Int32  col2, System.Int32  row2  )

inline

todoComment

Parameters

column
row
col2
row2

Returns

GiveUserControl()

void Ict.Common.IO.TExcel.GiveUserControl ( )

inline

leave Excel to the user, disconnect this program of it

Returns

void

NewSheet()

System.Object Ict.Common.IO.TExcel.NewSheet ( String  sheetName )

inline

todoComment

Parameters

sheetName

Returns

SetFormula()

void Ict.Common.IO.TExcel.SetFormula ( System.Object  range, String  formula  )

inline

Write formula in cell.

Returns

void

SetValue()

void Ict.Common.IO.TExcel.SetValue ( System.Object  range, System.Object  value  )

inline

Write value in cell.

Returns

void

Show()

void Ict.Common.IO.TExcel.Show ( )

inline

overload

---

The documentation for this class was generated from the following file:

• csharp/ICT/Common/IO/Excel.cs