Example usage for com.google.common.net MediaType MICROSOFT_EXCEL

Introduction

In this page you can find the example usage for com.google.common.net MediaType MICROSOFT_EXCEL.

Prototype

MediaType MICROSOFT_EXCEL

To view the source code for com.google.common.net MediaType MICROSOFT_EXCEL.

Click Source Link

Usage

From source file:rapture.dp.invocable.workflow.LoadFile.java

@Override
public String invoke(CallingContext ctx) {
    String archiveUriPrefix = "blob://archive/";
    DateTimeFormatter formatter = DateTimeFormatter.ofPattern("yyyyMMdd_HHmmss");
    String dateTime = LocalDateTime.now().format(formatter);
    // create a unique uri path to store file in and for other steps use
    Kernel.getDecision().setContextLiteral(ctx, getWorkerURI(), "folderName", dateTime);
    // get the context variable passed into workflow
    String absFilePath = Kernel.getDecision().getContextValue(ctx, getWorkerURI(), "filetoupload");
    log.info("Loading File:" + absFilePath);

    try {/*from  w w w  . j  a v  a  2 s .  c om*/
        File f = new File(absFilePath);
        byte[] data = FileUtils.readFileToByteArray(f);
        String uri = archiveUriPrefix + dateTime + "/" + f.getName();
        Kernel.getBlob().putBlob(ctx, uri, data, MediaType.MICROSOFT_EXCEL.toString());
        if (Kernel.getBlob().getBlob(ctx, uri) != null) {
            log.info("File written to " + uri + " with size " + Kernel.getBlob().getBlobSize(ctx, uri));
            Kernel.getDecision().setContextLiteral(ctx, getWorkerURI(), "blobUri", uri);
        } else {
            log.error("Problem writing file to " + uri);
            return "error";
        }
    } catch (IOException e) {
        log.error("Exception " + e.getMessage(), e);
        return "error";
    }

    return "ok";
}

---

From source file:org.opentestsystem.delivery.testreg.rest.TemplateDownloadController.java

private MediaType determineMediaType(String fileName) {
    switch (FileType.findByFilename(fileName)) {
    case XLS:/*from ww  w.  jav  a 2 s.  c  o  m*/
    case XLSX:
        return MediaType.MICROSOFT_EXCEL;
    case CSV:
        return MediaType.CSV_UTF_8;
    case TXT:
        return MediaType.TSV_UTF_8;
    }
    return null;
}

---

From source file:ru.runa.common.web.action.AbstractExportExcelAction.java

@Override
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request,
        HttpServletResponse response) {/* www .  ja  v a  2  s.  c o  m*/
    try {
        User user = getLoggedUser(request);
        String batchPresentationId = ((BatchPresentationForm) form).getBatchPresentationId();
        Profile profile = ProfileHttpSessionHelper.getProfile(request.getSession());
        BatchPresentation batchPresentation = profile.getActiveBatchPresentation(batchPresentationId);
        List<T> data = getData(user, batchPresentation);
        HSSFWorkbook workbook = new HSSFWorkbook();
        Sheet dataSheet = workbook.createSheet("data");
        buildHeader(request, workbook, batchPresentation);
        buildData(dataSheet, user, batchPresentation, data);
        response.setContentType(MediaType.MICROSOFT_EXCEL.toString());
        String encodedFileName = HTMLUtils.encodeFileName(request,
                getFileNamePrefix() + "-" + CalendarUtil.formatDateTime(Calendar.getInstance()) + ".xls");
        response.setHeader("Content-disposition", "attachment; filename=\"" + encodedFileName + "\"");
        response.setHeader("Content-Transfer-Encoding", "binary");
        workbook.write(response.getOutputStream());
        response.getOutputStream().flush();
    } catch (Exception e) {
        log.error("Unable to export excel", e);
    }
    return null;
}

---