Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Error Exception calling "SaveAs"
I am getting errors saving excel via powershell code in WFA
if any work around
$xl=New-Object -ComObject "Excel.Application"
$wb=$xl.Workbooks.Add()
#==Powershell Code for Report==
$wb.SaveAs($htmlReport,$xlHTML)
$wb.SaveAs($csvReport, $xlCSV)
$wb.SaveAs( $reportName,[Microsoft.Office.Interop.Excel.XlFileFormat]::xlExcel8)
6 REPLIES 6
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Do you have Excel installed on the WFA server?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Yes
Tested code works ok via powershell at command prompt
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
See, you have provided almost close to zero information for debugging and expecting a solution.
1. What are you actually trying to do.
2. What is the error message you get?
3. What values of variables $htmlReport,$xlHTML..
What can one make out from a few lines from the middle of the code. It will not help. So provide sufficient infomation.
If this post resolved your issue, help others by selecting ACCEPT AS SOLUTION or adding a KUDO.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Thanks sinhaa
this was for testing if I could write excel output to local drive via powershell on WFA server
The only exception I am getting from logs is
"Error Exception calling "SaveAs" "
Can we save Excel workbook on local drive ?
could be service account permission issues ,will report after testing
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Attached is a simple WFA command that you can "test" to see if you have an issue with your WFA server configuration, or if the issue is in your code. This requires an open directory at C:\Temp\WFA to run. It works on my laptop with WFA installed.
Mike
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Not sure why the dar file does not show as an attachment, unless it is being filtered out as "software files". Email me, and I will send you the attachment.
Mike Geringer
NetApp