Hi,
All these points are ok:
- execution of the script with the QS service account
- Excel on the QS server
- Single node configuration
I also tested the execution of the script on my computer, via QS Desktop, and it's ok.
When I run the script below via external tasks, the txt file is created, but not the Excel file.
Sorry but I am not comfortable with the powershell scripting, where can I add the instructions to log?
Thanks a lot!
#Define locations and delimiter
$csv = "C:\_Consultants\ARY\PS1\conversionexcel.csv" #Location of the source file
$xlsx = "C:\_Consultants\ARY\PS1\conversionexcel.xlsx" #Desired location of output
$delimiter = ";" #Specify the delimiter used in the file
# Create a new Excel workbook with one empty sheet
$excel = New-Object -ComObject excel.application
$workbook = $excel.Workbooks.Add(1)
$worksheet = $workbook.worksheets.Item(1)
# Build the QueryTables.Add command and reformat the data
$TxtConnector = ("TEXT;" + $csv)
$Connector = $worksheet.QueryTables.add($TxtConnector,$worksheet.Range("A1"))
$query = $worksheet.QueryTables.item($Connector.name)
$query.TextFileOtherDelimiter = $delimiter
$query.TextFileParseType = 1
$query.TextFileColumnDataTypes = ,1 * $worksheet.Cells.Columns.Count
$query.AdjustColumnWidth = 1
# Execute & delete the import query
$query.Refresh()
$query.Delete()
# Save & close the Workbook as XLSX.
$workbook.SaveAs($xlsx,51)
$excel.Quit()
Out-File -FilePath "C:\_Consultants\ARY\PS1\test.txt"
