I gang

web based excel converter required

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.

Færdigheder: .NET, PHP, Software Arkitektur

Se mere: what is a web script, we excel, php to excel converter, net it systems, new excel, xlsx, who provide the work excel, web to excel, web based, web based solution, save to excel, php web based, large translation job, file decode, File converter, excel type work, excel small work, excel based, excel 7, decode a file, save excel read, transformation files, net based code, excel can open file, decode data

Om arbejdsgiveren:
( 4 bedømmelser ) Oxford, United Kingdom

Projekt-ID: #939410

Tildelt til:

mneo

Hi, Please have a look at your PMB. Thanks

£50 GBP in 3 dage
(30 bedømmelser)
4.3

10 freelancere byder i gennemsnit £190 for dette job

SigmaVisual

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

£100 GBP in 2 dage
(259 bedømmelser)
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 dage
(11 bedømmelser)
5.4
pixarsolution

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

£200 GBP in 4 dage
(5 bedømmelser)
5.4
SSYES

Please refer inbox. Thanks.

£200 GBP in 7 dage
(11 bedømmelser)
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 dage
(11 bedømmelser)
4.6
tomthanks

Experienced MS developer...

£220 GBP in 4 dage
(1 bedømmelse)
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 Mere

£400 GBP in 15 dage
(0 bedømmelser)
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 Mere

£200 GBP in 5 dage
(0 bedømmelser)
0.0
nkshah

Please check PM

£80 GBP in 2 dage
(0 bedømmelser)
0.0