new to programming/C#: what to learn to copy files

chris cools

Hello,

i am new to programming and want to start learning with a specific project in mind.

we have excel files containing different values in the same column on different rows.

The values in this column correspond (without the file extension which is mostly ".jpg") with actual files stored in a certain directory.

Now i would like to make something where a user has an interface in which he can:

-search and select an excel file where the values are in the first column

-specify the folder in which to search for the files

-a folder where the copied files need to go

-start button to start the program

-the program needs to check in the excel file every value in the first column, take the value and ad ".jpg" and ".png"

-copy all the files found in the specified directory that are equal to : "value"&".jpg" and "value"&".png" to the other specified folder

-when it's done specify to the user : the number of files moved and the values where no corresponding files were found.

Since i have no idea where to start, what should i look into to be able to :

-read out this excel file and use these values in the programming logic.

Thank you very much!!!

grtz,

chris

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jaish Mathews8y ago
Agreed. Go with normal.
0
chris cools8y ago
It is just one excelfile at a time, with only one worksheet and only 1 column with a header and between 50 and 300 filled cells in that first column.
So i guess that parallel programming is overkill in this situation?
0
Jaish Mathews8y ago
You better to think one excel book as the least processing entity. So you process book by book. Openxml is better option as it might support processing multiple books parallely. Check parallel programming in c# too. I am also suggesting one more thing. If this process is on demand and long running, then processing can move to a background process which will invoke by using your UI application. For background process, you can use c# console application.
0
chris cools8y ago
Hello Jaish,

thank you for your answer, i will look into that!
indeed it will be local program and not a web application.

Would i need to import all the values in the excel at the same time and store them in an internal table and then peform the action for all the values?
Or rather make a loop of importing 1 value from the excel, assign it to a variable, do the action, empty the variable and then import the next value?

grtz,

Chris
0
Jaish Mathews8y ago
I hope the application has planned to run locally, not web application, but thick client. So you need to check below areas.

1. Winform applications
2, C# OpenXML for excel
3. IO operation in C#
0