Write 2 Simple Programs. Excel, CSV, Upload to Web server.
该项目成功由GeniuSBraiN ，以$80 AUD的价钱在2 天内完成。为像这样的项目获取免费报价
项目预算$10 - $30 AUD
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).
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.
- The New York Times
- Wall Street Journal
- Times Online