Đã hoàn thành

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.

Kĩ năng: Nhập liệu, Xử lí dữ liệu, Excel, Kiến trúc phần mềm, Visual Basic

Xem nhiều hơn: 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

Về Bên Thuê:
( 3 nhận xét ) ROMA, Italy

ID dự án: #17033733

Được trao cho:

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 trong 1 ngày
(86 Đánh Giá)
5.9

28 freelancer đang chào giá trung bình €29 cho công việc này

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 Thêm

€100 EUR trong 1 ngày
(310 Nhận xét)
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 Thêm

€30 EUR trong 1 ngày
(217 Nhận xét)
7.0
zebracaro

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

€50 EUR trong 2 ngày
(116 Nhận xét)
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 Thêm

€23 EUR trong 1 ngày
(110 Nhận xét)
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 Thêm

€20 EUR trong 2 ngày
(165 Nhận xét)
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 trong 1 ngày
(65 Nhận xét)
5.6
€30 EUR trong 0 ngày
(46 Nhận xét)
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 Thêm

€30 EUR trong 1 ngày
(33 Nhận xét)
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 trong 1 ngày
(36 Nhận xét)
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 Thêm

€29 EUR trong 1 ngày
(29 Nhận xét)
4.3
€23 EUR trong 1 ngày
(6 Nhận xét)
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 trong 1 ngày
(7 Nhận xét)
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 Thêm

€30 EUR trong 1 ngày
(2 Nhận xét)
1.6
€25 EUR trong 1 ngày
(4 Nhận xét)
1.3
€24 EUR trong 1 ngày
(1 Nhận xét)
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 Thêm

€16 EUR trong 1 ngày
(2 Nhận xét)
0.9
€16 EUR trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0
€22 EUR trong 1 ngày
(0 Nhận xét)
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 Thêm

€19 EUR trong 1 ngày
(0 Nhận xét)
0.0