IXlsImportColumnSplitter

COM interface ( getting help with interfaces )

interface IXlsImportColumnSplitter : IDispatch
{
  [id(1),propput] HRESULT SplitBySeparator([in]WCHAR cSepCharacter);
  [id(2),propput] HRESULT SplitByLength([in]int nSplitLen);
  [id(3)]         HRESULT AddColumn([in]BSTR name, [out, retval]IXlsImportColumnSplit** splitColumn);
}

HRESULT SplitBySeparator([in]WCHAR cSepCharacter);
sets the separation character for splitting import columns into multiple columns.

HRESULT SplitByLength([in]int nSplitLen);
sets the string length for splitting import columns into multiple columns.

HRESULT AddColumn([in]BSTR name, [out, retval]IXlsImportColumnSplit** splitColumn);
returns a split column, for accessing options.