public void normilizeAllocation() {
    int nrfiles = 0;
    int nrsheets = 0;

    if ( fileName != null ) {
      nrfiles = fileName.length;
    } else {
      fileName = new String[ 0 ];
    }
    if ( sheetName != null ) {
      nrsheets = sheetName.length;
    } else {
      sheetName = new String[ 0 ];
    }
    if ( field == null ) {
      field = new ExcelInputField[ 0 ];
    }

    fileMask = normilizeArray( fileMask, nrfiles );
    excludeFileMask = normilizeArray( excludeFileMask, nrfiles );
    fileRequired = normilizeArray( fileRequired, nrfiles );
    includeSubFolders = normilizeArray( includeSubFolders, nrfiles );

    startRow = normilizeArray( startRow, nrsheets );
    startColumn = normilizeArray( startColumn, nrsheets );
  }
@Test
  public void testNormilizeAllocation() throws KettleException {
    Assert.assertEquals( 3, meta.getFileName().length );
    Assert.assertEquals( 3, meta.getFileMask().length );
    Assert.assertEquals( 3, meta.getExcludeFileMask().length );
    Assert.assertEquals( 3, meta.getFileRequired().length );
    Assert.assertEquals( 3, meta.getIncludeSubFolders().length );

    Assert.assertEquals( 4, meta.getSheetName().length );
    Assert.assertEquals( 4, meta.getStartRow().length );
    Assert.assertEquals( 4, meta.getStartColumn().length );

    Assert.assertArrayEquals( new String[] { "1", "2", "3" }, meta.getFileName() );
    Assert.assertArrayEquals( new String[] { "1", "2", "3", "4" }, meta.getSheetName() );

    for ( String str : meta.getFileMask() ) {
      Assert.assertEquals( null, str );
    }
    for ( String str : meta.getExcludeFileMask() ) {
      Assert.assertEquals( null, str );
    }
    for ( String str : meta.getFileRequired() ) {
      Assert.assertEquals( null, str );
    }
    for ( String str : meta.getIncludeSubFolders() ) {
      Assert.assertEquals( null, str );
    }
    for ( int itr : meta.getStartRow() ) {
      Assert.assertEquals( 0, itr );
    }
    for ( int itr : meta.getStartColumn() ) {
      Assert.assertEquals( 0, itr );
    }
  }