/** * Create an instance of {@link Workbook } * */ public Workbook createWorkbook() { return new Workbook(); }
/** * Create an instance of {@link Workbook } * */ public Workbook createWorkbook() { return new Workbook(); }
Workbook wb = new Workbook() { // Some implementation }
Workbook wb = new Workbook(); Worksheet worksheet = wb.getWorksheets().get(0); Cells cells = worksheet.getCells(); ArrayList<String> arr = new ArrayList<String>(); arr.add("one"); arr.add("two"); arr.add("three"); //Importing the contents of ArrayList vertically (A1:A3). cells.importArrayList(arr,0,0,true); //Importing the contents of ArrayList horizontally (A10:C10). cells.importArrayList(arr,9,0,false);
ArrayList<String> list = new ArrayList<>(); Workbook workbook = new Workbook("spreadsheet.xlsx"); Worksheet worksheet = workbook.getWorksheets().get("Sheet1"); for (Object o: worksheet.getCells().getRows()) { Cell cell = ((Row) o).getCellByIndex(0); list.add(cell.getStringValueWithoutFormat()); }
//Open the first excel file. Workbook SourceBook1 = new Workbook("F:\\Downloads\\charts.xlsx"); //Define the second source book. //Open the second excel file. Workbook SourceBook2 = new Workbook("F:\\Downloads\\picture.xlsx"); //Combining the two workbooks SourceBook1.combine(SourceBook2); //Save the target book file. SourceBook1.save("F:\\Downloads\\combined.xlsx");
//Specify the file path String filePath = myDir + "Book1.xlsx"; //Specify the HTML Saving Options HtmlSaveOptions save = new HtmlSaveOptions(SaveFormat.HTML); //Instantiate a workbook and open the template XLSX file Workbook book = new Workbook(filePath); //Save the HTML file book.save(myDir + "output.html", save);
//Instantiate a new workbook with excel file path Workbook workbook = new Workbook("F:\\FileTemp\\Book1.xls"); //Save the document in Pdf format workbook.save("F:\\FileTemp\\MyPdfFile.pdf", FileFormatType.PDF);
//Instantiate a new workbook with excel file path Workbook workbook = new Workbook("F:\\FileTemp\\Book1.xls"); //Save the document in Pdf format workbook.save("F:\\FileTemp\\MyPdfFile.pdf", FileFormatType.PDF);
//Instantiate a new workbook with excel file path Workbook workbook = new Workbook("F:\\FileTemp\\Book1.xls"); //Save the document in Pdf format workbook.save("F:\\FileTemp\\MyPdfFile.pdf", FileFormatType.PDF);
Workbook workerBook = new Workbook();
Workbook workerBook = new Workbook(); Worksheet worksheet = workerBook.getWorksheets().get(0); //Display word "Date" in cell B4 Cell cellB4 = worksheet.getCells().get("B4"); cellB4.putValue("Date"); //Display word "Time" in cell C4 Cell cellC4 = worksheet.getCells().get("C4"); cellC4.putValue("Time"); //Save the workbook in xlsx format workerBook.save("output.xlsx", SaveFormat.XLSX);
//Suppose your person id is 7, so your data will be inserted in row 7 int personId = 7; //Suppose that person's data is 5, then it will be inserted in column E (A, B, C, D, E, F, G...) int personData = 5; Workbook workbook = new Workbook(); Worksheet worksheet = workbook.getWorksheets().get(0); String cellName = CellsHelper.cellIndexToName(personId - 1, personData - 1); worksheet.getCells().get(cellName).putValue(personData); workbook.save("output.xlsx", SaveFormat.XLSX);
int headerRows = 3; Workbook workerBook = new Workbook(); Worksheet workSheet = workerBook.getWorksheets().get(0); //style.setTextWrapped(true); Cell workSheetCell = workSheet.getCells().get("A1"); workSheet.getCells().merge(3, 0, headerRows, 1); workSheet.getCells().merge(3, 1, headerRows, 1); workSheet.getCells().merge(3, 2, headerRows, 1); // workSheet.getCells().get("C4").putValue("Time"); workSheet.getCells().get("A4").putValue("Respondent"); workSheet.getCells().get("B4").putValue("Date"); workSheet.getCells().get("C4").putValue("Time"); workerBook.save(DIR + "SettingData.xltx", SaveFormat.XLTX);
Workbook workbook = new Workbook(); Cells cells = workbook.getWorksheets().get(0).getCells();
int headerRows = 3; Workbook workerBook = new Workbook(); Worksheet workSheet = workerBook.getWorksheets().get(0); //style.setTextWrapped(true); Cell workSheetCell = workSheet.getCells().get("A1"); workSheet.getCells().merge(3, 0, headerRows, 1); workSheet.getCells().merge(3, 1, headerRows, 1); workSheet.getCells().merge(3, 2, headerRows, 1); // workSheet.getCells().get("C4").putValue("Time"); workSheet.getCells().get("A4").putValue("Respondent"); workSheet.getCells().get("B4").putValue("Date"); workSheet.getCells().get("C4").putValue("Time"); workerBook.save("SettingData.xlsx"); workerBook.save("myoutputSettingData.xml", SaveFormat.SPREADSHEET_ML);
//Create workbook object Workbook wb = new Workbook("source.xlsx"); //This is how to save Workbook to XLS format MemoryStream ms1 = new MemoryStream(); wb.Save(ms1, SaveFormat.Excel97To2003); //Just to check if memory stream is good and contains XLS bytes byte[] b1 = ms1.ToArray(); File.WriteAllBytes("output.xls", b1); //This is how to save Workbook to XLSX format MemoryStream ms2 = new MemoryStream(); wb.Save(ms2, SaveFormat.Xlsx); //Just to check if memory stream is good and contains XLSX bytes byte[] b2 = ms2.ToArray(); File.WriteAllBytes("output.xlsx", b2);
Workbook workbook = new Workbook();
//Instantiating a Workbook object Workbook workbook = new Workbook(); //Accessing the added worksheet in the Excel file int sheetIndex = workbook.getWorksheets().add(); Worksheet worksheet = workbook.getWorksheets().get(sheetIndex); Cells cells = worksheet.getCells(); Column column = cells.getColumns().get(30); Style style1 = column.getStyle(); style1.setHorizontalAlignment(TextAlignmentType.CENTER); style1.setCustom("$#,##0;[Red]$-#,##0"); StyleFlag styleFlag1 = new StyleFlag(); styleFlag1.setNumberFormat(true); styleFlag1.setHorizontalAlignment(true); //Applying the style to the column column.applyStyle(style1, styleFlag1); //Saving the modified Excel file in default format workbook.save("C:\\output.xls");