List of usage examples for org.apache.poi.xssf.usermodel XSSFWorkbook XSSFWorkbook
public XSSFWorkbook(PackagePart part) throws IOException
From source file:com.adobe.acs.commons.mcp.impl.processes.AssetFolderCreator.java
License:Apache License
/** * Parses the input Excel file and creates a list of AssetFolderDefinition objects to process. * * @param manager the action manager// ww w .j a v a2 s .c om * @throws IOException */ public void parseAssetFolderDefinitions(ActionManager manager) throws Exception { manager.withResolver(rr -> { final XSSFWorkbook workbook = new XSSFWorkbook(excelFile); // Close the InputStream to prevent resource leaks. excelFile.close(); final XSSFSheet sheet = workbook.getSheetAt(0); final Iterator<Row> rows = sheet.rowIterator(); while (rows.hasNext()) { parseAssetFolderRow(rows.next()); } log.info("Finished Parsing and collected [ {} ] asset folders for creation.", assetFolderDefinitions.size()); }); }
From source file:com.adobe.acs.commons.mcp.impl.processes.TagCreator.java
License:Apache License
/** * Parses the input Excel file and creates a list of TagDefinition objects to process. * * @param manager the action manager/* ww w . j a va2 s .c om*/ * @throws IOException */ @SuppressWarnings({ "squid:S3776", "squid:S1141" }) public void parseTags(ActionManager manager) throws Exception { manager.withResolver(rr -> { final XSSFWorkbook workbook = new XSSFWorkbook(excelFile); final XSSFSheet sheet = workbook.getSheetAt(0); final Iterator<Row> rows = sheet.rowIterator(); final String tagsRootPath = new TagRootResolver(rr).getTagsLocationPath(); if (tagsRootPath == null) { record(ReportRowSatus.FAILED_TO_PARSE, "Abandoning Tag parsing. Unable to determine AEM Tags root (/content/cq:tags vs /etc/tags). Please ensure the path exists and is accessible by the user running Tag Creator.", "N/A", "N/A"); return; } while (rows.hasNext()) { final Row row = rows.next(); final Iterator<Cell> cells = row.cellIterator(); int cellIndex = 0; // The previousTagId is reset on each new row. String previousTagId = null; while (cells.hasNext()) { final Cell cell = cells.next(); final String cellValue = StringUtils.trimToNull(cell.getStringCellValue()); if (StringUtils.isBlank(cellValue)) { // Hitting a blank cell means its the end of this row; don't process anything past this break; } // Generate a tag definition that will in turn be used to drive the tag creation TagDefinition tagDefinition = getTagDefinition(primary, cellIndex, cellValue, previousTagId, tagsRootPath); if (tagDefinition == null) { tagDefinition = getTagDefinition(fallback, cellIndex, cellValue, previousTagId, tagsRootPath); } if (tagDefinition == null) { log.warn("Could not find a Tag Data Converter that accepts value [ {} ]; skipping...", cellValue); // Record parse failure record(ReportRowSatus.FAILED_TO_PARSE, cellValue, "", ""); // Break to next Row break; } else { /* Prepare for next Cell */ cellIndex++; previousTagId = tagDefinition.getId(); if (tagDefinitions.get(tagDefinition.getId()) == null) { tagDefinitions.put(tagDefinition.getId(), tagDefinition); } } } } log.info("Finished Parsing and collected [ {} ] tags for import.", tagDefinitions.size()); }); }
From source file:com.adobe.acs.commons.mcp.util.Spreadsheet.java
License:Apache License
/** * Parse out the input file synchronously for easier unit test validation * * @return List of files that will be imported, including any renditions * @throws IOException if the file couldn't be read *//*from w ww .j a v a 2 s. c om*/ private void parseInputFile(InputStream file) throws IOException { XSSFWorkbook workbook = new XSSFWorkbook(file); final XSSFSheet sheet = workbook.getSheetAt(0); rowCount = sheet.getLastRowNum(); final Iterator<Row> rows = sheet.rowIterator(); headerRow = readRow(rows.next()).stream().map(this::convertHeaderName).collect(Collectors.toList()); Iterable<Row> remainingRows = () -> rows; dataRows = StreamSupport.stream(remainingRows.spliterator(), false).map(this::buildRow) .filter(Optional::isPresent).map(Optional::get).collect(Collectors.toList()); }
From source file:com.adobe.ags.curly.controller.DataImporterController.java
License:Apache License
private void openExcel(File file) throws IOException, InvalidFormatException { openWorkbook(new XSSFWorkbook(file)); }
From source file:com.amitycoin.enterprisetool.diagramInputServlet.java
@Override
@SuppressWarnings({ "null", "ValueOfIncrementOrDecrementUsed", "UnusedAssignment" })
protected void doPost(HttpServletRequest request, HttpServletResponse response)
throws ServletException, IOException {
String filePath;/*from ww w . j a v a 2 s . c o m*/
String docids;
String userid;
String a[][];
a = new String[200][200];
// database connection settings
String dbURL = "jdbc:mysql://localhost:3306/enterprisedb";
String dbUser = "root";
String dbPass = "sandy";
@SuppressWarnings("UnusedAssignment")
Connection conn = null; // connection to the database
userid = (String) request.getAttribute("uidM");
String fname = (String) request.getAttribute("fnameM");
int docid = (Integer) request.getAttribute("docidM");
docids = "" + docid;
String pathToWeb;
pathToWeb = getServletContext().getRealPath(File.separator);
System.out.println("pathtoweb:\t" + pathToWeb);
filePath = pathToWeb + "readFiles\\";
filePath = filePath + docids + userid + fname; //+.xls
File myFile = new File(filePath);
//boolean newExcel;
//boolean oldExcel;
String ext = FilenameUtils.getExtension(filePath);
System.out.println("Extension: " + ext);
FileInputStream fis = new FileInputStream(myFile);
Workbook wb = null;
if ("xls".equals(ext)) {
// Finds the workbook instance for the file
wb = new HSSFWorkbook(fis);
} else if ("xlsx".equals(ext)) {
wb = new XSSFWorkbook(fis);
}
@SuppressWarnings("null")
Sheet mySheet;
mySheet = wb.getSheetAt(0);
// Get iterator to all the rows in current sheet
Iterator<Row> rowIterator = mySheet.iterator();
@SuppressWarnings("UnusedAssignment")
int rowct = 0, colct = 0, colit = 0, ci = 0, ri = 0;
// Traversing over each row of XLSX file
while (rowIterator.hasNext()) {
ri++;
System.out.println("\nRi:\t" + ri);
//Iterate over Rows
Row row = rowIterator.next();
if (1 == rowct) {
colct = colit;
}
// For each row, iterate through each columns
Iterator<Cell> cellIterator = row.cellIterator();
ci = 0;
while (cellIterator.hasNext()) {
ci++;
System.out.println("\nCi:\t" + ci);
//Iterate over Columns
Cell cell = cellIterator.next();
switch (cell.getCellType()) {
case Cell.CELL_TYPE_STRING:
System.out.print(cell.getStringCellValue() + "\t");
a[ri][ci] = cell.getStringCellValue();
break;
case Cell.CELL_TYPE_NUMERIC:
System.out.print(cell.getNumericCellValue() + "\t");
double temp = cell.getNumericCellValue();
String dblValue = "" + temp;
a[ri][ci] = dblValue;
break;
case Cell.CELL_TYPE_BOOLEAN:
System.out.print(cell.getBooleanCellValue() + "\t");
String tmp = "" + cell.getBooleanCellValue();
a[ri][ci] = tmp;
break;
default:
}
colit++;
}
//rowit++;
rowct++;
//increase row count
}
System.out.println("Row Count:\t" + rowct);
System.out.println("Column Count:\t" + colct);
for (int i = 1; i <= rowct; i++) {
for (int j = 1; j <= colct; j++) {
System.out.println("a[" + i + "][" + j + "]=" + a[i][j] + "\n");
}
}
try {
DriverManager.registerDriver(new com.mysql.jdbc.Driver());
conn = DriverManager.getConnection(dbURL, dbUser, dbPass);
String append = "?, ?";
String quest = ", ?";
for (int j = 1; j <= colct; j++) {
append += quest;
}
String crsql;
String cappend = "`uid`,`doc_id`";
for (int j = 1; j <= colct; j++) {
cappend = cappend + ",`" + j + "`";
}
crsql = "CREATE TABLE IF NOT EXISTS `data" + userid + docid + "` (\n"
+ "`row_id` INT(11) NOT NULL AUTO_INCREMENT,\n" + "`uid` VARCHAR(50) NOT NULL,\n"
+ "`doc_id` INT(11) NOT NULL";
System.out.println(crsql);
for (int j = 1; j <= colct; j++) {
System.out.println("j:\t" + (j));
crsql = crsql + ",\n`" + (j) + "` VARCHAR(50)";
}
crsql += ",\nPRIMARY KEY (`row_id`)\n)";
System.out.println(crsql);
PreparedStatement cstmt = conn.prepareStatement(crsql);
int c = cstmt.executeUpdate();
String sql = "INSERT INTO data" + userid + docid + "(" + cappend + ")" + " values (" + append + ")";
System.out.println("Append=\t" + append);
PreparedStatement statement = conn.prepareStatement(sql);
statement.setString(1, userid);
statement.setInt(2, docid);
for (int i = 1; i <= rowct; i++) {
for (int j = 1; j <= (colct); j++) {
statement.setString(j + 2, a[i][j]);
System.out.println("j=" + (j) + "\ta[" + i + "][" + (j) + "]=" + a[i][j] + "\n");
}
System.out.println("\n");
System.out.println("\nstatement:\t" + statement);
int res = statement.executeUpdate();
}
} catch (SQLException ex) {
Logger.getLogger(diagramInputServlet.class.getName()).log(Level.SEVERE, null, ex);
}
for (int i = 1; i <= rowct; i++) {
for (int j = 1; j <= colct; j++) {
System.out.println("a[" + i + "][" + j + "]=" + a[i][j] + "\n");
}
}
System.out.println("Rowct:\t" + rowct + "\nColct:\t" + colct);
@SuppressWarnings("UseOfObsoleteCollectionType")
Hashtable<String, Object> style = new Hashtable<String, Object>();
style.put(mxConstants.STYLE_FILLCOLOR, mxUtils.getHexColorString(Color.WHITE));
style.put(mxConstants.STYLE_STROKEWIDTH, 1.5);
style.put(mxConstants.STYLE_STROKECOLOR, mxUtils.getHexColorString(new Color(0, 0, 170)));
style.put(mxConstants.STYLE_SHAPE, mxConstants.SHAPE_ELLIPSE);
style.put(mxConstants.STYLE_PERIMETER, mxConstants.PERIMETER_ELLIPSE);
graph = new mxGraph();
mxStylesheet stylesheet = graph.getStylesheet();
stylesheet.putCellStyle("process", createProcessStyle());
stylesheet.putCellStyle("object", createObjectStyle());
stylesheet.putCellStyle("state", createStateStyle());
stylesheet.putCellStyle("agent", createAgentLinkStyle());
fr = new JFrame("Enterprise Architecture Diagram");
fr.setSize(2000, 2000);
graph.setMinimumGraphSize(new mxRectangle(0, 0, 1000, 1500));
graph.setMaximumGraphBounds(new mxRectangle(0, 0, 2000, 2000));
graph.setMinimumGraphSize(new mxRectangle(0, 0, 1000, 1000));
double rech1 = 200;
double rech2 = 200;
double rech3 = 170;
double rech3e = 180;
double rech4 = 120;
Object defaultParent = graph.getDefaultParent();
graph.setConstrainChildren(true);
graph.setExtendParents(true);
graph.setExtendParentsOnAdd(true);
graph.setDefaultOverlap(0);
graph.setCellsMovable(true); // Moving cells in the graph. Note that an edge is also a cell.
graph.setCellsEditable(true);
graph.setCellsResizable(true); // Inhibit cell re-sizing.
graph.getModel().beginUpdate();
Object[] obj = new Object[100];
int k = 1;
for (int i = 2; i <= rowct; i++) {
for (int j = 1; j <= 2; j++) {
obj[k] = a[i][j];
k++;
}
}
//print debug info
for (int l = 1; l <= (rowct * 2) - 2; l++) {
System.out.println("obj[" + l + "]:\t" + obj[l]);
}
List<Object> list = new ArrayList<Object>();
for (Object val : obj) {
if (!list.contains(val)) {
list.add(val);
}
}
list.remove(null);
list.toArray(new Object[0]);
System.out.println("list:" + list);
Object[] array = new Object[list.size()];
list.toArray(array); // fill the array
System.out.println("Array:\t" + Arrays.toString(array));
Object[] gArray = new Object[array.length];
String[] sArray = new String[array.length];
for (int i = 0; i < array.length; i++) {
sArray[i] = array[i].toString();
if (sArray[i].contains("Database") || sArray[i].contains("Server") || sArray[i].contains("DATABASE")
|| sArray[i].contains("SERVER") || sArray[i].contains("DB")) {
System.out.println("Object type");
gArray[i] = graph.insertVertex(defaultParent, null, sArray[i], rech1, rech2, rech3, rech4,
"object");
} else {
System.out.println("Process type");
gArray[i] = graph.insertVertex(defaultParent, null, sArray[i], rech1, rech2, rech3e, rech4,
"process");
}
rech1 += 100;
rech2 += 100;
}
for (int i = 2; i <= rowct; i++) {
if (a[i][3].equals("Two Way") || a[i][3].equals("TWO WAY") || a[i][3].equals("TwoWay")
|| a[i][3].equals("TWOWAY") || a[i][3].equals("2 Way") || a[i][3].equals("Two way")) {
System.out.println("Double Edges");
int l1 = 0, l2 = 0;
for (int l = 1; l < gArray.length; l++) {
System.out.println("gArray.toString=\t" + sArray[l]);
System.out.println("gArray.length=\t" + sArray.length);
if (sArray[l].equals(a[i][1])) {
l1 = l;
System.out.println("l2:\t" + l1);
}
if (sArray[l].equals(a[i][2])) {
l2 = l;
System.out.println("l2:\t" + l2);
}
}
graph.insertEdge(defaultParent, null, a[i][4], gArray[l1], gArray[l2], "agent");
graph.insertEdge(defaultParent, null, a[i][4], gArray[l2], gArray[l1], "agent");
} else {
System.out.println("Single Edges");
int l1 = 0, l2 = 0;
for (int l = 1; l < gArray.length; l++) {
System.out.println("gArray.toString=\t" + sArray[l]);
System.out.println("gArray.length=\t" + sArray.length);
if (sArray[l].equals(a[i][1])) {
l1 = l;
System.out.println("l2:\t" + l2);
}
if (sArray[l].equals(a[i][2])) {
l2 = l;
System.out.println("l2:\t" + l2);
}
}
graph.insertEdge(defaultParent, null, a[i][4], gArray[l1], gArray[l2], "agent");
}
}
graph.setEnabled(true);
graph.setAutoSizeCells(true);
graph.getModel().endUpdate();
graphComponent = new mxGraphComponent(graph);
mxFastOrganicLayout layout = new mxFastOrganicLayout(graph);
// define layout
//set all properties
layout.setMinDistanceLimit(1);
//layout.setInitialTemp(5);
//layout.setInitialTemp(10);
//layout.setForceConstant(10);
//layout.setDisableEdgeStyle(true);
//layout graph
//layout.execute(graph.getDefaultParent());
// layout using morphing
String fileWPath;
graph.getModel().beginUpdate();
try {
layout.execute(graph.getDefaultParent());
} finally {
mxMorphing morph = new mxMorphing(graphComponent, 20, 1.2, 20);
morph.addListener(mxEvent.DONE, new mxIEventListener() {
@Override
public void invoke(Object arg0, mxEventObject arg1) {
graph.getModel().endUpdate();
// fitViewport();
}
});
BufferedImage image;
image = mxCellRenderer.createBufferedImage(graph, null, 2, Color.WHITE, true, null);
Document d = mxCellRenderer.createVmlDocument(graph, null, 1, Color.WHITE, null);
pathToWeb = getServletContext().getRealPath(File.separator);
System.out.println("pathtoweb:\t" + pathToWeb);
fileWPath = pathToWeb + "genImg\\" + userid + docid + ".png";
System.out.println("filewpath:\t" + fileWPath);
//System.out.println(pathToWeb + userid + docid + ".svg");
ImageIO.write(image, "PNG", new File(fileWPath));
XMLEncoder encoder = new XMLEncoder(new BufferedOutputStream(
new FileOutputStream(new File(pathToWeb + "genXML\\" + userid + docid + ".xml"))));
encoder.writeObject(graph);
encoder.close();
morph.startAnimation();
}
graphComponent.setConnectable(false);
fr.getRootPane().setBorder(BorderFactory.createMatteBorder(4, 4, 4, 4, Color.WHITE));
// Inhibit edge creation in the graph.
fr.getContentPane().add(graphComponent);
//fr.setVisible(true);
request.setAttribute("docidM", docid);
request.setAttribute("useridM", userid);
request.setAttribute("colCountM", colct);
request.setAttribute("rowCountM", rowct);
request.setAttribute("fileLinkM", fileWPath);
request.setAttribute("pathToWebM", pathToWeb);
System.out.println("Iteration Complete");
getServletContext().getRequestDispatcher("/success.jsp").forward(request, response);
}
From source file:com.anritsu.mcrepositorymanager.packageinfoparser.RSSParser.java
public void parseRSS() { try {//from w ww .j a v a 2s . c om FileInputStream file = new FileInputStream(new File(this.filePath)); //Create Workbook instance holding reference to .xlsx file XSSFWorkbook workbook = new XSSFWorkbook(file); //Get package list sheet from the workbook String sheetName = "MC " + mcVersion; XSSFSheet sheet = workbook.getSheet(sheetName); //Iterate through each rows one by one Iterator<Row> rowIterator = sheet.iterator(); while (rowIterator.hasNext()) { Row row = rowIterator.next(); if (row.getRowNum() < 3) { continue; } McPackage p = new McPackage(); p.setMcVersion(mcVersion); p.setName(row.getCell(2).getStringCellValue()); HashSet<String> downloadLinks = new HashSet<>(); try { String link = row.getCell(7).getHyperlink().getAddress(); downloadLinks.add(link); int urlIndex = link.split("/").length; String fileName = link.split("/")[urlIndex - 1]; p.setFileName(fileName); } catch (NullPointerException exp) { exp.printStackTrace(); } finally { p.setDownloadLinks(downloadLinks); } p.setPackageVersion(row.getCell(3).getStringCellValue()); p.setAvailability(row.getCell(4).getStringCellValue()); availability.add(row.getCell(4).getStringCellValue()); // Set customers list ArrayList<String> cusList = new ArrayList<>(); String[] customerCell = row.getCell(5).getStringCellValue().split(","); for (int i = 0; i < customerCell.length; i++) { customers.add(customerCell[i]); cusList = new ArrayList<>(Arrays.asList(customerCell)); } //System.out.println("Parsing line " + row.getRowNum()); LOGGER.log(Level.INFO, "Parsing " + this.filePath + "/" + row.getRowNum()); p.setCustomerList(new HashSet<>(cusList)); packageList.add(p); } file.close(); } catch (Exception e) { e.printStackTrace(); } }
From source file:com.anritsu.mcrepositorymanager.utils.GenerateRSS.java
public String getRSS() { FileInputStream file = null;/*from ww w . j a v a2 s .co m*/ String rssFileName = rssTemplateFileName.replaceAll("template", mcVersion); try { file = new FileInputStream( new File(Configuration.getInstance().getRssTemplatePath() + rssTemplateFileName)); XSSFWorkbook workbook = new XSSFWorkbook(file); workbook.setSheetName(workbook.getSheetIndex("MC X.X.X"), "MC " + mcVersion); XSSFSheet sheet = workbook.getSheet("MC " + mcVersion); CreationHelper createHelper = workbook.getCreationHelper(); Cell cell = null; // Update the sheet title cell = sheet.getRow(0).getCell(0); cell.setCellValue(cell.getStringCellValue().replaceAll("template", mcVersion)); XSSFCellStyle cellStyle = workbook.createCellStyle(); cellStyle.setBorderBottom(XSSFCellStyle.BORDER_THIN); cellStyle.setBorderTop(XSSFCellStyle.BORDER_THIN); cellStyle.setBorderRight(XSSFCellStyle.BORDER_THIN); cellStyle.setBorderLeft(XSSFCellStyle.BORDER_THIN); XSSFCellStyle hlinkstyle = workbook.createCellStyle(); XSSFFont hlinkfont = workbook.createFont(); hlinkfont.setUnderline(XSSFFont.U_SINGLE); hlinkfont.setColor(HSSFColor.BLUE.index); hlinkstyle.setFont(hlinkfont); hlinkstyle.setBorderBottom(XSSFCellStyle.BORDER_THIN); hlinkstyle.setBorderTop(XSSFCellStyle.BORDER_THIN); hlinkstyle.setBorderRight(XSSFCellStyle.BORDER_THIN); hlinkstyle.setBorderLeft(XSSFCellStyle.BORDER_THIN); XSSFCellStyle dateCellStyle = workbook.createCellStyle(); dateCellStyle.setDataFormat(createHelper.createDataFormat().getFormat("dd-MMMM-yyyy")); dateCellStyle.setBorderBottom(XSSFCellStyle.BORDER_THIN); dateCellStyle.setBorderTop(XSSFCellStyle.BORDER_THIN); dateCellStyle.setBorderRight(XSSFCellStyle.BORDER_THIN); dateCellStyle.setBorderLeft(XSSFCellStyle.BORDER_THIN); // Populate the table int rowCount = 1; for (RecommendedMcPackage rmcp : sortedMcPackages) { if (rmcp.getRecommendedVersion() != null && rmcp.isShowInTable()) { Row row = sheet.createRow(rowCount + 1); rowCount++; cell = row.createCell(0); cell.setCellValue(rmcp.getTier().replaceAll("Anritsu/MasterClaw/", "")); cell.setCellStyle(cellStyle); cell = row.createCell(1); cell.setCellValue(rmcp.getGroup()); cell.setCellStyle(cellStyle); cell = row.createCell(2); cell.setCellValue(rmcp.getPackageName()); UrlValidator defaultValidator = new UrlValidator(UrlValidator.ALLOW_LOCAL_URLS); if (rmcp.getRecommendedVersion().getReleaseNote() != null && defaultValidator.isValid(rmcp.getRecommendedVersion().getReleaseNote())) { XSSFHyperlink releaseNotelink = (XSSFHyperlink) createHelper .createHyperlink(Hyperlink.LINK_URL); releaseNotelink.setAddress(rmcp.getRecommendedVersion().getReleaseNote()); //System.out.println("Inside(if) RN: " + rmcp.getRecommendedVersion().getReleaseNote() + " Valid: " + defaultValidator.isValid(rmcp.getRecommendedVersion().getReleaseNote())); cell.setHyperlink(releaseNotelink); } cell.setCellStyle(hlinkstyle); cell = row.createCell(3); cell.setCellValue(rmcp.getRecommendedVersion().getPackageVersion()); cell.setCellStyle(cellStyle); cell = row.createCell(4); cell.setCellValue(rmcp.getAvailability()); cell.setCellStyle(cellStyle); cell = row.createCell(5); String customers = Arrays.asList(rmcp.getRecommendedVersion().getCustomerList().toArray()) .toString(); if (customers.equalsIgnoreCase("[All]")) { customers = ""; } cell.setCellValue(customers); cell.setCellStyle(cellStyle); cell = row.createCell(6); cell.setCellValue(rmcp.getRecommendedVersion().getRisk()); cell.setCellStyle(cellStyle); cell = row.createCell(7); cell.setCellValue(rmcp.getPackageName()); XSSFHyperlink link = (XSSFHyperlink) createHelper.createHyperlink(Hyperlink.LINK_URL); link.setAddress(rmcp.getRecommendedVersion().getDownloadLinks().iterator().next()); cell.setHyperlink((XSSFHyperlink) link); cell.setCellStyle(hlinkstyle); cell = row.createCell(8); cell.setCellValue((rmcp.getRecommendedVersion() != null && rmcp.getRecommendedVersion().isLessRecommended()) ? "#" : ""); cell.setCellStyle(cellStyle); cell = row.createCell(9); cell.setCellValue(rmcp.getRecommendedVersion().getNotes()); cell.setCellStyle(cellStyle); StringBuilder newFeatures = new StringBuilder(); for (MCPackageActivities mcpa : rmcp.getRecommendedVersion().getActivities()) { if (!mcpa.getActivityType().equalsIgnoreCase("epr")) { newFeatures.append(mcpa.getActivityType() + " " + mcpa.getActivityId() + "; "); } } cell = row.createCell(10); cell.setCellValue(newFeatures.toString()); cell.setCellStyle(cellStyle); cell = row.createCell(11); cell.setCellValue(rmcp.getRecommendedVersion().getReleaseDate()); cell.setCellStyle(dateCellStyle); } sheet.autoSizeColumn(0); sheet.autoSizeColumn(1); sheet.autoSizeColumn(2); sheet.autoSizeColumn(3); sheet.autoSizeColumn(4); sheet.autoSizeColumn(6); sheet.autoSizeColumn(7); sheet.autoSizeColumn(8); sheet.autoSizeColumn(11); } FileOutputStream outFile = new FileOutputStream( new File(Configuration.getInstance().getRssTemplatePath() + rssFileName)); workbook.write(outFile); outFile.close(); return Configuration.getInstance().getRssTemplatePath() + rssFileName; } catch (FileNotFoundException ex) { Logger.getLogger(GenerateRSS.class.getName()).log(Level.SEVERE, null, ex); } catch (IOException ex) { Logger.getLogger(GenerateRSS.class.getName()).log(Level.SEVERE, null, ex); } finally { try { file.close(); } catch (IOException ex) { Logger.getLogger(GenerateRSS.class.getName()).log(Level.SEVERE, null, ex); } } return ""; }
From source file:com.appdynamics.jrbronet.projectplan.ExcelManager.java
public ExcelManager(String fileName) { excelFile = new File(fileName); try {/* w w w . j av a 2s . com*/ fsIP = new FileInputStream(this.excelFile); book = new XSSFWorkbook(fsIP); //Access the workbook } catch (Exception e) { e.printStackTrace(); } //Read the spreadsheet that needs to be updated }
From source file:com.arg.arsoft.siantluis.web.controllers.ClaimController.java
@RequestMapping(value = "/uploadFile", method = RequestMethod.POST) @Transactional// w ww .ja v a 2s . c o m public @ResponseBody String upload(MultipartFile file) throws Exception { if (file != null) { System.out.println(file.getOriginalFilename()); Workbook workbook = new XSSFWorkbook(file.getInputStream()); Sheet sheet = workbook.getSheetAt(0); for (int index = 1; index < sheet.getPhysicalNumberOfRows(); index++) { Row row = sheet.getRow(index); String code = row.getCell(0).getStringCellValue(); ClaimUpload entity = cuRepository.findByCode(code); if (entity == null) { entity = new ClaimUpload(); entity.setId(0); entity.setCode(code); } System.out.print(entity.getId()); entity.setDesc(row.getCell(1).getStringCellValue()); entity.setClaimDate(row.getCell(2).getStringCellValue()); entity.setClaimTime(row.getCell(3).getStringCellValue()); entity.setClaimLocation(row.getCell(4).getStringCellValue()); entity.setClaimReason(row.getCell(5).getStringCellValue()); cuRepository.save(entity); } } return "Success"; }
From source file:com.asakusafw.testdata.generator.excel.ExcelTesterRoot.java
License:Apache License
/** * Opens the workbook./*from w w w . j av a 2 s . c o m*/ * @param file the target workbook * @return the opened workbook * @throws IOException if failed */ protected Workbook openWorkbook(File file) throws IOException { try (InputStream in = new FileInputStream(file)) { if (file.getName().endsWith(".xls")) { return new HSSFWorkbook(in); } else if (file.getName().endsWith(".xlsx")) { return new XSSFWorkbook(in); } else { throw new IOException(file.getPath()); } } }