Search...
FAQs
Subscribe
Pie
FAQs
Recent topics
Flagged topics
Hot topics
Best topics
Search...
Search within Open Source Projects
Search Coderanch
Advance search
Google search
Register / Login
Post Reply
Bookmark Topic
Watch Topic
New Topic
programming forums
Java
Mobile
Certification
Databases
Caching
Books
Engineering
Micro Controllers
OS
Languages
Paradigms
IDEs
Build Tools
Frameworks
Application Servers
Open Source
This Site
Careers
Other
Pie Elite
all forums
this forum made possible by our volunteer staff, including ...
Marshals:
Campbell Ritchie
Jeanne Boyarsky
Ron McLeod
Paul Clapham
Liutauras Vilda
Sheriffs:
paul wheaton
Rob Spoor
Devaka Cooray
Saloon Keepers:
Stephan van Hulst
Tim Holloway
Carey Brown
Frits Walraven
Tim Moores
Bartenders:
Mikalai Zaikin
Forum:
Other Open Source Projects
[$-409]@ what is this symbol am getting from excel ??
indu yeturu
Ranch Hand
Posts: 123
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
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
thanks,
indu
Ulf Dittmer
Rancher
Posts: 43081
77
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Post the code you're using and the data you're working with.
indu yeturu
Ranch Hand
Posts: 123
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
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;@"
thanks,
indu
Ulf Dittmer
Rancher
Posts: 43081
77
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Read the javadocs of the
jxl.Cell#getContents()
method and act accordingly.
Campbell Ritchie
Marshal
Posts: 79178
377
posted 14 years ago
Number of slices to send:
Optional 'thank-you' note:
Send
Too difficult for "beginning". Moving
thread
.
With a little knowledge, a
cast iron skillet
is non-stick and lasts a lifetime.
reply
reply
Bookmark Topic
Watch Topic
New Topic
Boost this thread!
Similar Threads
Read Excel values and store in to Database
How to fetch Date Field from excel sheet in Java
Doubt on '#' in query.
what is this symbol "[$-409]dd-mmm-yy;@ " Excel to Java???
Using JDBC to insert into MS Excel file
More...