Devam Ediyor

csv to xlsx with pivot table

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.

Beceriler: Excel, Perl, PHP

Daha fazlasını görün: perl csv xlsx, csv xlsx, perl excel pivot, pivot table perl, php csv xlsx, perl pivot, perl pivot table excel, perl csv file pivot table, perl excel xlsx, perl excel pivot table, csv xlsx php, pivot table csv file, xlsx csv php, php xlsx pivot, php xlsx csv, excel pivot table perl, script pivot csv row, csv xlsx perl, perl script csv xlsx, php xlsx chart, perl chart, xlsx perl csv, csv pivot, perl xlsx csv, xlsx pivot table

İşveren Hakkında:
( 7 değerlendirme ) Cape Town, South Africa

Proje NO: #744649

Seçilen:

ixvivxi

Easily implemented in Perl.

4 gün içinde 30$ USD
(2 Değerlendirme)
3.5

21 freelancer bu iş için ortalamada 109$ teklif veriyor

zk230182

plz see pmb

in 5 gün içinde200$ USD
(39 Değerlendirme)
6.3
alin22

Hello sir, i have send you a pm.

in 2 gün içinde100$ USD
(14 Değerlendirme)
4.7
zzeeshann

Please see your PMB

in 6 gün içinde80$ USD
(1 Değerlendirme)
3.9
UltimateJob

Hi, Please check PMB. Regards UltimateJob

in 2 gün içinde80$ USD
(7 Değerlendirme)
3.7
amsak

Pls see PM

in 8 gün içinde75$ USD
(9 Değerlendirme)
3.6
najib0s

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

in 2 gün içinde79$ USD
(6 Değerlendirme)
3.3
andreamoruno

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

in 5 gün içinde100$ USD
(2 Değerlendirme)
2.8
sarita81

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

in 5 gün içinde100$ USD
(1 Değerlendirme)
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.

in 3 gün içinde50$ USD
(1 Değerlendirme)
1.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

in 7 gün içinde100$ USD
(0 Değerlendirme)
0.0
sic

Can do it by Sunday.

in 3 gün içinde50$ USD
(2 Değerlendirme)
0.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.

in 5 gün içinde130$ USD
(1 Değerlendirme)
3.1
christmca06

Lets get started..

in 5 gün içinde150$ USD
(0 Değerlendirme)
0.0
Prad24x7

Ready to work on the same asap..

in 4 gün içinde150$ USD
(0 Değerlendirme)
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

in 4 gün içinde125$ USD
(0 Değerlendirme)
0.0
princejijk

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

in 5 gün içinde90$ USD
(0 Değerlendirme)
0.0
psarathi2009

Kindly check your PMB. Thanks.

in 7 gün içinde110$ USD
(0 Değerlendirme)
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

in 7 gün içinde250$ USD
(0 Değerlendirme)
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 Daha fazlası

in 7 gün içinde250$ USD
(0 Değerlendirme)
0.0
beancurdjelly

Easy job, I ready to start.

1 gün içinde 150$ USD
(0 Değerlendirme)
0.0