Batch operations on Excel files

In Bearbeitung Veröffentlicht Apr 20, 2012 Bezahlt bei Lieferung
In Bearbeitung Bezahlt bei Lieferung

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 Programmierung C# Programmierung Java JavaScript Visual Basic Visual Basic für Apps Windows Desktop

Projekt-ID: #2733839

Über das Projekt

21 Vorschläge Remote Projekt Aktiv Apr 27, 2012

21 Freelancer bieten im Durchschnitt $87 für diesen Job

chriskerpini

See private message.

$100.3 USD in 5 Tagen
(62 Bewertungen)
6.3
LogixSmith

See private message.

$102 USD in 5 Tagen
(37 Bewertungen)
5.9
talkwaqar

See private message.

$100.3 USD in 5 Tagen
(25 Bewertungen)
5.2
DenisSmolentsev

See private message.

$102 USD in 5 Tagen
(40 Bewertungen)
4.5
gatsu58

See private message.

$42.5 USD in 5 Tagen
(68 Bewertungen)
4.6
Lotusdeveloper

See private message.

$93.5 USD in 5 Tagen
(30 Bewertungen)
4.4
excel4engineers

See private message.

$84.8 USD in 5 Tagen
(20 Bewertungen)
3.9
khalid346

See private message.

$90.1 USD in 5 Tagen
(5 Bewertungen)
3.7
DaveWM

See private message.

$100.3 USD in 5 Tagen
(1 Bewertung)
1.6
JimmSlimm

See private message.

$70.55 USD in 5 Tagen
(1 Bewertung)
0.0
jonceejay

See private message.

$50.15 USD in 5 Tagen
(0 Bewertungen)
0.0
baharalivw

See private message.

$80.75 USD in 5 Tagen
(0 Bewertungen)
0.0
parama4uvw

See private message.

$80.75 USD in 5 Tagen
(1 Bewertung)
0.0
manojks029

See private message.

$100.3 USD in 5 Tagen
(0 Bewertungen)
0.0
janetlhazen

See private message.

$102 USD in 5 Tagen
(0 Bewertungen)
0.0
anumitru

See private message.

$84.15 USD in 5 Tagen
(0 Bewertungen)
0.0
lokeshk9936

See private message.

$102 USD in 5 Tagen
(0 Bewertungen)
0.0
risingsolut

See private message.

$102 USD in 5 Tagen
(0 Bewertungen)
0.0
gulapavw

See private message.

$76.5 USD in 5 Tagen
(0 Bewertungen)
0.0
OnlinemediaSu

See private message.

$85 USD in 5 Tagen
(0 Bewertungen)
0.0