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

java.lang.Object
  extended by it.eng.spago.dispatching.service.DefaultRequestContext
      extended by it.eng.spago.dispatching.service.DefaultHttpRequestContext
          extended by it.eng.spago.dispatching.action.AbstractHttpAction
              extended by it.eng.spagobi.utilities.service.AbstractBaseHttpAction
                  extended by it.eng.spagobi.utilities.engines.AbstractEngineAction
                      extended by it.eng.spagobi.engines.qbe.services.core.AbstractQbeEngineAction
                          extended by it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction
                              extended by it.eng.spagobi.engines.qbe.services.worksheet.ExecuteWorksheetQueryAction
                                  extended by it.eng.spagobi.engines.qbe.services.worksheet.ExportWorksheetAction
All Implemented Interfaces:
it.eng.spago.dispatching.action.ActionIFace, it.eng.spago.dispatching.service.HttpRequestContextIFace, it.eng.spago.dispatching.service.RequestContextIFace, it.eng.spago.dispatching.service.ServiceIFace, it.eng.spago.init.InitializerIFace, java.io.Serializable

public class ExportWorksheetAction
extends ExecuteWorksheetQueryAction

The Class ExecuteQueryAction.

See Also:
Serialized Form

Field Summary
static java.lang.String EXPORTED_SHEETS
           
static org.apache.log4j.Logger logger
          Logger component.
static java.lang.String MIME_TYPE
           
static java.lang.String OUTPUT_FORMAT
           
static java.lang.String OUTPUT_FORMAT_JPEG
           
static java.lang.String OUTPUT_FORMAT_PDF
           
static java.lang.String OUTPUT_FORMAT_PNG
           
static java.lang.String OUTPUT_FORMAT_SVG
           
static java.lang.String RESPONSE_TYPE
           
static java.lang.String RESPONSE_TYPE_ATTACHMENT
           
static java.lang.String RESPONSE_TYPE_INLINE
           
static java.lang.String SHEETS_NUM
           
static java.lang.String SVG
           
static java.lang.String WORKSHEETS
           
 
Fields inherited from class it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction
auditlogger, LIMIT, QUERY_ID, START
 
Fields inherited from class it.eng.spagobi.utilities.engines.AbstractEngineAction
PRIVATE_SCOPE, PUBLIC_SCOPE
 
Constructor Summary
ExportWorksheetAction()
           
 
Method Summary
 org.apache.poi.hssf.usermodel.HSSFWorkbook exportWorksheet(org.json.JSONObject worksheetJSON)
           
 int fillSheetContent(org.apache.poi.hssf.usermodel.HSSFWorkbook wb, org.apache.poi.hssf.usermodel.HSSFSheet sheet, org.json.JSONObject content, org.apache.poi.ss.usermodel.CreationHelper createHelper, WorkSheetXLSExporter exporter, org.apache.poi.hssf.usermodel.HSSFPatriarch patriarch)
           
 void service(it.eng.spago.base.SourceBean request, it.eng.spago.base.SourceBean response)
           
 
Methods inherited from class it.eng.spagobi.engines.qbe.services.worksheet.ExecuteWorksheetQueryAction
getQuery, getStatement
 
Methods inherited from class it.eng.spagobi.engines.qbe.services.core.ExecuteQueryAction
executeQuery, updatePromptableFiltersValue
 
Methods inherited from class it.eng.spagobi.engines.qbe.services.core.AbstractQbeEngineAction
getDataSource, getEngineInstance, getFilteredQuery, setDataSource
 
Methods inherited from class it.eng.spagobi.utilities.engines.AbstractEngineAction
getAuditServiceProxy, getConetxtManager, getEnv, getLocale, getSpagoBIHttpSessionContainer, getSpagoBISessionContainer, init, saveAnalysisState, setLocale
 
