Automatically delete rows in several Excel-files according to user choice ("batch mode")
$250-750 USD
Pagado a la entrega
I have a couple of excel files in one folder carrying time sequence data. Every file has only one sheet and it carries the names of the columns in the first row. Data starts from row 2 and can be several thousands of rows = data points. Task is to delete sequences of consecutive rows and keep others - according to user specifications which rows to keep and which to delete.
Task
Part I. Get information from user (either via dialog/ UserForm or anything you like) how to proceed with the data:
a) user specifies input folder (that's where the excel files are)
b) user specifies output folder (that's where the processed files go)
c) user specifies sequences = row numbers which indicate the "end" of each time sequence (the user should be able to specify up to 15 row numbers, which mark the borders between sequences (eg. 2 (beginning of data), 15 (=end of first sequence), 2.345 (= end of second sequence), 2.453 (= end of third sequence), 5.347 (end of 4th sequence), 10.453 (end of 5th sequence), etc. -> this means sequence 1 goes from row 2 to 14, sequence 2 goes from row 15 to 2.344, sequence 3 goes from 2.345 to 5.346, sequence 4 goes from 5.347 to 10.452, etc.
d) specify what to do with each defined sequence of rows (k = keep; d = delete)
Part II Procedure
For every file in specified folder
a1) Look for column named "Bemerkung" (or other, specified in advance by user)
a2) Delete (crop) all rows beginning from row 2 until first value starting with "Video" (or other specified in advance by user) is found in column "Bemerkung"
a3) Look for last value starting with "Video" found in column "Bemerkung" and delete all rows starting from this row to last row
b) Insert sequence numbers in column "Bemerkung" as specified by user (see Part I.)
c) If sequence is specified as "k" by user (see Part I.) keep all rows of this sequence. If sequence is specified as "d" by user (see part I.) delete all rows of this sequence
d) save processed excel file in target folder
Part III Putting Excel Files together
Merge all the columns of the different excel-files in the target folder together in one new excel file and save this file.
Nº del proyecto: #10143439
Sobre el proyecto
Adjudicado a:
Hi. I'm a MSc Computer Science with several years of experience in software development. For this project I propose to use a python script to process the excel files with a simple text interface. I can complete your pr Más
18 freelancers están ofertando un promedio de $368 por este trabajo
Hi, That is an exiting project. I have a program ready to perform the job. Please contact me for further details of your project. Thanks!
Dear sir I 'm very ambicious, hardworker and honest person, with developed sense for organizing and coordination with other persons. I work according to instruction from employer and if i have some sugestion allway Más
Hi, I work in admin support and I am accountant. I work frequently with product files ( for instance Ebay product files ). This project is within my working duties. Have a look at my previous jobs to prove my c Más
Sir, I have the honor to apply for this online opportunity you have made available. I’m a diligent, detail and well oriented applicant. I'm applying for this job because of my experience obtained on web search, d Más
HELLO------ I am a professional software and Game developer having 10+ years experince , Also i can help you in this project , I am waiting for your valuable Ping My expertise in web development areas are listed Más
hi there! please do have time to visit my profile and hire me. I am so familiar with microsoft excel. Rest assure that I will submit finished project on or before the deadline.