xlsCLR

using System.Data;
using System.Xml;
using Microsoft.VisualBasic;
using System;

struct xlsCLR.axXlsColType : System.IComparable
     , System.IFormattable
     , System.IConvertible
     , System.Enum
     , System.ValueType
     , System.Object
{
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.String ToString();
  System.String ToString(System.String, System.IFormatProvider);
  Int32 CompareTo(System.Object);
  System.String ToString(System.String);
  System.String ToString(System.IFormatProvider);
  Boolean HasFlag(System.Enum);
  System.TypeCode GetTypeCode();
  System.Type GetType();
}

class xlsCLR.myXLS : System.Object
{
  Void xls_SheetList(System.Data.SqlTypes.SqlString, System.Data.SqlTypes.SqlBoolean);
  System.Data.SqlTypes.SqlXml axSheetData(System.Data.SqlTypes.SqlString, System.Data.SqlTypes.SqlString, System.Data.SqlTypes.SqlString);
  System.Data.SqlTypes.SqlBoolean axSheetExists(System.Data.SqlTypes.SqlString, System.Data.SqlTypes.SqlString);
  System.Collections.IEnumerable axSheetList(System.Data.SqlTypes.SqlString);
  Void iXLSsheet(System.Object, System.Data.SqlTypes.SqlInt32 ByRef, System.Data.SqlTypes.SqlString ByRef);
  System.String CleanSheetName(System.String);
  System.Collections.IEnumerable axColumnListBySheetName(System.Data.SqlTypes.SqlString, System.Data.SqlTypes.SqlString);
  Void iXLScolumn(System.Object, System.Data.SqlTypes.SqlString ByRef, System.Data.SqlTypes.SqlString ByRef, System.Data.SqlTypes.SqlString ByRef, System.Data.SqlTypes.SqlString ByRef, System.Data.SqlTypes.SqlInt32 ByRef, System.Data.SqlTypes.SqlInt32 ByRef);
  xlsCLR.axXlsColType TypeColumnXLS(Int32);
  System.Data.SqlTypes.SqlInt32 toSQLInt(System.Object);
  System.Data.SqlTypes.SqlString toSQLString(System.Object);
  System.Data.SqlTypes.SqlString cl_fix_data(System.Data.SqlTypes.SqlString, System.Data.SqlTypes.SqlString, System.Data.SqlTypes.SqlString);
  System.String CleanInvalidXmlChars(System.String);
  System.String ToString();
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.Type GetType();
}

class xlsCLR.ixlscolum : System.Object
{
  Void irow(System.Object, System.Data.SqlTypes.SqlInt32 ByRef, System.Data.SqlTypes.SqlString ByRef, System.Data.SqlTypes.SqlString ByRef);
  System.String ToString();
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.Type GetType();
}

class xlsCLR.ixlscolum_properties : System.Object
{
  System.String ToString();
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.Type GetType();

  System.Data.SqlTypes.SqlInt32 column_index { get; set; }
  System.Data.SqlTypes.SqlString column_name { get; set; }
  System.Data.SqlTypes.SqlString type_column { get; set; }
}

struct xlsCLR.icaptionFrom : System.IComparable
     , System.IFormattable
     , System.IConvertible
     , System.Enum
     , System.ValueType
     , System.Object
{
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.String ToString();
  System.String ToString(System.String, System.IFormatProvider);
  Int32 CompareTo(System.Object);
  System.String ToString(System.String);
  System.String ToString(System.IFormatProvider);
  Boolean HasFlag(System.Enum);
  System.TypeCode GetTypeCode();
  System.Type GetType();
}

class xlsCLR.XMLtools : System.IDisposable
    , System.Object
{
  System.String ReplaceRegex(System.String, System.String, System.String);
  System.Xml.XmlNode SelectSingleNode(System.String);
  Void importNode(System.String, System.Xml.XmlDocument, System.String);
  Void importNodeToField(System.Xml.XmlDocument, System.String);
  System.Xml.XmlNode addelement(System.String, System.String, System.String);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.String, System.String);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.Data.DataRow, System.Data.DataColumn, xlsCLR.icaptionFrom);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.Data.DataRow, System.Data.DataColumn, xlsCLR.icaptionFrom, System.String, System.String);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.Data.DataRow, System.Data.DataColumn, xlsCLR.icaptionFrom, System.String, System.String, Int32);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.Data.DataRow, System.Data.DataColumn, xlsCLR.icaptionFrom, System.String, System.String, Int32, System.String);
  System.String HeaderColumnInfoResult(System.Data.DataTable, xlsCLR.icaptionFrom, System.String);
  System.String HeaderColumnInfoSQLdeclareAndSelect(System.Data.DataTable, xlsCLR.icaptionFrom, System.String);
  System.String tree_root(System.Xml.XmlNode);
  System.String OPENXMLInfoSQLdeclareAndinsert(System.Data.DataTable, System.Xml.XmlNode, xlsCLR.icaptionFrom, System.String);
  System.Xml.XmlNode addelement(System.String, System.String, Boolean);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.String, Boolean);
  System.Xml.XmlNode addelement(System.String, System.String, System.DateTime, System.String);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.String, System.DateTime, System.String);
  System.Xml.XmlNode addelement(System.String, System.String, System.Object);
  System.Xml.XmlNode addelement(System.Xml.XmlNode, System.String, System.Object);
  System.Xml.XmlNodeList listNodes(System.String);
  System.String GetValue(System.String);
  System.String GetValue(System.String, System.String);
  Void RecordData(System.String, System.Data.DataTable, System.String, System.String, System.String);
  Void RecordData(System.String, System.Data.DataTable);
  Void RecordData(System.String, System.Data.DataTable, Boolean);
  Void RecordData(System.String, System.Data.DataTable, System.String, Boolean, System.String, System.String);
  Void RecordData(System.String, System.Data.DataTable, System.String, Boolean, System.String, System.String, System.String, xlsCLR.icaptionFrom, System.String);
  Void Loadxml(System.String);
  Void Dispose();
  System.String ToString();
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.Type GetType();

  System.Xml.XmlDocument DataXML { get; set; }
}

class xlsCLR.myXLS+iXLSsheet_properties : System.Object
{
  System.String ToString();
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.Type GetType();

  System.Data.SqlTypes.SqlInt32 sheet_index { get; set; }
  System.Data.SqlTypes.SqlString sheet_name { get; set; }
}

class xlsCLR.myXLS+iXLScolumn_properties : System.Object
{
  System.String ToString();
  Boolean Equals(System.Object);
  Int32 GetHashCode();
  System.Type GetType();

  System.Data.SqlTypes.SqlString table_name { get; set; }
  System.Data.SqlTypes.SqlString column_name { get; set; }
  System.Data.SqlTypes.SqlString column_datatype { get; set; }
  System.Data.SqlTypes.SqlString column_maxlength { get; set; }
  System.Data.SqlTypes.SqlInt32 xls_type_column { get; set; }
  System.Data.SqlTypes.SqlInt32 ordinal_position { get; set; }
}