Automatically delete rows in several Excel-files according to user choice ("batch mode")

Completado Publicado hace 7 años Pagado a la entrega
Completado 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.

Procesamiento de datos Administración de bases de datos Excel SO Mac Arquitectura de software

Nº del proyecto: #10143439

Sobre el proyecto

18 propuestas Proyecto remoto Activo hace 7 años

Adjudicado a:

Dutchstudent7750

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

$250 USD en 4 días
(4 comentarios)
3.3

18 freelancers están ofertando un promedio de $368 por este trabajo

zExcel

Hi, I'll be happy to help you with this project . I have plenty of experience in all aspects of Microsoft Excel, especially in developing custom functions and macros and can complete the job rather quick;y. You're w Más

$340 USD en 3 días
(247 comentarios)
7.5
kevivu

Dear Sir, Done numerous similar projects in the past and always impressed the clients with my excellent VBA solutions. Out of my 70 projects, almost 65+ are complex VB/VBA/.Net/Webscrapping projects, hence i ca Más

$250 USD en 3 días
(64 comentarios)
5.6
zebracaro

I can do it for you quickly and exactly .

$300 USD en 5 días
(53 comentarios)
5.2
hmshafeeq

Hi, I am an experienced software developer having great expertise in making such applications. I have read the description of this project carefully and i am interested in it. I would like to give you reference of one Más

$277 USD en 10 días
(11 comentarios)
4.6
vlayausa

Hello, thank you for very detailed description of the project. I am interested in helping you with it. All your requirements sound familiar to me, those are all things I have done before. I have a lot of experi Más

$300 USD en 5 días
(31 comentarios)
4.3
jnekam

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!

$555 USD en 5 días
(10 comentarios)
3.8
sheikDev

Hello, This can be for easily in .Net and deliver as a desktop application. I'm already done of automation processing of excel files and generate the output format. I will show the sample work if required. I'm over 8 Más

$250 USD en 3 días
(5 comentarios)
2.8
jasmindz1ob

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

$250 USD en 10 días
(1 comentario)
2.6
kusnierzova

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

$277 USD en 10 días
(2 comentarios)
1.8
lkhelladi

hello, I'd be glad to do this program for you. i propose to implement it with python which is a very powerfull language for file input/output operations. Looking forward to chat with you soon for more details. Más

$250 USD en 5 días
(1 comentario)
1.4
mokakek2008

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

$555 USD en 10 días
(0 comentarios)
0.0
Projectssss

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

$555 USD en 10 días
(0 comentarios)
0.0
Gennylyn3

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.

$555 USD en 3 días
(0 comentarios)
0.0