Thread: Excel moving data between excel workbooks

Hi,

For a storage system I need to transfer data from a .csv file (info from a scanner) to two different excel files, one with the entire storage, the other for projects. I need to register how much I take for a project and update the storage file. The .csv file contains "project number", "User", "Product number", "Quantity", "Date and time". I want to transfer the project number, product number and quantity to the project file, and collect product info from the storage file to the project file. Then I want to update existing values in the storage file to register how much is taken/put back.

Does anyone have any idea?

I have tried writing something in eclipse with Apache POI and Apache commons csv installed, but I am not good enough in programming yet.

Any help is greately appreciated. If only just a thought.

Originally Posted by Norm

What have you tried? The Apache packages will help with reading and writing the csv files.
If the csv files don't have quoted fields with embedded commas or newline characters, the files could be read and written as text without using the Apache packages. The String class's split method would separate the fields.

The .csv file looks like this:
1318,"RAS","1345087_1",25,2/16/2018 8:40:29 AM
1318,"RAS","1345091_1",96,2/16/2018 8:40:36 AM
1318,"RAS","1265200_1",25,2/16/2018 8:40:41 AM
1318,"RAS","1265202_1",1,2/16/2018 8:40:46 AM
1318,"RAS","1265165_1",10,2/16/2018 8:40:50 AM
1318,"RAS","1265170_1",2,2/16/2018 8:41:49 AM
1318,"RAS","444019_1",12,2/16/2018 8:41:54 AM