I'm successfully reading data from an Excel file using the Excel Reader. However, as soon as the read is done, the file Excel seems to be corrupted and I can no longer open it (programatically or by hand).
Any ideas what is going on?
The parent ExcelDoc:
Rule okToOverwrite? As Boolean = False
Rule OutputDocPath As String = ProjectLocation() + "\DocumentComponents\Specifications\"
Rule OutputDocument As String = TemplateDocPath + TemplateFileName
Rule OutputFileName As String = "CP UI Specification.xlsx"
Rule SaveAsFormat As String = "Excel"
Rule ShowReport? As Boolean = False
Rule TemplateDocPath As String = ProjectLocation() + "\DocumentComponents\Specifications\"
Rule templateDocument As String = TemplateDocPath + TemplateFileName
Rule TemplateFileName As String = "CP UI Specification.xlsx"
The child ExcelDataReader:
Parameter Rule Row As Integer = 1
Rule ReadRange As String = "A" + stringValue(Row) + ":I" + stringValue(Row)
Rule Sheet As String = "Mapping"
Rule Range = ReadRange
Rule DependentParts As List = {}
From the information given, we don't know what is going on. Can you submit a defect with a replicable case?