[$-409]@ what is this symbol am getting from excel ??

[indu yeturu]

Hi when I try to get Data objects from excel sheet ,am getting date appended with this special sign ?
how to get date alone ???
please.. give me the solution

thanks
indu

[Ulf Dittmer]

Post the code you're using and the data you're working with.

[indu yeturu]

for(int x=21;x<rows;x++)
	   	 	    {
	   	 	    	for(int y=0;y<numOfColumns-1;y++)
	   	 	    	{
	   	 	    	if(s.getCell(y,x).getContents()!=null)
	   	 	    	{
	   	 	    		   //System.out.println(s.getCell(y,x).getContents());
	   	 	    		   datecol[count]=s.getCell(0,x).getContents();
	  	   	 	    	   item[count]=s.getCell(1,x).getContents();
	   	 	    		   amount[count]=s.getCell(2,x).getContents();
	   	 	    		   type[count]=s.getCell(3,x).getContents();
	   	 	    		    }
	   	 	    			   	 	    	
	   	 	    	}
	   	 	    		count++;   //System.out.println("----------------------------");
	   	 	    }     

Here the datecol[] is the array of string of dates am getting from excel... For eg.., i t display the date as "[$-409]28-Feb-10;@"

[Ulf Dittmer]

Read the javadocs of the jxl.Cell#getContents() method and act accordingly.

[Campbell Ritchie]

Too difficult for "beginning". Moving thread.