- Oct 30, 2000
- 42,589
- 5
- 0
Background
I have a 2-3K data file that is to get imported into Excel for graphing.
Using C#, I have altered other worksheets in the spreadsheet to tie in data from other sources.
I can use C# to read in the data file and populate the columns.
However, the spreadsheet has no "linkage" to the raw data file.
If I manually use Excel using the data import, I knows about the data file; such that if the data file is updated, the raw data and graphs are adjusted accordingly.
Is there a way from C# to either
1) instruct Excel to load the data from the file; setting up the proper linage for later
or
2) store the raw data i the worksheet and somehow let Excel know about the data file that it should link to.
I have a 2-3K data file that is to get imported into Excel for graphing.
Using C#, I have altered other worksheets in the spreadsheet to tie in data from other sources.
I can use C# to read in the data file and populate the columns.
However, the spreadsheet has no "linkage" to the raw data file.
If I manually use Excel using the data import, I knows about the data file; such that if the data file is updated, the raw data and graphs are adjusted accordingly.
Is there a way from C# to either
1) instruct Excel to load the data from the file; setting up the proper linage for later
or
2) store the raw data i the worksheet and somehow let Excel know about the data file that it should link to.
Facebook
Twitter