org.apache.poi.hssf eclipse compiler tells cannot reslove symbol?how can i solve this

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • leninbecse
    New Member
    • Aug 2010
    • 15

    #1

    org.apache.poi.hssf eclipse compiler tells cannot reslove symbol?how can i solve this

    org.apache.poi. hssf (eclipse compiler) tells cannot resolve symbol?how can i solve this problem?
  • Dheeraj Joshi
    Recognized Expert Top Contributor
    • Jul 2009
    • 1129

    #2
    Can we see your code?

    Regards
    Dheeraj Joshi

    Comment

    • leninbecse
      New Member
      • Aug 2010
      • 15

      #3
      here i am attached my code where i am import file to indicate an error.....
      package readexcel;
      Code:
      import java.io.FileInputStream;
      import java.util.Iterator;
      import java.util.Vector;
      
      import org.apache.poi.hssf.usermodel.HSSFCell;
      [B]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;
      [/B]
      public class ReadExcelFile {
      
              public static void main(String[] args) {
      
                      String fileName = "C:\\excelFile.xls";
                      Vector dataHolder = ReadCSV(fileName);
                      printCellDataToConsole(dataHolder);
              }
      
              public static Vector ReadCSV(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) {
                              e.printStackTrace();
                      }
                      return cellVectorHolder;
              }
      
              private static void printCellDataToConsole(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();
                      }
              }
      }
      Last edited by Frinavale; Sep 2 '10, 03:17 PM. Reason: Please post code in [code] ... [/code] tags. Added code tags.

      Comment

      Working...