/// <summary> /// Load the data from the <see cref="DataTable"/> starting from the top left cell of the range /// </summary> /// <param name="table"></param> /// <param name="paramsConfig"><see cref="Action{LoacFromCollectionParams}"/> to provide parameters to the function</param> /// <example> /// <code> /// sheet.Cells["C1"].LoadFromDataTable(dataTable, c => /// { /// c.PrintHeaders = true; /// c.TableStyle = TableStyles.Dark1; /// }); /// </code> /// </example> /// <returns>The filled range</returns> public ExcelRangeBase LoadFromDataTable(DataTable table, Action <LoadFromDataTableParams> paramsConfig) { var parameters = new LoadFromDataTableParams(); paramsConfig.Invoke(parameters); return(LoadFromDataTable(table, parameters.PrintHeaders, parameters.TableStyle)); }
public LoadFromDataTable(ExcelRangeBase range, DataTable dataTable, LoadFromDataTableParams parameters) { _range = range; _worksheet = range.Worksheet; _dataTable = dataTable; _printHeaders = parameters.PrintHeaders; _tableStyle = parameters.TableStyle; }
/// <summary> /// Load the data from the datatable starting from the top left cell of the range /// </summary> /// <param name="Table">The datatable to load</param> /// <param name="PrintHeaders">Print the column caption property (if set) or the columnname property if not, on first row</param> /// <param name="TableStyle">The table style to apply to the data</param> /// <returns>The filled range</returns> public ExcelRangeBase LoadFromDataTable(DataTable Table, bool PrintHeaders, TableStyles TableStyle) { var parameters = new LoadFromDataTableParams { PrintHeaders = PrintHeaders, TableStyle = TableStyle }; var func = new LoadFromDataTable(this, Table, parameters); return(func.Load()); }