Possibility of Creating a Spreadsheet in Java?

Possibility of Creating a Spreadsheet in Java?

View Answers

March 19, 2009 at 5:38 AM

hi friend

This code really works for you. To run the given code, you have to download the poi-bin-3.1-beta2-20080526.zip(POI.jar) from Apache Jakarta Project.

import java.io.*;
import java.util.Random;
import org.apache.poi.hssf.record.*;
import org.apache.poi.hssf.model.*;
import org.apache.poi.hssf.usermodel.*;
import org.apache.poi.hssf.util.*;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;

public class CreateSpreadsheet {
public static void main (String[] args) throws Exception {
try{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet("Excel sheet");
HSSFRow row = sheet.createRow((short)0);
HSSFCell cell = row.createCell((short)0);
cell.setCellValue(1);

row.createCell((short)0).setCellValue(" ID");
row.createCell((short)1).setCellValue(" Name ");
row.createCell((short)2).setCellValue(" Address");
HSSFRow row1 = sheet.createRow((short)1);
HSSFCell cell1 = row1.createCell((short)1);
cell.setCellValue(2);

row1.createCell((short)0).setCellValue(1);
row1.createCell((short)1).setCellValue("Angelina ");
row1.createCell((short)2).setCellValue("Delhi");
FileOutputStream fileOut = new FileOutputStream("Hello.xls");
wb.write(fileOut);
fileOut.close();
}catch ( Exception ex ){
}
}
}

Thanks
RoseIndia Team









Related Tutorials/Questions & Answers:
Possibility of Creating a Spreadsheet in Java? - Java Beginners
difference between java5 and java6 - Java Beginners
Advertisements
Java2
about java1
Javah
About Java2
javaa swings - IDE Questions
Javap Tool application
write spreadsheet
write spreadsheet
Artifacts of javax
Javah -  Header File Generator
ModuleNotFoundError: No module named 'javax'
ModuleNotFoundError: No module named 'javax'
ModuleNotFoundError: No module named 'spreadsheet'
ModuleNotFoundError: No module named 'spreadsheet'
Javac -source KeyTest.java
javax - JSP-Servlet
ModuleNotFoundError: No module named 'javac-parser'
ModuleNotFoundError: No module named 'javac-parser'
Version of javax>javaee-api dependency
ModuleNotFoundError: No module named 'google_spreadsheet'
ModuleNotFoundError: No module named 'google_spreadsheet'
ModuleNotFoundError: No module named 'o2-google-spreadsheet'
ModuleNotFoundError: No module named 'Spreadsheet-HTML'
ModuleNotFoundError: No module named 'bluesky-spreadsheet'
ModuleNotFoundError: No module named 'google_spreadsheet'
ModuleNotFoundError: No module named 'spreadsheet-maker'
ModuleNotFoundError: No module named 'spreadsheet-maker'
javab - Java Beginners
javas - JSP-Servlet
javac complier not found - JSP-Servlet
connect jdbc to an Excel spreadsheet
Write a program that replaces a, e, i, o, u in Java2
How to retrieve file name and path of an excel spreadsheet imported into Oracle Database
Version of javax>javaee-endorsed-api dependency
Version of javax>javaee-web-api dependency
Version of com.supwisdom>spreadsheet-mapper-parent dependency
ModuleNotFoundError: No module named 'django-spreadsheet-reports'
ModuleNotFoundError: No module named 'django-spreadsheet-reports'
ModuleNotFoundError: No module named 'domdf-spreadsheet-tools'
ModuleNotFoundError: No module named 'google-spreadsheet-py'
ModuleNotFoundError: No module named 'google-spreadsheet-py'
ModuleNotFoundError: No module named 'python-barcode-spreadSheet'
ModuleNotFoundError: No module named 'python-google-spreadsheet'
ModuleNotFoundError: No module named 'python-google-spreadsheet'
ModuleNotFoundError: No module named 'django-spreadsheet-reports'
ModuleNotFoundError: No module named 'domdf-spreadsheet-tools'
ModuleNotFoundError: No module named 'google-spreadsheet-py'
Version of plexus>plexus-compiler-javac dependency

Ads