|
 |
On 26/06/2013 8:36 PM, Orchid Win7 v1 wrote:
> It's easy enough to open Excel programmatically; what isn't obvious is
> how to make it run code once it opens up. (Indeed, these days that tends
> to be exactly the sort of thing Excel blocks to prevent macro viruses...)
http://office.microsoft.com/en-gb/excel-help/running-a-macro-when-excel-starts-HA001034628.aspx
--
Regards
Stephen
Post a reply to this message
|
|
|
|
> Actually this is Haskell. But if it isn't too difficult, I could write
> some C# to actually graph the data once it's in a CSV file...
Seems a bit of an overkill if you don't already have a C# app running.
If you don't mind it being in Excel then that would be the easiest way
to go, as already discussed here. Haskell writes CSV to known file,
fires up a "template" Excel file that has an onload macro to import the
csv. You might also want to reset the filename so the user doesn't
accidentally overwrite your template.
If you don't want to use macros then you could use COM to open up the
Excel file and then put the data directly into the Excel file (rather
than writing it to a csv first). Don't know if this is possible in
Haskell, in C# something like this will work:
Excel.Application app = new Excel.Application();
app.Workbooks.Open(@"C:\tem### [at] e xls")
app.Cells[5,5] = 500
...
Post a reply to this message
|
|
