i need to process excels
which i have converted to csv and trying to import using sequential file
The data in excel is in form of 2-d tables .how can it be processed
It is also needed to pick some specific fields from the csv , can this be done somehow like we pick fields using tags in xml
import data from excels
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Thu Aug 09, 2012 4:55 am
- Location: bangalore
import data from excels
ROSHAN
Re: import data from excels
Can you give some example? The way how i under stood is like below! Is it correct?
But you need the output like this?
Code: Select all
1961 1962 1963 1964
USA a x g y
Code: Select all
Country Year Value
USA 1961 a
USA 1962 x
USA 1963 g
USA 1964 y
Thanks
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
Ram
----------------------------------
Revealing your ignorance is fine, because you get a chance to learn.
-
- Participant
- Posts: 27
- Joined: Thu Aug 09, 2012 4:55 am
- Location: bangalore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
So we're not discussing 'importing' Excel data but rather reading a .csv flat file that happened to come from Excel. OK, fine... but as noted you'll need to provide specific details about your requirements - examples of both your input data and what you need your output to look like would be an excellent place to start.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom