Java xlsx

Java xlsx

View Answers

September 21, 2009 at 1:07 PM

Hi Friend,

1)Write .xlsx file:

import java.io.*;
import java.util.*;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;

public class CreateFile{
public static void main(String args[]) throws IOException{
HSSFWorkbook wb = new HSSFWorkbook();
HSSFSheet sheet = wb.createSheet();
int rowCount=0;
int count=0;
HSSFRow headerRow = sheet.createRow((short) 0);
HSSFRow dataRow =sheet.createRow((short) 1);
headerRow.createCell((short)0).setCellValue("ID");
headerRow.createCell((short)1).setCellValue("NAME");
headerRow.createCell((short)2).setCellValue("Address");
for(int i=0;i<5;i++){
rowCount++;
sheet.createRow((short)rowCount);
dataRow.createCell((short)0).setCellValue(1);
dataRow.createCell((short)1).setCellValue("Rose");
dataRow.createCell((short)2).setCellValue("Delhi");
count++;
}
File f = new File("c:\\test.xlsx");
FileOutputStream fos = new FileOutputStream(f);
wb.write(fos);
}
}

2)Read .xlsx File:

import java.io.*;
import java.util.*;
import org.apache.poi.hssf.usermodel.HSSFCell;
import org.apache.poi.hssf.usermodel.HSSFRow;
import org.apache.poi.hssf.usermodel.HSSFSheet;
import org.apache.poi.hssf.usermodel.HSSFWorkbook;
import org.apache.poi.poifs.filesystem.POIFSFileSystem;
public class ReadFile {
public static void main( String [] args ) {

String fileName="C:\\test.xlsx";
Vector dataHolder=ReadFile(fileName);
read(dataHolder);
}
public static Vector ReadFile(String fileName){
Vector cellVectorHolder = new Vector();
try{
FileInputStream myInput = new FileInputStream(fileName);
POIFSFileSystem myFileSystem = new POIFSFileSystem(myInput);
HSSFWorkbook myWorkBook = new HSSFWorkbook(myFileSystem);
HSSFSheet mySheet = myWorkBook.getSheetAt(0);
Iterator rowIter = mySheet.rowIterator();
while(rowIter.hasNext()){
HSSFRow myRow = (HSSFRow) rowIter.next();
Iterator cellIter = myRow.cellIterator();
Vector cellStoreVector=new Vector();
while(cellIter.hasNext()){
HSSFCell myCell = (HSSFCell) cellIter.next();
cellStoreVector.addElement(myCell);
}
cellVectorHolder.addElement(cellStoreVector);
}
}catch (Exception e){ }
return cellVectorHolder;
}
private static void read(Vector dataHolder) {
for (int i=0;i<dataHolder.size(); i++){
Vector cellStoreVector=(Vector)dataHolder.elementAt(i);
for (int j=0; j < cellStoreVector.size();j++){
HSSFCell myCell = (HSSFCell)cellStoreVector.elementAt(j);
String stringCellValue = myCell.toString();
System.out.print(stringCellValue+"\t");
}
System.out.println();
}
}
}
Thanks

September 1, 2010 at 10:45 PM

Hi... If you want to read/write XLSX file (of office
2007). You just can change all "HSSFwhatever" by "XSSF whatever"... As follows...


/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package testes;

import java.io.*;
import java.util.*;
import org.apache.poi.xssf.usermodel.XSSFCell;
import org.apache.poi.xssf.usermodel.XSSFRow;
import org.apache.poi.xssf.usermodel.XSSFSheet;
import org.apache.poi.xssf.usermodel.XSSFWorkbook;

