>public class ExcelExportColumnInfo >{ > private ColumnType _Type; > private string _DBColumnName = ""; > private string _ExcelColumnName = ""; > > public enum ColumnType > { > String, > Int32 > } > > public ColumnType Type > { > get { return _Type; } > set { _Type = value; } > } > > public string ExcelColumnName > { > get { return _ExcelColumnName; } > set { _ExcelColumnName = value; } > } > > public string DBColumnName > { > get { return _DBColumnName; } > set { _DBColumnName = value; } > } >} >>
>// Collection to hold the column information >ArrayList Columns = new ArrayList(); > >// One object for each column >ExcelExportColumnInfo Col1 = new ExcelExportColumnInfo(); >Col1.DBColumnName = "Customer"; >Col1.ExcelColumnName = "Conctrac # -- Customer"; >Col1.Type = ExcelExportColumnInfo.ColumnType.String; >Columns.Add(Col1); > >ExcelExportColumnInfo Col2 = new ExcelExportColumnInfo(); >Col2.DBColumnName = "Quantity"; >Col2.ExcelColumnName = "Quantity"; >Col1.Type = ExcelExportColumnInfo.ColumnType.Int32; >Columns.Add(Col2); > >ExcelExportColumnInfo Col3 = new ExcelExportColumnInfo(); >Col3.DBColumnName = "PartNumber"; >Col3.ExcelColumnName = "Part Number"; >Col1.Type = ExcelExportColumnInfo.ColumnType.String; >Columns.Add(Col3); > >ExcelExportColumnInfo Col4 = new ExcelExportColumnInfo(); >Col4.DBColumnName = "Location"; >Col4.ExcelColumnName = "Ship To"; >Col1.Type = ExcelExportColumnInfo.ColumnType.String; >Columns.Add(Col4); > >// Call the method to export the sheet to the database >Excel.ExportSheetToDB(ExpInfo, Columns); >>