csv to xlsx with pivot table

Completed Posted Jul 21, 2010 Paid on delivery
Completed Paid on delivery

I have a system that generates a csv file (it could just as easily be a tab delimited file if easier). The the contents of the file is essentially a row of column headings, and several records beneath (the first two rows have some other data). (A typical file has say 30 columns and 6000 rows, but could be bigger or smaller). I need a script that can read in this csv file and output an excel xlsx with a *pivot table* of the data. I also require *pivot chart* of the pivot table.

Details of the pivot table:

- The summed-up field in the pivot table will be the first column, and will be titled 'Number'

- The second column is called "Observations" which mustn't be visible in the pivot table (but be included in the range)

- The third column must be the row-field

- All other fields must be in the pivot table, as page fields

There are a few other odds and ends I want in the xlsx file, but they are trivial (titles, etc).

The best spec of what I want is to go from [url removed, login to view] to [url removed, login to view], see the attachments.

The script must work on a FreeBSD system (i.e. Linux NOT Windows), and ideally should be in perl (as the rest of the system is perl). But I would also accept a script in php.

Excel Perl PHP

Project ID: #744649

About the project

21 proposals Remote project Active Jul 24, 2010

Awarded to:

ixvivxi

Easily implemented in Perl.

$30 USD in 4 days
(2 Reviews)
3.5

21 freelancers are bidding on average $109 for this job

zk230182

plz see pmb

$200 USD in 5 days
(39 Reviews)
6.3
alin22

Hello sir, i have send you a pm.

$100 USD in 2 days
(14 Reviews)
4.7
zzeeshann

Please see your PMB

$80 USD in 6 days
(1 Review)
3.9
UltimateJob

Hi, Please check PMB. Regards UltimateJob

$80 USD in 2 days
(7 Reviews)
3.7
amsak

Pls see PM

$75 USD in 8 days
(9 Reviews)
3.6
najib0s

-=Quality and speed=- I can do it with high quality of work.

$79 USD in 2 days
(6 Reviews)
3.3
andreamoruno

Hi Sir/Madam we are experts on scripts development with php, and Linux, we can do it, please consider us.

$100 USD in 5 days
(2 Reviews)
2.8
sarita81

Dear Sir, I can do this for you. Regards.

$100 USD in 5 days
(1 Review)
2.0
bojan1979

Hello, I have done this kind (and even more complicated)of converters several times so this would not be a problem, and I already have a solution in my head.

$50 USD in 3 days
(1 Review)
1.0
Creative72

Hi there! I can do the job for creating a script in Php. Will request you to join online for the further discussion regarding the project scope. Thank you.

$130 USD in 5 days
(1 Review)
3.1
Prad24x7

Ready to work on the same asap..

$150 USD in 4 days
(0 Reviews)
0.0
psarathi2009

Kindly check your PMB. Thanks.

$110 USD in 7 days
(0 Reviews)
0.0
ratnomesh

sir, I have a letest set of computer & net connection. I'll do your project with my best. Please give me this chance.........thanking you.....Ratnomesh

$125 USD in 4 days
(0 Reviews)
0.0
snehanshu

We are the core window and web application programmer and Having such type of application in readymade, if you select us we can provide you the working sample in very next 2 working days

$100 USD in 7 days
(0 Reviews)
0.0
sic

Can do it by Sunday.

$50 USD in 3 days
(2 Reviews)
0.0
christmca06

Lets get started..

$150 USD in 5 days
(0 Reviews)
0.0
lakkantha

Dear Sir, I have read and understood your project requirements, given an optimum output to your organization, which I worked at times by utilizing minimum available resources. Hard working and submit in project by time More

$50 USD in 3 days
(0 Reviews)
0.0
princejijk

I can do this work as I'm an expert in EXCEL.

$90 USD in 5 days
(0 Reviews)
0.0
manjur09

I had great expireance on converting csv to xlsx while i am woring in Wipro Technoligies. I can do this. Thanks & Regards Manjur09

$250 USD in 7 days
(0 Reviews)
0.0
mansisuri

a) will u provide the csv file or we have to extract that. b) the sample .xl file which u have shown is all wht u want of every csv file ie a pivot table and a bar chart? c) all csv's have to b built in 1 .xl file More

$250 USD in 7 days
(0 Reviews)
0.0