Package no.ugland.utransprod.util.excel

Examples of no.ugland.utransprod.util.excel.ExcelUtil.readCell()

134
135
136
137
138
139
140
141
142
143
144
    assertEquals("Egenproduksjon", cellValue);
    cellValue = excelUtil.readCell(row, 9, null);
    assertEquals("Frakt", cellValue);
    cellValue = excelUtil.readCell(row, 10, null);
    assertEquals("Montering", cellValue);
    cellValue = excelUtil.readCell(row, 11, null);
    assertEquals("Jalinjer", cellValue);
    cellValue = excelUtil.readCell(row, 12, null);
    assertEquals("DB", cellValue);
    cellValue = excelUtil.readCell(row, 13, null);
    assertEquals("DG", cellValue);
View Full Code Here
136
137
138
139
140
141
142
143
144
145
146
    assertEquals("Frakt", cellValue);
    cellValue = excelUtil.readCell(row, 10, null);
    assertEquals("Montering", cellValue);
    cellValue = excelUtil.readCell(row, 11, null);
    assertEquals("Jalinjer", cellValue);
    cellValue = excelUtil.readCell(row, 12, null);
    assertEquals("DB", cellValue);
    cellValue = excelUtil.readCell(row, 13, null);
    assertEquals("DG", cellValue);
  }
View Full Code Here
138
139
140
141
142
143
144
145
146
147
148
    assertEquals("Montering", cellValue);
    cellValue = excelUtil.readCell(row, 11, null);
    assertEquals("Jalinjer", cellValue);
    cellValue = excelUtil.readCell(row, 12, null);
    assertEquals("DB", cellValue);
    cellValue = excelUtil.readCell(row, 13, null);
    assertEquals("DG", cellValue);
  }

  @Test
  public void testShowSalesReportPrSalesman() throws ProTransException {
View Full Code Here
175
176
177
178
179
180
181
182
183
184
185
    excelUtil.openExcelFileForRead("excel/Salgsrapport20095050.xls");
    boolean lineNotFound = true;
    int row = 0;

    do {
      String cellValue = excelUtil.readCell(row, 0, null);
      if (cellValue != null && cellValue.equalsIgnoreCase("Tilbud")) {
        lineNotFound = false;
      }
      row++;
    } while (lineNotFound);
View Full Code Here
182
183
184
185
186
187
188
189
190
191
192
        lineNotFound = false;
      }
      row++;
    } while (lineNotFound);

    String cellValue = excelUtil.readCell(row, 0, null);
    assertEquals("Selger", cellValue);
    cellValue = excelUtil.readCell(row, 1, null);
    assertEquals("Antall", cellValue);
    cellValue = excelUtil.readCell(row, 2, null);
    assertEquals("Egenproduksjon", cellValue);
View Full Code Here
184
185
186
187
188
189
190
191
192
193
194
      row++;
    } while (lineNotFound);

    String cellValue = excelUtil.readCell(row, 0, null);
    assertEquals("Selger", cellValue);
    cellValue = excelUtil.readCell(row, 1, null);
    assertEquals("Antall", cellValue);
    cellValue = excelUtil.readCell(row, 2, null);
    assertEquals("Egenproduksjon", cellValue);
    cellValue = excelUtil.readCell(row, 3, null);
    assertEquals("Frakt", cellValue);
View Full Code Here
186
187
188
189
190
191
192
193
194
195
196
    String cellValue = excelUtil.readCell(row, 0, null);
    assertEquals("Selger", cellValue);
    cellValue = excelUtil.readCell(row, 1, null);
    assertEquals("Antall", cellValue);
    cellValue = excelUtil.readCell(row, 2, null);
    assertEquals("Egenproduksjon", cellValue);
    cellValue = excelUtil.readCell(row, 3, null);
    assertEquals("Frakt", cellValue);
    cellValue = excelUtil.readCell(row, 4, null);
    assertEquals("Montering", cellValue);
View Full Code Here
188
189
190
191
192
193
194
195
196
197
198
    assertEquals("Selger", cellValue);
    cellValue = excelUtil.readCell(row, 1, null);
    assertEquals("Antall", cellValue);
    cellValue = excelUtil.readCell(row, 2, null);
    assertEquals("Egenproduksjon", cellValue);
    cellValue = excelUtil.readCell(row, 3, null);
    assertEquals("Frakt", cellValue);
    cellValue = excelUtil.readCell(row, 4, null);
    assertEquals("Montering", cellValue);
    cellValue = excelUtil.readCell(row, 5, null);
    assertEquals("Jalinjer", cellValue);
View Full Code Here
190
191
192
193
194
195
196
197
198
199
200
    assertEquals("Antall", cellValue);
    cellValue = excelUtil.readCell(row, 2, null);
    assertEquals("Egenproduksjon", cellValue);
    cellValue = excelUtil.readCell(row, 3, null);
    assertEquals("Frakt", cellValue);
    cellValue = excelUtil.readCell(row, 4, null);
    assertEquals("Montering", cellValue);
    cellValue = excelUtil.readCell(row, 5, null);
    assertEquals("Jalinjer", cellValue);
    cellValue = excelUtil.readCell(row, 6, null);
    assertEquals("DB", cellValue);
View Full Code Here
192
193
194
195
196
197
198
199
200
201
202
    assertEquals("Egenproduksjon", cellValue);
    cellValue = excelUtil.readCell(row, 3, null);
    assertEquals("Frakt", cellValue);
    cellValue = excelUtil.readCell(row, 4, null);
    assertEquals("Montering", cellValue);
    cellValue = excelUtil.readCell(row, 5, null);
    assertEquals("Jalinjer", cellValue);
    cellValue = excelUtil.readCell(row, 6, null);
    assertEquals("DB", cellValue);
    cellValue = excelUtil.readCell(row, 7, null);
    assertEquals("DG", cellValue);
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.