import data from excels

roshanearly · Post by **roshanearly** » Thu Jul 11, 2013 12:43 am

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

SURA · Post by **SURA** » Thu Jul 11, 2013 12:59 am

Can you give some example? The way how i under stood is like below! Is it correct?

Code: Select all

     	1961        1962        1963        1964
USA      a           x            g           y

But you need the output like this?

Code: Select all

Country      Year       Value
USA          1961       a
USA          1962       x
USA          1963       g
USA          1964       y

roshanearly · Post by **roshanearly** » Thu Jul 11, 2013 1:38 am

yes almost

ray.wurlod · Post by **ray.wurlod** » Thu Jul 11, 2013 2:52 am

Specify more precisely and we may be able to respond more precisely. We do not like wasting time guessing.

chulett · Post by **chulett** » Thu Jul 11, 2013 7:09 am

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.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Fri Jul 12, 2013 5:56 am

Did you look into Pivot option ?

Will the number of columns be same in all input data ?

DSXchange

import data from excels

import data from excels

Re: import data from excels

Re: import data from excels