logo

Java Code for Writing into a File Solution 2022

   

Added on  2022-08-29

4 Pages550 Words20 Views
Task 1
i. Java code for writing into a file.
import java.io.File;
import java.io.FileOutputStream;
import java.util.Map;
import java.util.Set;
import java.util.TreeMap;
import org.apache.poi.ss.usermodel.Cell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;
public class WriteDataToExcel {
public static void main(String[] args) throws Exception {
//Create blank workbook
XSSFWorkbook workbook = new XSSFWorkbook();
//Create a blank sheet
XSSFSheet spreadsheet = workbook.createSheet( " Class");
//Create row object
XSSFRow row;

//This data needs to be written (Object[])
Map < String, Object[] > ClassInfo= new TreeMap < String, Object[] >();
empinfo.put( "1", new Object[] {
"ClassName", TotalOccurrences });
//Create a blank sheet
XSSFSheet spreadsheet = workbook.createSheet( " Class");
//Create row object
XSSFRow row;
//This data needs to be written (Object[])
Map < String, Object[] > ClassInfo= new TreeMap < String, Object[] >();
empinfo.put( "1", new Object[] {
"ClassName", TotalOccurrences });
//Iterate over data and write to sheet
Set < String > keyid = empinfo.keySet();
int rowid = 0;
for (String key : keyid) {
row = spreadsheet.createRow(rowid++);
Object [] objectArr = empinfo.get(key);
int cellid = 0;
for (Object obj : objectArr){
Cell cell = row.createCell(cellid++);
cell.setCellValue((String)obj);

End of preview

Want to access all the pages? Upload your documents or become a member.

Related Documents
NAME:SHRAVAN S REGISTRATION NUMBER:19BCE2548 1)Write your
|3
|394
|35

Code for Proxy Cache Assignment - Desklib
|7
|1720
|105

Online Sales and Inventory Management System (SIMS)
|18
|4838
|56

Programming Assignment: Java Programming
|12
|2732
|107

Java Assignment Help | Online Homework
|13
|1219
|353

CS4348 - Operating Systems Concepts
|5
|1324
|177