Write to existing Excel file, without having Excel installed?
Hi there,
I am looking for a function that will let me write my variables to an existing Excel file. I found one solution, but it only works on machines with Microsoft Office installed. Does anyone have a good idea to solve this?
Thank you in advance :)
Re: Write to existing Excel file, without having Excel installed?
If you want to write to an XLS file then basically you must have Excel installed so that you can use COM Interop to control an Excel instance to do the work. If you want to write to an XLSX then you can use the Open XML SDK, which is a .NET library for writing to Office 2007 and later format files.
http://www.microsoft.com/en-us/downl...s.aspx?id=5124
Re: Write to existing Excel file, without having Excel installed?
Re: Write to existing Excel file, without having Excel installed?
Hi Guys,
Thank you very much for your answers.
I can't use Com Interop, because of the need of Office, but I will take a look at the links #3 provided.
Again, thank you very much :)