Batch operations on Excel files

В роботі Опубліковано %project.relative_time Оплачується при отриманні
В роботі Оплачується при отриманні

I would like to do some 'coloring' of Excel columns based on certain criteria, as well as some multiple sortings etc.

Please read the short yet detailed description.

## Deliverables

I am working on Excel files and have been wasting considerable time 'coloring' the columns of these Excel files based on certain criteria, not for fun, of course, but because I need to color them to perform some special sortings there afterwards.

What I would like to do is 'automate' that i.e designate columns, say column AE, then designate conditions for it 'i.e. all contents less than 0', or 'all contents equal to 1' or 'all contents greater than A and smaller than B' etc etc and finally choose a color in Excel to color each with.

Note: You must also include a 'flag' (let's say checkbox) Inclusive/Non-Inclusive for the arithmetic values I will be inputting.

I will be able to input conditions for multiple columns, one by one, and all will be executed together when the program runs.

This will be a program with 'default settings memory' i.e. I am doing this to multiple files every day, so I will run the program many times daily without having to re-designate colors, conditions etc (i.e. 'rules') every time.

There will also be a function 'Copy in Column This the colors (or values, I will be able to designate which or even BOTH) of column That'.

Furthermore there will also be a command 'erase all rows whose value on column <this> will equal (or non-equal) <that>'.

Lastly I specify a multiple sorting criteria in Excel as a 'bundle', like

Sort column J Values Largest-to-Shortest and

Sort column V Cell Color (this color) on top and

Sort column AH Values 'Smallest-to-Largest'

In order to do that, I have to open all my Excel files one by one and perform that sorting. From now on I wish to do it from 'outside' Excel in this new program, by defining the conditions there, selecting an .xlsx file, pressing some 'sort' button and have it done.

Note: If some column - say column AH in the above example - contains special characters, like '-' or 'Just' or whatever, Excel's specifications shall be observed, i.e. the special characters will be on top, and then the numerics will follow. For example, try to sort column AH as Largest-To-Smallest in '[login to view URL]' of my attached files and you shall see what I mean.

All aforementioned processes will be performed either on a single Excel file - as I mentioned so far - which I will designate with some 'Browse' button OR on a _folder_ containing many Excels like this, one after the other. In other words, I will be able to designate a folder instead of a single file and everything will be performed on this folder's contents, one by one, as 'batch' processing.

The User Interface should be straightforward to use. The program must run on any Windows XP operating environment or above. I would prefer an .exe file, mainly for speed purposes, but perhaps a VBA one will do as well.

I am attaching a sample Excel like the ones I am using every day in order for you to inspect it, if you wish, both with as well as without colors and sortings.

.NET Програмування на С Програмування на C# Java JavaScript Visual Basic Visual Basic для додатків Робочій стіл Windows

ID Проекту: #2733839

Про проект

21 заявок(-ки) Дистанційний проект Остання активність Apr 27, 2012

21 фрілансерів(-и) готові виконати цю роботу у середньому за $87

chriskerpini

See private message.

$100.3 USD за 5 дні(-в)
(62 відгуків(и))
6.3
LogixSmith

See private message.

$102 USD за 5 дні(-в)
(37 відгуків(и))
5.9
talkwaqar

See private message.

$100.3 USD за 5 дні(-в)
(25 відгуків(и))
5.2
DenisSmolentsev

See private message.

$102 USD за 5 дні(-в)
(40 відгуків(и))
4.5
gatsu58

See private message.

$42.5 USD за 5 дні(-в)
(68 відгуків(и))
4.6
Lotusdeveloper

See private message.

$93.5 USD за 5 дні(-в)
(30 відгуків(и))
4.4
excel4engineers

See private message.

$84.8 USD за 5 дні(-в)
(20 відгуків(и))
3.9
khalid346

See private message.

$90.1 USD за 5 дні(-в)
(5 відгуків(и))
3.7
DaveWM

See private message.

$100.3 USD за 5 дні(-в)
(1 відгук)
1.6
JimmSlimm

See private message.

$70.55 USD за 5 дні(-в)
(1 відгук)
0.0
jonceejay

See private message.

$50.15 USD за 5 дні(-в)
(0 відгуків(и))
0.0
baharalivw

See private message.

$80.75 USD за 5 дні(-в)
(0 відгуків(и))
0.0
parama4uvw

See private message.

$80.75 USD за 5 дні(-в)
(1 відгук)
0.0
manojks029

See private message.

$100.3 USD за 5 дні(-в)
(0 відгуків(и))
0.0
janetlhazen

See private message.

$102 USD за 5 дні(-в)
(0 відгуків(и))
0.0
anumitru

See private message.

$84.15 USD за 5 дні(-в)
(0 відгуків(и))
0.0
lokeshk9936

See private message.

$102 USD за 5 дні(-в)
(0 відгуків(и))
0.0
risingsolut

See private message.

$102 USD за 5 дні(-в)
(0 відгуків(и))
0.0
gulapavw

See private message.

$76.5 USD за 5 дні(-в)
(0 відгуків(и))
0.0
OnlinemediaSu

See private message.

$85 USD за 5 дні(-в)
(0 відгуків(и))
0.0