C# to Excel
-
Good morning, I would like to know if it is possible to use a streamwriter and write user input (string) to a specific cell in a worksheet in excel. If not a streamwriter, is there another class that might be able to do it ? Im not talking about writing comma delimeted files which you can open in excel, i want to write a string directly to an excel worksheet to a specific cell so that i can use the formulas created in it. Any help will be appreciated. Thank you.
-
Good morning, I would like to know if it is possible to use a streamwriter and write user input (string) to a specific cell in a worksheet in excel. If not a streamwriter, is there another class that might be able to do it ? Im not talking about writing comma delimeted files which you can open in excel, i want to write a string directly to an excel worksheet to a specific cell so that i can use the formulas created in it. Any help will be appreciated. Thank you.
You can control Excel via COM, and newer versions via a .NET library.
Christian Graus - Microsoft MVP - C++ Metal Musings - Rex and my new metal blog