2,187
edits
Difference between revisions of "Excel (PowerShell)"
Jump to navigation
Jump to search
m
→Limitations: Minor reword
(Added Limitations and Save workaround) |
m (→Limitations: Minor reword) |
||
| Line 6: | Line 6: | ||
= Limitations = | = Limitations = | ||
Microsoft Office applications are not built for background automation. It can be achieved, but there are some gotchas. Most notably when it comes to scheduling automation to run outside of an interactive user session. Which means you spend time crafting a wonderful that creates a beautifully formatted spreadsheet | Microsoft Office applications are not built for background automation. It can be achieved, but there are some gotchas. Most notably when it comes to scheduling automation to run outside of an interactive user session. Which means you spend time crafting a wonderful script that creates a beautifully formatted spreadsheet; but which fails to complete properly when run as a scheduled task when you're not logged into the machine its running from. It also means that every once in a [https://www.wikipedia.org/wiki/Blue_moon blue moon], it can still fail for no obvious reason. | ||
* See [http://support.microsoft.com/kb/257757 MS KB 257757 - Considerations for server-side Automation of Office] for further info. | * See [http://support.microsoft.com/kb/257757 MS KB 257757 - Considerations for server-side Automation of Office] for further info. | ||