Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to import csv file data to already open worksheet (in C#)
Hello,
I need to import data from a csv file into a worksheet on an already opened workbook (programmatically using C#). I have been able to use the ....Workbooks.OpenText() method but it opens a new workbook. I can see that using the menu options Data/import external data/import data does the trick (and I've recorded the macro and can see what it's doing - in VBA of course). I need to know how to perform this macro task in C#. Can anyone give me a clue? Thanks! -- "If we new what we were doing, it wouldn''t be called research!" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do a import data from a text file to an excel worksheet | Excel Discussion (Misc queries) | |||
CAN I IMPORT DATA FROM A CLOSED FILE TO A NEW WORKSHEET | Excel Discussion (Misc queries) | |||
Find first blank row in worksheet to import data from txt file | Excel Discussion (Misc queries) | |||
How do I import text file, analyze data, export results, open next file | Excel Programming | |||
open file dialog-select file-import worksheet | Excel Programming |