public class ReadFile {

public static void main(String[] args) {

String fileName = "relat2002_12.xlsx";
Vector dataHolder = ReadFile(fileName);
read(dataHolder);
}

public static Vector ReadFile(String fileName) {
Vector cellVectorHolder = new Vector();
try {
FileInputStream arquivo = new FileInputStream(fileName);
XSSFWorkbook planilha = new XSSFWorkbook(arquivo);

XSSFSheet aba = planilha.getSheetAt(0);
Iterator rowIter = aba.rowIterator();

while (rowIter.hasNext()) {
XSSFRow myRow = (XSSFRow) rowIter.next();
Iterator cellIter = myRow.cellIterator();

Vector cellStoreVector = new Vector();
while (cellIter.hasNext()) {

XSSFCell myCell = (XSSFCell) cellIter.next();
cellStoreVector.addElement(myCell);
}
cellVectorHolder.addElement(cellStoreVector);
}
} catch (Exception e) {
}
return cellVectorHolder;
}

private static void read(Vector dataHolder) {
for (int i = 0; i < dataHolder.size(); i++) {
Vector cellStoreVector = (Vector) dataHolder.elementAt(i);

for (int j = 0; j < cellStoreVector.size(); j++) {
XSSFCell myCell = (XSSFCell) cellStoreVector.elementAt(j);
String stringCellValue = myCell.toString();
System.out.print(stringCellValue + "\t");
}
System.out.println();
}

}
}









