IXlsTableDataSource

COM interface ( getting help with interfaces )

interface IXlsTableDataSource : IDispatch
{
  [id(1),propput] HRESULT ConnectionString([in]BSTR connectionString);
  [id(2),propput] HRESULT SQLStatement([in]BSTR statement);
  [id(3),propput] HRESULT DatatypesToDumpToFile([in]BSTR filename);
  [id(4),propget] HRESULT CommandTimeout([out, retval]int* commandtimeout);
  [id(4),propput] HRESULT CommandTimeout([in]int commandtimeout);
  [id(5),propget] HRESULT ConnectionTimeout([out, retval]int* connectiontimeout);
  [id(5),propput] HRESULT ConnectionTimeout([in]int connectiontimeout);
}

HRESULT ConnectionString([in]BSTR connectionString);
sets the connection string of the data source. Example : "dsn=database;uid=;pwd=;"

HRESULT SQLStatement([in]BSTR statement);
sets the SQL statement attached to the data source. Example : "select * from Table1"

HRESULT DatatypesToDumpToFile([in]BSTR filename);
sets the filename where xlsgen will write a summary of column data types as seen from the SQL stand point and column data types as seen by the data driver layer used by xlsgen. Default : no file is written.

HRESULT CommandTimeout([out, retval]int* commandtimeout);
returns the command timeout. Defaults to 30 seconds. 0 means indefinite wait.

HRESULT CommandTimeout([in]int commandtimeout);
sets the command timeout. Defaults to 30 seconds. 0 means indefinite wait. Meant to be set before the connection string.

HRESULT ConnectionTimeout([out, retval]int* connectiontimeout);
returns the connection timeout. Defaults to 15 seconds. 0 means indefinite wait.

HRESULT ConnectionTimeout([in]int connectiontimeout);
sets the connection timeout. Defaults to 15 seconds. 0 means indefinite wait. Meant to be set before the connection string.