Found a problem in ExportdataTable - here ist the corrected version

[Wolfgang Preier]

///

/// Exports worksheet data into a DataTable ///

/// /// Row of the first cell from where DataTable should be exported /// /// /// Column of the first cell from where DataTable should be exported /// /// Maximum number of rows to export /// Maximum number of columns to export /// DataTable with worksheet data public DataTable ExportDataTable( int firstRow, int firstColumn, int maxRows, int maxColumns ) { if( firstRow < 1 || firstRow > DEF_MAX_ROW_ONE_INDEX ) throw new ArgumentOutOfRangeException( "firstRow" ); if( firstColumn < 1 || firstColumn > DEF_MAX_COLUMN_ONE_INDEX ) throw new ArgumentOutOfRangeException( "firstColumn" ); DataTable result = new DataTable( this.Name ); // Declare DataColumn and DataRow variables. DataColumn dataColumn; DataRow dataRow; maxColumns = Math.Min( maxColumns, DEF_MAX_COLUMN_ONE_INDEX - firstColumn + 1 ); maxRows = Math.Min( maxRows - 1, DEF_MAX_ROW_ONE_INDEX - firstRow + 2 ); for( int i = 0; i < maxColumns; i++ ) { dataColumn = new DataColumn(); dataColumn.DataType = System.Type.GetType( "System.String" ); dataColumn.ColumnName = Range[ firstRow, firstColumn + i ].Text; result.Columns.Add( dataColumn ); // maxRows--; } firstRow++; for( int i = 0; i < maxRows; i++ ) { dataRow = result.NewRow(); for( int j = 0; j < maxColumns; j++ ) { dataRow[ j ] = Range[ firstRow + i, firstColumn + j ].Text; } result.Rows.Add( dataRow ); } return result; }

[Administrator]

Hi Preier, Thanks for reporting this issue. We have already fixed the problem with the ExportDataTable method and have also added an overload for exporting any given range into a DataTable. All the changes will be included in the version 2.0.6.x. Thanks. Best regards, Stephen. > ///

> /// Exports worksheet data into a DataTable > ///

> /// > /// Row of the first cell from where DataTable should be exported > /// > /// > /// Column of the first cell from where DataTable should be exported > /// > /// Maximum number of rows to export > /// Maximum number of columns to export > /// DataTable with worksheet data > public DataTable ExportDataTable( int firstRow, int firstColumn, int maxRows, int maxColumns ) > { > if( firstRow < 1 || firstRow > DEF_MAX_ROW_ONE_INDEX ) > throw new ArgumentOutOfRangeException( "firstRow" ); > > if( firstColumn < 1 || firstColumn > DEF_MAX_COLUMN_ONE_INDEX ) > throw new ArgumentOutOfRangeException( "firstColumn" ); > > DataTable result = new DataTable( this.Name ); > > // Declare DataColumn and DataRow variables. > DataColumn dataColumn; > DataRow dataRow; > > maxColumns = Math.Min( maxColumns, DEF_MAX_COLUMN_ONE_INDEX - firstColumn + 1 ); > maxRows = Math.Min( maxRows - 1, DEF_MAX_ROW_ONE_INDEX - firstRow + 2 ); > > for( int i = 0; i < maxColumns; i++ ) > { > dataColumn = new DataColumn(); > dataColumn.DataType = System.Type.GetType( "System.String" ); > dataColumn.ColumnName = Range[ firstRow, firstColumn + i ].Text; > result.Columns.Add( dataColumn ); > // maxRows--; > } > > firstRow++; > > for( int i = 0; i < maxRows; i++ ) > { > dataRow = result.NewRow(); > > for( int j = 0; j < maxColumns; j++ ) > { > dataRow[ j ] = Range[ firstRow + i, firstColumn + j ].Text; > } > > result.Rows.Add( dataRow ); > } > > return result; > }