Examples of it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSExporter

Package it.eng.spagobi.engines.qbe.crosstable.exporter

Examples of it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSExporter

it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSExporter
Exports the crosstab data (formatted as a JSON object in input) into a XLS file. The JSON object should have this structure (a node is {node_key:"Text", node_childs:[...]}): columns: {...} contains tree node structure of the columns' headers rows: {...} contains tree node structure of the rows' headers data: [[...], [...], ...] 2-dimensional matrix containing crosstab data @author Davide Zerbetto (davide.zerbetto@eng.it)

      logger.debug(CROSSTAB + ": " + crosstabJSON);
      
      writeBackResponseInline = RESPONSE_TYPE_INLINE.equalsIgnoreCase(responseType);
      
      if( "application/vnd.ms-excel".equalsIgnoreCase( mimeType ) ) {
        CrosstabXLSExporter exporter = new CrosstabXLSExporter();
        Workbook wb = exporter.export(crosstabJSON);
        
        exportFile = File.createTempFile("crosstab", ".xls");
        FileOutputStream stream = new FileOutputStream(exportFile);
        wb.write(stream);
        stream.flush();

View Full Code Here

          fillSheetData(sheet, wb, createHelper, cellTypes, 5, 4);      
        }
  }
  
  public CellStyle[] fillSheetHeader(Sheet sheet,Workbook wb, CreationHelper createHelper, int beginRowHeaderData, int beginColumnHeaderData) {  
    CrosstabXLSExporter xlsExp = new CrosstabXLSExporter();
    CellStyle hCellStyle = xlsExp.buildHeaderCellStyle(sheet);
    IDataStoreMetaData d = dataStore.getMetaData();  
      int colnum = d.getFieldCount();
      Row row = sheet.getRow(beginRowHeaderData);
      CellStyle[] cellTypes = new CellStyle[colnum]; // array for numbers patterns storage
      for(int j = 0; j < colnum; j++){

View Full Code Here

      }
      return cellTypes;
  }
  
  public void fillSheetData(Sheet sheet,Workbook wb, CreationHelper createHelper,CellStyle[] cellTypes, int beginRowData, int beginColumnData) {  
    CrosstabXLSExporter xlsExp = new CrosstabXLSExporter();
    CellStyle dCellStyle = xlsExp.buildDataCellStyle(sheet);
  
    Iterator it = dataStore.iterator();
      int rownum = beginRowData;
      short formatIndexInt = HSSFDataFormat.getBuiltinFormat("#,##0");
      CellStyle cellStyleInt = wb.createCellStyle(); // cellStyleInt is the default cell style for integers

View Full Code Here

        
      } else if (sheetType.equalsIgnoreCase(WorkSheetXLSExporter.CROSSTAB)) {
        
        String crosstab = content.getString(WorkSheetXLSExporter.CROSSTAB);
        JSONObject crosstabJSON = new JSONObject(crosstab);  
        CrosstabXLSExporter expCr = new CrosstabXLSExporter();
        endRowNum = expCr.fillAlreadyCreatedSheet(sheet, crosstabJSON, createHelper);
        
      } else if (sheetType.equalsIgnoreCase(WorkSheetXLSExporter.TABLE)) {


        IDataStore dataStore =  getTableDataStore(sheetJ);
        long recCount = dataStore.getRecordsCount();

View Full Code Here

TOP

Related Classes of it.eng.spagobi.engines.qbe.crosstable.exporter.CrosstabXLSExporter

it.eng.spagobi.engines.qbe.query.Exporter

it.eng.spagobi.engines.qbe.services.crosstab.ExportCrosstabAction

it.eng.spagobi.engines.qbe.services.worksheet.ExportWorksheetAction

org.apache.poi.hssf.usermodel.HSSFWorkbook

org.apache.poi.ss.usermodel.Cell

org.apache.poi.ss.usermodel.CellStyle

org.apache.poi.ss.usermodel.CreationHelper

org.apache.poi.ss.usermodel.Font

org.apache.poi.ss.usermodel.Row

org.apache.poi.ss.usermodel.Sheet

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.