Excel Lookup options

Question

 

I got 2 excel workbook where one is full of information’s about orders and other one I am adding some information which then fetch info from first workbook and appends the rows. If the row count reaches to 20 it should save that data in CSV file and start with another one for next value after that.

Can someone help me on how to archive this?

Answer 1

How did you try doing it? Basically you need to read the first workbook row by row and append data in another workbook. You can use Excel Interop or OLEDB to read Excel data. Here's one example of using Excel Interop. And here's one using OLEDB.

---

Click the 'Vote as Helpful' arrow if this post was helpful.

Answer 2

Supplement to Abhimanyu's reply:  to save workbook data as CSV, you can call Workbook.SaveAs, fileformat = XLFileFormat.xlCSV

Then start new workbook receive the data.

best regards,

---

Forrest Guo | MSDN Community Support | Feedback to manager