Lengkap

Insert file and folder name in Excel .csv columns

I need an Excel script (exe) that allow me to add to the second column the name of the file and to the third column the name of the folder in wich the file is.

For example:

1 - I have a folder named "main_folder".

2 - This folder contains 900 files .csv named: file1, file2, file3.....file900

3 - The first column of each .csv file has a variable number of items; for example file1 has 700 items (700 rows); file2 900 items, etc.

I need an executable that allow me to:

1 - select a folder (containing the .csv files); for example select the folder "main_folder" that contains 900 .csv files

2 - click on a button and fill the second column of each file with the name of the file; for example the file named "[login to view URL]" has 700 items (one for row) in the first column; I want a function that, when I press a button, fill the 700 rows of the second empty column with its name ("file1" in this case), and so on for all other 899 files.

3 - click on a second button and fill the third column of all 900 files in the folder with the name of the folder; in the previous example, when I click on the 2nd button, the function fill the rows of the third empty column with the name of the folder ("main_folder" in this case).

The script must be fast and functional with large amount of data.

Kemahiran: Pemasukan Data, Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic

Lihat lagi: open file folder excel vba, create excel csv file web page, vba import csv file sheet excel, power query add filename as column, add filename as new column in multiple csv files, add filename to csv file, merge csv files and create a column with the filename from the original file, power query multiple csv files, import multiple csv files into excel worksheets, import multiple csv files into one excel worksheet, merge multiple csv files into one excel workbook, excel csv file grapher, file convert excel csv, excel chart columns csv, insert file csv mysql command line linux, csv file graph excel, read excel csv file plsql, excel csv file format, visual insert file word excel, excel file format num csv

Tentang Majikan:
( 3 ulasan ) ROMA, Italy

ID Projek: #17033733

Dianugerahkan kepada:

rinabuoy13

dear Sir, I can write c# application to complete your task. It is scalable. Looking to hearing from you soon. Kind regards

€30 EUR dalam sehari
(86 Ulasan)
5.9

28 pekerja bebas membida secara purata €29 untuk pekerjaan ini

KulfiSoftwares

I am an excel expert. I love excel automation. Clear instructions. I can write a macro for this project. I understand the task completely and I will complete this with highest accuracy and speed. ZERO ERROR GUAR Lagi

€100 EUR dalam sehari
(310 Ulasan)
7.6
ineedWorkJob

Greetings sir, how are you today sir? hope fine. Sir, I have read your project details and i will create a windows executable file that will allow you to fill the csv column with file name and parent folder name Lagi

€30 EUR dalam sehari
(217 Ulasan)
7.0
zebracaro

I can do it for you quickly and exactly . Please contact me for saving your time and your money .

€50 EUR dalam 2 hari
(116 Ulasan)
6.6
Nidhijain123

Hello, I have read and understood what has to be done in this task. I have sound experience in performing such kind of work as I have done lot of project of similar kind in the past. I think I can assist you in ge Lagi

€23 EUR dalam sehari
(110 Ulasan)
6.1
mariushudea

Hi, I can write the tool you want in Visual Basic 6, exactly as you describe. I could also add option to create a copy of all the csv files instead of overwriting them, just to be super safe. Could also implemen Lagi

€20 EUR dalam 2 hari
(165 Ulasan)
5.4
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fourteen excel vba projects in the past seventy days. Willing to take up your project. Thank you, Regards.

€30 EUR dalam sehari
(65 Ulasan)
5.6
€30 EUR dalam 0 hari
(46 Ulasan)
5.4
dvcontact

Hi, You won’t make the right candidate selection without knowing what your project on writing Excel script that allows you to add to the second column the name of the file and to the third column the name of the folde Lagi

€30 EUR dalam sehari
(33 Ulasan)
5.5
kahilH

Hello I suggest to implement you a solution in java(exe) I can assure the best results thank you in advance

€24 EUR dalam sehari
(36 Ulasan)
5.3
huongth

Hi. I am an expert in VBA, VBScript, Visual Basic, C#, F#, C, C++, ASM, Delphi, Java, iMacros, Flash, ASP, ASP.NET, Access, MySQL, MSSQL, QuickBooks, Oracle. I can create auto scripts to scrape websites, auto click, fo Lagi

€29 EUR dalam sehari
(29 Ulasan)
4.3
€23 EUR dalam sehari
(6 Ulasan)
4.1
royalwebraisers

HI, I can help in this by creating small web based software, where you may create nay pattern for csv, Please let me know when w can discuss. Looking forward for your response. Thanks.

€34 EUR dalam sehari
(7 Ulasan)
3.5
shebrien

Hi. 2 questions: 1- What would you like the delimeter to be in your csv files? 2- While I can do the column adding the way you described it (adding to the files directly), would you prefer instead to have the result be Lagi

€30 EUR dalam sehari
(2 Ulasan)
1.6
€25 EUR dalam sehari
(4 Ulasan)
1.3
€24 EUR dalam sehari
(1 Ulasan)
1.2
prfctDATAScraper

Dear next Employer We will give you the best result by using my past experience and excellent academic skills on your project. You can chat with me and let's get started, I'm ready to show you samples of similar p Lagi

€16 EUR dalam sehari
(2 Ulasan)
0.9
€16 EUR dalam sehari
(0 Ulasan)
0.0
ali10hussien

l can do it 1 hour its very easy and fast lets do it and i have 5 years experience in data entry so i need this so much

€19 EUR dalam sehari
(0 Ulasan)
0.0
€22 EUR dalam sehari
(0 Ulasan)
0.0
cbughaw7

I am a mom with two kids. I believe that your company will help me sustain the needs of my kids. I am willing to learn everything. Thank you. Relevant Skills and Experience Inserting a file inside q cell of a spreads Lagi

€19 EUR dalam sehari
(0 Ulasan)
0.0