Package jxl

Examples of jxl.Sheet

105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
   * @return list
   */
  public static List readExcelFileASheetByName(String excel_file_name) {
    try {
      Workbook book = Workbook.getWorkbook(new File(excel_file_name));
      Sheet sheet = book.getSheet(0);
      al = new ArrayList();
      Cell cellKey;
      Cell cellValue;
      for (int i = 0; i < column_count; i++) {
        List columndatas = new ArrayList();
        cellKey = sheet.getCell(i, i);
        for (int k = 0; k < row_count; k++) {
          cellValue = sheet.getCell(i, k);
          // System.out.println("��:" + (k + 1) + "�е�" + (i + 1) +
          // "��ֵ��:"+ cellValue.getContents());
          columndatas.add(cellValue.getContents());
        }// end for k
        al.add(columndatas);// ��һ�����ݷ�װ���ܵ�list��
View Full Code Here
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
      mcsl = 0;
    }
   
    synchronized boolean next() {
      while (current_sheet < sheets.length) {
        Sheet s = sheets[current_sheet];
        if (current_row == s.getRows()) {
          current_sheet ++;
          current_row = 0;
        } else try {
          cr.clear();
          Cell[] cs = s.getRow(current_row);
          cr.setObject("SHEET", current_sheet);
          cr.setObject("SHEET_NAME", s.getName());
          cr.setObject("ROW", current_row);
          //Загрузка строки
          for (int k = 0; k < cs.length; k++)
            cr.setObject("CLMN_" + (k+1), cs[k].getContents());
          for (int k = cs.length; k < mcsl; k++)
View Full Code Here
227
228
229
230
231
232
233
234
235
    excelView.render(new HashMap<String, Object>(), request, response);

    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    assertEquals("Test Sheet", wb.getSheet(0).getName());
    Sheet sheet = wb.getSheet("Test Sheet");
    Cell cell = sheet.getCell(2, 4);
    assertEquals("Test Value", cell.getContents());
  }
View Full Code Here
255
256
257
258
259
260
261
262
263
    excelView.setApplicationContext(webAppCtx);
    excelView.setUrl("template");
    excelView.render(new HashMap<String, Object>(), request, response);

    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template", cell.getContents());
  }
View Full Code Here
283
284
285
286
287
288
289
290
291
    excelView.setApplicationContext(webAppCtx);
    excelView.setUrl("template");
    excelView.render(new HashMap<String, Object>(), request, response);

    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template American English", cell.getContents());
  }
View Full Code Here
311
312
313
314
315
316
317
318
319
    excelView.setApplicationContext(webAppCtx);
    excelView.setUrl("template");
    excelView.render(new HashMap<String, Object>(), request, response);

    Workbook wb = Workbook.getWorkbook(new ByteArrayInputStream(response.getContentAsByteArray()));
    Sheet sheet = wb.getSheet("Sheet1");
    Cell cell = sheet.getCell(0, 0);
    assertEquals("Test Template auf Deutsch", cell.getContents());
  }
View Full Code Here
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
   * @throws IOException
   */
  public List read(int pBegin) throws BiffException, IOException{
    List list = new ArrayList();
    Workbook workbook = Workbook.getWorkbook(getIs());
    Sheet sheet = workbook.getSheet(0);
    int rows = sheet.getRows();
    for (int i = pBegin; i < rows; i++) {
      Dto rowDto = new BaseDto();
      Cell[] cells = sheet.getRow(i);
      for (int j = 0; j < cells.length; j++) {
        String key = getMetaData().trim().split(",")[j];
        if(G4Utils.isNotEmpty(key))
          rowDto.put(key, cells[j].getContents());
      }
View Full Code Here
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
   * @throws IOException
   */
  public List read(int pBegin, int pBack) throws BiffException, IOException{
    List list = new ArrayList();
    Workbook workbook = Workbook.getWorkbook(getIs());
    Sheet sheet = workbook.getSheet(0);
    int rows = sheet.getRows();
    for (int i = pBegin; i < rows - pBack; i++) {
      Dto rowDto = new BaseDto();
      Cell[] cells = sheet.getRow(i);
      String[] arrMeta = getMetaData().trim().split(",");
      for (int j = 0; j < arrMeta.length; j++) {
        String key = arrMeta[j];
        if(G4Utils.isNotEmpty(key))
          rowDto.put(key, cells[j].getContents());
View Full Code Here
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
    try {
      workbook = Workbook.getWorkbook(is);
    } catch (Exception e) {
      e.printStackTrace();
    }
    Sheet sheet = workbook.getSheet(0);
    if (G4Utils.isNotEmpty(sheet)) {
      int rows = sheet.getRows();
      for (int k = 0; k < rows; k++) {
        Cell[] cells = sheet.getRow(k);
        for (int j = 0; j < cells.length; j++) {
          String cellContent = cells[j].getContents().trim();
          if (!G4Utils.isEmpty(cellContent)) {
            if (cellContent.indexOf("$P") != -1 || cellContent.indexOf("$p") != -1) {
              parameterObjct.add(cells[j]);
View Full Code Here
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
    public void parseFile(InputStream inStream) {
        try {
            Workbook workbook = Workbook.getWorkbook( inStream );

            if ( _useFirstSheet ) {
                Sheet sheet = workbook.getSheet( 0 );
                processSheet( sheet,
                              _listeners.get( DEFAULT_RULESHEET_NAME ) );
            } else {
                for ( String sheetName : _listeners.keySet() ) {
                    Sheet sheet = workbook.getSheet( sheetName );
                    processSheet( sheet,
                                  _listeners.get( sheetName ) );

                }
            }
View Full Code Here
TOP

Related Classes of jxl.Sheet

  • baseconocimiento.ArchivoExcelBaseConocimiento
  • br.eti.kinoshita.selenium.DataDrivenSeleniumWebTest
  • center.app.common.ForXLSProcessor$ResultSet
  • com.nexirius.multimail.datamodel.ImportArrayModel
  • com.stimulus.archiva.extraction.ExcelExtractor
  • com.vsked.excel.ExcelOperate
  • importation.xls.XlsImportateur
  • it.pdor.webapp.contabilita.component.fileUpload.CaricamentoDiExcelMovimentiContabili
  • jxl.biff.RangeImpl
  • jxl.demo.CSV
    • Copyright © 2018 www.massapicom. 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.