Related Tutorials/Questions & Answers:
Java xlsx - JSP-Servlet
Java xlsx  Dear Sir's / Madam's i want to read/write XLSX file... but not xlsx file.   Hi Friend, 1)Write .xlsx file: import java.io....); } } 2)Read .xlsx File: import java.io.*; import java.util.*; import
How to delete .xlsx file in java?
How to delete .xlsx file in java?  Hello Sir, I am unable to delete .xlsx file using below code, What is wrong here? if(myFile != null && myFile.exists()    && myFile.canRead() &&
Advertisements
Java code for conversion between .xls and .xlsx or vice versa - Development process
Java code for conversion between .xls and .xlsx or vice versa  I've...) and clients may be using MS Excel 2007 / 2010 (.xlsx) format. I need a solution or tool in Java for converting between .xls to .xlsx or Vice versa
Java code for converting between .xls to .xlsx and vice versa - Java Beginners
Java code for converting between .xls to .xlsx and vice versa  I've a web application which allows clients to upload or download MS Excel sheets. I need a solution in Java from which i can upload in MS Excel 2003 and download
Maven dependency for org.webjars.npm - xlsx version 0.18.3 is released. Learn to use xlsx version 0.18.3 in Maven based Java projects
( org.webjars.npm - xlsx version 0.18.3 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.18.3 in Java projects...; org.webjars.npm - xlsx version 0.18.3 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.17.5 is released. Learn to use xlsx version 0.17.5 in Maven based Java projects
( org.webjars.npm - xlsx version 0.17.5 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.17.5 in Java projects...; org.webjars.npm - xlsx version 0.17.5 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.17.4 is released. Learn to use xlsx version 0.17.4 in Maven based Java projects
( org.webjars.npm - xlsx version 0.17.4 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.17.4 in Java projects...; org.webjars.npm - xlsx version 0.17.4 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.17.3 is released. Learn to use xlsx version 0.17.3 in Maven based Java projects
( org.webjars.npm - xlsx version 0.17.3 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.17.3 in Java projects...; org.webjars.npm - xlsx version 0.17.3 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.17.2 is released. Learn to use xlsx version 0.17.2 in Maven based Java projects
( org.webjars.npm - xlsx version 0.17.2 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.17.2 in Java projects...; org.webjars.npm - xlsx version 0.17.2 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.17.0 is released. Learn to use xlsx version 0.17.0 in Maven based Java projects
( org.webjars.npm - xlsx version 0.17.0 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.17.0 in Java projects...; org.webjars.npm - xlsx version 0.17.0 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.14.5 is released. Learn to use xlsx version 0.14.5 in Maven based Java projects
( org.webjars.npm - xlsx version 0.14.5 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.14.5 in Java projects...; org.webjars.npm - xlsx version 0.14.5 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.12.13 is released. Learn to use xlsx version 0.12.13 in Maven based Java projects
( org.webjars.npm - xlsx version 0.12.13 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.12.13 in Java...; org.webjars.npm - xlsx version 0.12.13 java library in your project. ADS
Maven dependency for org.webjars.npm - xlsx version 0.12.5 is released. Learn to use xlsx version 0.12.5 in Maven based Java projects
( org.webjars.npm - xlsx version 0.12.5 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.12.5 in Java projects...; org.webjars.npm - xlsx version 0.12.5 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.18.5 is released. Learn to use xlsx version 0.18.5 in Maven based Java projects
( org.webjars.npm - xlsx version 0.18.5 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.18.5 in Java projects...; org.webjars.npm - xlsx version 0.18.5 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for org.webjars.npm - xlsx version 0.18.4 is released. Learn to use xlsx version 0.18.4 in Maven based Java projects
( org.webjars.npm - xlsx version 0.18.4 ) in their Java project if it is based... in project? Steps to use  org.webjars.npm - xlsx version 0.18.4 in Java projects...; org.webjars.npm - xlsx version 0.18.4 java library in your project. ADS_TO_REPLACE_2 Now
Maven dependency for com.monitorjbl - xlsx-streamer version 2.2.0 is released. Learn to use xlsx-streamer version 2.2.0 in Maven based Java projects
- xlsx-streamer version 2.2.0 in Java projects. Follow the step by step tutorial...Maven dependency for  com.monitorjbl  - Version 2.2.0 of xlsx-streamer released The developers of   com.monitorjbl - xlsx-streamer
Maven dependency for com.monitorjbl - xlsx-streamer version 0.2.7 is released. Learn to use xlsx-streamer version 0.2.7 in Maven based Java projects
- xlsx-streamer version 0.2.7 in Java projects. Follow the step by step tutorial...Maven dependency for  com.monitorjbl  - Version 0.2.7 of xlsx-streamer released The developers of   com.monitorjbl - xlsx-streamer
ModuleNotFoundError: No module named 'xlsx'
ModuleNotFoundError: No module named 'xlsx'  Hi, My Python program is throwing following error: ModuleNotFoundError: No module named 'xlsx' How to remove the ModuleNotFoundError: No module named 'xlsx' error
Version of com.monitorjbl>xlsx-streamer dependency
List of Version of com.monitorjbl>xlsx-streamer dependency
ModuleNotFoundError: No module named 'csv-to-xlsx'
ModuleNotFoundError: No module named 'csv-to-xlsx'  Hi, My Python... 'csv-to-xlsx' How to remove the ModuleNotFoundError: No module named 'csv-to-xlsx' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'pyexcel-xlsx'
ModuleNotFoundError: No module named 'pyexcel-xlsx'  Hi, My Python... 'pyexcel-xlsx' How to remove the ModuleNotFoundError: No module named 'pyexcel-xlsx' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'python-xlsx'
ModuleNotFoundError: No module named 'python-xlsx'  Hi, My Python... 'python-xlsx' How to remove the ModuleNotFoundError: No module named 'python-xlsx' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'py-xlsx'
ModuleNotFoundError: No module named 'py-xlsx'  Hi, My Python...-xlsx' How to remove the ModuleNotFoundError: No module named 'py-xlsx... to install padas library. You can install py-xlsx python with following command
ModuleNotFoundError: No module named 'scrapy-xlsx'
ModuleNotFoundError: No module named 'scrapy-xlsx'  Hi, My Python... 'scrapy-xlsx' How to remove the ModuleNotFoundError: No module named 'scrapy-xlsx' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'wrktools-xlsx'
ModuleNotFoundError: No module named 'wrktools-xlsx'  Hi, My... 'wrktools-xlsx' How to remove the ModuleNotFoundError: No module named 'wrktools-xlsx' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'xlsx-parser'
ModuleNotFoundError: No module named 'xlsx-parser'  Hi, My Python... 'xlsx-parser' How to remove the ModuleNotFoundError: No module named 'xlsx-parser' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'xlsx_to_handontable'
ModuleNotFoundError: No module named 'xlsx_to_handontable'  Hi, My... named 'xlsx_to_handontable' How to remove the ModuleNotFoundError: No module named 'xlsx_to_handontable' error? Thanks   Hi
ModuleNotFoundError: No module named 'xlsx-parser'
ModuleNotFoundError: No module named 'xlsx-parser'  Hi, My Python... 'xlsx-parser' How to remove the ModuleNotFoundError: No module named 'xlsx-parser' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'xlsx-xargs'
ModuleNotFoundError: No module named 'xlsx-xargs'  Hi, My Python... 'xlsx-xargs' How to remove the ModuleNotFoundError: No module named 'xlsx... have to install padas library. You can install xlsx-xargs python
ModuleNotFoundError: No module named 'xlsx-split'
ModuleNotFoundError: No module named 'xlsx-split'  Hi, My Python... 'xlsx-split' How to remove the ModuleNotFoundError: No module named 'xlsx... have to install padas library. You can install xlsx-split python
ModuleNotFoundError: No module named 'xlsx-streaming'
ModuleNotFoundError: No module named 'xlsx-streaming'  Hi, My... named 'xlsx-streaming' How to remove the ModuleNotFoundError: No module named 'xlsx-streaming' error? Thanks   Hi, In your python
ModuleNotFoundError: No module named 'xlsx_to_handontable'
ModuleNotFoundError: No module named 'xlsx_to_handontable'  Hi, My... named 'xlsx_to_handontable' How to remove the ModuleNotFoundError: No module named 'xlsx_to_handontable' error? Thanks   Hi
ModuleNotFoundError: No module named 'xlsx-xargs'
ModuleNotFoundError: No module named 'xlsx-xargs'  Hi, My Python... 'xlsx-xargs' How to remove the ModuleNotFoundError: No module named 'xlsx... have to install padas library. You can install xlsx-xargs python
ModuleNotFoundError: No module named 'classy-xlsx'
ModuleNotFoundError: No module named 'classy-xlsx'  Hi, My Python... 'classy-xlsx' How to remove the ModuleNotFoundError: No module named 'classy-xlsx' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'csv-to-xlsx'
ModuleNotFoundError: No module named 'csv-to-xlsx'  Hi, My Python... 'csv-to-xlsx' How to remove the ModuleNotFoundError: No module named 'csv-to-xlsx' error? Thanks   Hi, In your python environment
ModuleNotFoundError: No module named 'dodotable-xlsx'
ModuleNotFoundError: No module named 'dodotable-xlsx'  Hi, My... named 'dodotable-xlsx' How to remove the ModuleNotFoundError: No module named 'dodotable-xlsx' error? Thanks   Hi, In your python
How can i extract email ids from xls/xlsx file in java?
How can i extract email ids from xls/xlsx file in java?  that's the code..... i tried to extract email id;s from xls file........... but it doesn;t gives the proper output? table is like this: bhavik
ModuleNotFoundError: No module named 'convert-csv-to-xlsx'
ModuleNotFoundError: No module named 'convert-csv-to-xlsx'  Hi, My... named 'convert-csv-to-xlsx' How to remove the ModuleNotFoundError: No module named 'convert-csv-to-xlsx' error? Thanks   Hi
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'  Hi...: No module named 'odoo10-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx'  Hi...: No module named 'odoo10-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo10-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx'  Hi...: No module named 'odoo11-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo11-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'  Hi...: No module named 'odoo12-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx'  Hi...: No module named 'odoo12-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx' error? Thanks  
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper'
ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' ...: ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' How to remove the ModuleNotFoundError: No module named 'odoo12-addon-report-xlsx-helper' error
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx'
ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx'  Hi...: No module named 'odoo13-addon-report-xlsx' How to remove the ModuleNotFoundError: No module named 'odoo13-addon-report-xlsx' error? Thanks  

Ads