Methods inherited from class it.eng.spagobi.utilities.service.AbstractBaseHttpAction
delAttributeFromHttpSession, delAttributeFromSession, getAttribute, getAttributeAsBoolean, getAttributeAsBoolean, getAttributeAsCsvStringList, getAttributeAsInteger, getAttributeAsJSONArray, getAttributeAsJSONObject, getAttributeAsList, getAttributeAsString, getAttributeFromHttpSession, getAttributeFromHttpSessionAsBoolean, getAttributeFromHttpSessionAsBoolean, getAttributeFromHttpSessionAsString, getAttributeFromSession, getAttributeFromSessionAsBoolean, getAttributeFromSessionAsBoolean, getAttributeFromSessionAsString, getAttributesAsMap, getHttpSession, getSessionContainer, getSpagoBIRequestContainer, getSpagoBIResponseContainer, httpSessionContainsAttribute, requestContainsAttribute, requestContainsAttribute, sessionContainsAttribute, setAttribute, setAttributeInHttpSession, setAttributeInSession, setSpagoBIRequestContainer, setSpagoBIResponseContainer, tryToWriteBackToClient, writeBackToClient, writeBackToClient, writeBackToClient, writeBackToClient, writeBackToClient
 
Methods inherited from class it.eng.spago.dispatching.action.AbstractHttpAction
getActionMethod, getActionName, getConfig, setActionMethod, setActionName
 
Methods inherited from class it.eng.spago.dispatching.service.DefaultHttpRequestContext
freezeHttpResponse, getHttpRequest, getHttpResponse, getServletConfig, isHttpResponseFreezed, setRequestContext, unfreezeHttpResponse
 
Methods inherited from class it.eng.spago.dispatching.service.DefaultRequestContext
getErrorHandler, getRequestContainer, getResponseContainer, getServiceRequest, getServiceResponse
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 
Methods inherited from interface it.eng.spago.dispatching.service.RequestContextIFace
getErrorHandler, getRequestContainer, getResponseContainer, getServiceRequest, getServiceResponse
 

Field Detail

MIME_TYPE

public static final java.lang.String MIME_TYPE
See Also:
Constant Field Values

RESPONSE_TYPE

public static final java.lang.String RESPONSE_TYPE
See Also:
Constant Field Values

WORKSHEETS

public static final java.lang.String WORKSHEETS
See Also:
Constant Field Values

SHEETS_NUM

public static final java.lang.String SHEETS_NUM
See Also:
Constant Field Values

EXPORTED_SHEETS

public static final java.lang.String EXPORTED_SHEETS
See Also:
Constant Field Values

RESPONSE_TYPE_INLINE

public static final java.lang.String RESPONSE_TYPE_INLINE
See Also:
Constant Field Values

RESPONSE_TYPE_ATTACHMENT

public static final java.lang.String RESPONSE_TYPE_ATTACHMENT
See Also:
Constant Field Values

SVG

public static java.lang.String SVG

OUTPUT_FORMAT

public static java.lang.String OUTPUT_FORMAT

OUTPUT_FORMAT_PNG

public static java.lang.String OUTPUT_FORMAT_PNG

OUTPUT_FORMAT_JPEG

public static java.lang.String OUTPUT_FORMAT_JPEG

OUTPUT_FORMAT_PDF

public static java.lang.String OUTPUT_FORMAT_PDF

OUTPUT_FORMAT_SVG

public static java.lang.String OUTPUT_FORMAT_SVG

logger

public static transient org.apache.log4j.Logger logger
Logger component.

Constructor Detail

ExportWorksheetAction

public ExportWorksheetAction()
Method Detail

service

public void service(it.eng.spago.base.SourceBean request,
                    it.eng.spago.base.SourceBean response)
Specified by:
service in interface it.eng.spago.dispatching.service.ServiceIFace
Overrides:
service in class ExecuteQueryAction

exportWorksheet

public org.apache.poi.hssf.usermodel.HSSFWorkbook exportWorksheet(org.json.JSONObject worksheetJSON)
                                                           throws org.json.JSONException,
                                                                  java.io.IOException,
                                                                  it.eng.qbe.serializer.SerializationException
Throws:
org.json.JSONException
java.io.IOException
it.eng.qbe.serializer.SerializationException

fillSheetContent

public int fillSheetContent(org.apache.poi.hssf.usermodel.HSSFWorkbook wb,
                            org.apache.poi.hssf.usermodel.HSSFSheet sheet,
                            org.json.JSONObject content,
                            org.apache.poi.ss.usermodel.CreationHelper createHelper,
                            WorkSheetXLSExporter exporter,
                            org.apache.poi.hssf.usermodel.HSSFPatriarch patriarch)
                     throws java.io.IOException,
                            org.json.JSONException,
                            it.eng.qbe.serializer.SerializationException
Throws:
java.io.IOException
org.json.JSONException
it.eng.qbe.serializer.SerializationException