Code file attached

ReadFile.java.txt (text/plain), 4.99 KB, created by Pankaj Sinha on 2015-12-14 11:04:13 UTC

(hide)

Description: Code file attached

Filename:

MIME Type:

Creator: Pankaj Sinha

Created: 2015-12-14 11:04:13 UTC

Size: 4.99 KB

patch

obsolete

>package Package1; >import java.io.*; >import java.util.*; >import java.lang.*; > > >import org.apache.poi.ss.usermodel.Cell; >import org.apache.poi.ss.usermodel.Row; >import org.apache.poi.ss.usermodel.Sheet; >import org.apache.poi.ss.usermodel.Workbook; >import org.apache.poi.xssf.usermodel.XSSFWorkbook; > >//import java.io.FileInputStream; >//import java.io.FileNotFoundException; >//import java.io.IOException; >//import java.util.ArrayList; >//import java.util.Iterator; >//import java.util.List; > >public class ReadFile { > //private static final String FILE_PATH = "C:\\Users\\pankaj-sinha\\Desktop\\Desktop\\WorkArea\\DataSource.xlsx"; > > > > public static void main(String args[]) throws Exception { > >// try{ >// FileInputStream f= new FileInputStream(new File ("C:/Users/pankaj-sinha/Desktop/Desktop/WorkArea/DataSource.xlsx")); >// Workbook wb=new XSSFWorkbook(f); >// Sheet firstsheet=wb.getSheetAt(0); >// Iterator<Row> iterator=firstsheet.iterator(); >// >// while (iterator.hasNext()){ >// Row nextRow= iterator.next(); >// Iterator<Cell> cellIterator=nextRow.cellIterator(); >// >// while (cellIterator.hasNext()){ >// Cell cell=cellIterator.next(); >// >// switch (cell.getCellType()){ >// case Cell.CELL_TYPE_STRING: >// System.out.println(cell.getStringCellValue()); >// break; >// case Cell.CELL_TYPE_BOOLEAN: >// System.out.println(cell.getBooleanCellValue()); >// break; >// case Cell.CELL_TYPE_NUMERIC: >// System.out.println(cell.getNumericCellValue()); >// break; >// } >// System.out.print(" - "); >// } >// >// System.out.println(); >// } >// >// System.out.println("File line passed"); >// wb.close(); >// f.close(); >// } >// catch (Exception e){ >// >// e.printStackTrace(); >// >// } > > >// Code block to read the file------ Starts > String excelFilePath = "C:/Users/pankaj-sinha/Desktop/Desktop/WorkArea/DataSource.xlsx"; > FileInputStream inputStream = new FileInputStream(new File(excelFilePath)); > > Workbook workbook = new XSSFWorkbook(inputStream); > Sheet firstSheet = workbook.getSheetAt(0); > Iterator<Row> iterator = firstSheet.iterator(); > > while (iterator.hasNext()) { > Row nextRow = iterator.next(); > Iterator<Cell> cellIterator = nextRow.cellIterator(); > > while (cellIterator.hasNext()) { > Cell cell = cellIterator.next(); > > switch (cell.getCellType()) { > case Cell.CELL_TYPE_STRING: > System.out.print(cell.getStringCellValue()); > break; > case Cell.CELL_TYPE_BOOLEAN: > System.out.print(cell.getBooleanCellValue()); > break; > case Cell.CELL_TYPE_NUMERIC: > System.out.print(cell.getNumericCellValue()); > break; > } > System.out.print(" - "); > } > System.out.println(); > } > > workbook.close(); > inputStream.close(); > >// Code block to read the file------ Ends > >// Write in Excel------ Starts > FileOutputStream fout=new FileOutputStream(new File("C:/Users/pankaj-sinha/Desktop/Desktop/WorkArea/DataSource1.xlsx")); > Workbook wb= new XSSFWorkbook (); > Sheet sheet = wb.createSheet("Java Books"); > > Object[][] bookData = { > {"Head First Java", "Kathy Serria", 79}, > {"Effective Java", "Joshua Bloch", 36}, > {"Clean Code", "Robert martin", 42}, > {"Thinking in Java", "Bruce Eckel", 35}, > }; > > int rowCount = 0; > > for (Object[] aBook : bookData) { > Row row = sheet.createRow(++rowCount); > > int columnCount = 0; > > for (Object field : aBook) { > Cell cell = row.createCell(++columnCount); > if (field instanceof String) { > cell.setCellValue((String) field); > } else if (field instanceof Integer) { > cell.setCellValue((Integer) field); > } > } > > } > > > try (FileOutputStream outputStream = new FileOutputStream("JavaBooks.xlsx")) { > workbook.write(outputStream); > > >// Write in Excel------ Ends > > } >} >} View Attachment As Raw

This is ASF Bugzilla: the Apache Software Foundation bug system. In case of problems with the functioning of ASF Bugzilla, please contact bugzilla-admin@apache.org. Please Note: this e-mail address is only for reporting problems with ASF Bugzilla. Mail about any other subject will be silently ignored.

• • Home
  • | New
  • | Browse
  • | Search
  • |
    [?]
  • | Reports
  • | Help
  • | New Account
  • | Log In
    Remember [x]
  • | Forgot Password
    Login: [x]