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:
( 2 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
(65 Ulasan)
5.4

29 pekerja bebas membida secara purata €28 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
(264 Ulasan)
7.4
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
(213 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
(105 Ulasan)
6.5
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
(99 Ulasan)
5.9
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
(35 Ulasan)
5.2
€30 EUR dalam 0 hari
(44 Ulasan)
5.4
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
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
(28 Ulasan)
5.3
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
(32 Ulasan)
5.1
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
(28 Ulasan)
4.3
€23 EUR dalam sehari
(3 Ulasan)
3.5
€23 EUR dalam sehari
(7 Ulasan)
3.9
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
(4 Ulasan)
2.6
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
€16 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
€22 EUR dalam sehari
(0 Ulasan)
0.0
€23 EUR dalam sehari
(0 Ulasan)
0.0