Write to specific cell
Hi all,
I'm looking in to writing a string into a specific cell in excel from my windows form, but so far have had no luck trawling the web.
Could anyone shed any light on this for me?
I'm using VS 2010 on windows 7.
Thanks,
AD
I'm looking in to writing a string into a specific cell in excel from my windows form, but so far have had no luck trawling the web.
Could anyone shed any light on this for me?
I'm using VS 2010 on windows 7.
Thanks,
AD
I have no idea how to directly manipulate excel files through C++ (or any other language, for that matter), but there's an "easy" workaround:
Save your output to a text file and separate each "cell" by a \t (tab). This will allow you to copy-paste your text file directly into an excel sheet.
Alternatively, you can use CSV files as lightweight excel sheets.
Save your output to a text file and separate each "cell" by a \t (tab). This will allow you to copy-paste your text file directly into an excel sheet.
Alternatively, you can use CSV files as lightweight excel sheets.
Thanks for the quick reply, Gaminic.
The problem with doing it that way is that I will have a numeric identifier on my form (1 to 100), and the string will need to be written to column C, and the equivalent row to whichever number is selected by the user.
The problem with doing it that way is that I will have a numeric identifier on my form (1 to 100), and the string will need to be written to column C, and the equivalent row to whichever number is selected by the user.
Topic archived. No new replies allowed.