Write 2 Simple Programs. Excel, CSV, Upload to Web server.

已完成 已发布的 7 年前 货到付款
已完成 货到付款

Hi,

I require 2 Separate Programs to be written for me to Run on my Desktop PC, Windows 7, 10 +.

The Programs are to do the following.

1. Enable me to Select Multiple Excel files and the program to perform the following..

Automatically edit the files by removing unwanted columns and editing existing column titles.(These are constant and don't change).

2. Create 2 new Columns at the end of the Table by Calculating figures in 2 existing Rows (Resulting in an Average of the Total).

3. Save the resulting files as MS-DOS CSV.

4. Upload to a Website Server (FTP ?) over writing existing files. (If Possible).

Summary.

2 Programs to manipulate 2 Different but Constantly formatted Excel files that i will be able to Select Multiple of and re save in CSV format and upload to Website Server overwriting Existing files.

I will be running this program once a week to update our website.

I do all of the above manually and it gets Boring :)

Also Open to suggestions if my thinking is off the scope LOL.

I have attached a 2 Sample Files. Before and After.

Thank You

Andre

Hi,

I have also added the After File for you to view.

Thank You
Andre

微软 PHP 软件构架 软件开发

项目ID: #12022976

关于项目

20个方案 远程项目 活跃的7 年前

授予:

GeniuSBraiN

Hello, I can do this task in less time, and 100% accurate - I'm an experienced software developer specialized in desktop applications, tools, and scripts. - I write programs using .NET since 2012, and using classic 更多

$80 AUD 在2天内
(20条评论)
5.2

有20名威客正在参与此工作的竞标,均价$66/小时

rinsadsl

Dear customer I have understood your project requirement. I can do this project for you. Looking forward to work with you. Thanks Rinsad

$64 AUD 在3天内
(1122条评论)
9.0
romanapanovich

Hi. I can do a WEB app for this scope. It is the same for You - You will select all files You need and then it will process all of them at the server and write results to the corresponding paths at the server. I think 更多

$90 AUD 在2天内
(29条评论)
5.8
dpune

Hi, I have more than 14 years of Excel/VBA exp and I am expert in this kind of work. Please send me after file as I do not see that attached here. I have completed more than 290 projects. Please look at 更多

$70 AUD 在3天内
(73条评论)
5.7
pcinfosolutions

Hello, I got your requirement for your work. We are having a great team of designers and developers for doing this. We expertise in Demanding Frameworks like CodeIgniter, CAKEPHP, Phalcon, Zend, Wordpress, Open Cart 更多

$77AUD 在1天里
(12条评论)
4.7
MykolaDudych

Hello, I am interested in your offer and is ready to cooperate. I have experience in writing programs for windows.

$24 AUD 在2天内
(12条评论)
4.0
ankurrpipaliya

hi there, I have read your requirements and data file. I can cover the all step you describe in bid. if you are ok with me then start discussion. thanks..

$111 AUD 在3天内
(7条评论)
3.1
vw64901vw

Been working with Excel vba for 20 years. Have written similar programs

$30 AUD 在2天内
(1条评论)
2.4
nevo1234

Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. program 1: i will create 更多

$35 AUD 在3天内
(0条评论)
0.0
quadblast

Hi I'm interested to help on this project. Currently one of my activity as a technician is to encode the data of insertion manually. I've create an ms excel vba program that gather automatically the csv file and calcu 更多

$25AUD 在1天里
(0条评论)
0.0