Excel COM Help
Posted: 26 Jun 2017, 15:48
I've used the Excel COM object for reading from a worksheet before, but that's the extent of my understanding of it and I've just hit a rather more complicated project that I'm hoping someone can talk me through.
I have a CSV file that consists of a few hundred lines of simply Item#,Quantity. I also have an Excel worksheet that this information needs to go into. Basically, for each line in the CSV, I want to do the following:
1) Find the row in which the value of column E matches Item#
2) Set the value of column L in that row to Quantity
I don't know how to do either of these things with my current level of expertise. ^^;
I have a CSV file that consists of a few hundred lines of simply Item#,Quantity. I also have an Excel worksheet that this information needs to go into. Basically, for each line in the CSV, I want to do the following:
1) Find the row in which the value of column E matches Item#
2) Set the value of column L in that row to Quantity
I don't know how to do either of these things with my current level of expertise. ^^;