web based excel converter required

Concluído Postado Feb 6, 2011 Pago na entrega
Concluído Pago na entrega

We require a small script to be written that can be called by one of our existing web based systems.

Our existing system should be able to call a URL with URL parameters that include a URL to a source Excel file, a URL to a destination Excel File, a type of 'translation' and a code which specifies the 'translation'.

The script should then access the source Excel file and grab the data it needs from that file and transforms it as necessary and puts it into the destination source file.

The script will then provide the HTTP response of the finished output Excel file which our existing system will save for its own use.

I am open to any solution that provides this but experience shows the best way forward is with .Net.

***Important***

1. The files to be dealt with are relatively large and complex.

2. The script must be able to decode the transformation code to understand what it must do

3. The script must be easily updated as we identify new transformations that are required.

4. The script must be able to identify and read XLS and XLSX files automatically.

4. The script has been attempted in PHP without success - using PHPExcel the files are just too large

5. The script has been attempted in C#.net with limited success - we need someone who know's what they're doing.

***VERY IMPORTANT***

1. You can do the work within 7 days

2. You have EXPERIENCE doing this type of job

An example transformation code would be "A1:B7|C3:D10; F12:F13|nextclrcol(A4)"

This would include 2 transformations (split by the semicolon ';'), the source data is to the left of the pipe '|' and the destination is to the right of the pipe '|'

Transformation 1
Copy the data from cells A1:B7 in the source sheet to C3:D10 in the destination sheet

Transformation 2
Copy the data from cells F12:F13 in the source sheet to the corresponding number of cells in the next clear column after the cell A4.
So if A5 is empty then we check to see if A6 is empty so we can put in the source data. If both are empty then we'll put in the data if not, lets check A6 and A7, or move again to A7 and A8, and again to A8 and A9. This continues until we find the next free columns that can take the data correctly.

The current list of transformations do not get any more difficult than that.

.NET PHP Arquitetura de software

ID do Projeto: #939410

Sobre o projeto

10 propostas Projeto remoto Ativo em Feb 7, 2011

Concedido a:

mneo

Hi, Please have a look at your PMB. Thanks

£50 GBP em 3 dias
(30 Comentários)
4.3

10 freelancers estão ofertando em média £190 nesse trabalho

SigmaVisual

We can help in your project, please check PMB and our ratings/reviews to get idea of our experience.

£100 GBP in 2 dias
(259 Comentários)
8.0
kamosion

I've done a lot of projects with similar functionality. Programming components : Python + "python-excel". (extremely fast processing).

£250 GBP in 2 dias
(11 Comentários)
5.4
pixarsolution

I am proficient developer and have done such tasks before. Let's start

£200 GBP in 4 dias
(5 Comentários)
5.4
SSYES

Please refer inbox. Thanks.

£200 GBP in 7 dias
(11 Comentários)
4.7
topOneLancer

hi,sir,i got the experience to generate read/write excel,word files in .net,i can start right away!Thanks!

£200 GBP in 6 dias
(11 Comentários)
4.6
tomthanks

Experienced MS developer...

£220 GBP in 4 dias
(1 Comentário)
3.7
smithanairr

We are ready to take up this project. Advance payment is not required. Please send a sample input and output file. Some other details like how stiff or flexible will be the data format. Is going to remain in those colu Mais

£400 GBP in 15 dias
(0 Comentários)
0.0
figmentech

i did this kind of job several times, i created complete reporting system fro two telecom companies that calculate and write excel file from mySQL and read and transform Excel files and make CSV, Excel and Relations in Mais

£200 GBP in 5 dias
(0 Comentários)
0.0
nkshah

Please check PM

£80 GBP in 2 dias
(0 Comentários)
0.0