RQMExcelImporter - Providing a dynamic value for the excel worksheet
Currently, I'm using this line of code : (RQM 3.0.1)
testscript.XLSWorksheetID="WorkRequest"
Here "WorkRequest" is the name of the tab in the excel sheet. Now, this value has been hard-coded. I do not want this value to be hard-coded. As in, I need the value for this property which I can dynamically assign
i.e ; if I need to import the data from sheet2 of the excel sheet, I do not provide hardcoded values in this property. Instead, I provide a value which can be used for different RQM artifacts which need to be imported.
How can this be achieved ?
Thanks in advance
One answer
if you don't define a XLSWorksheetID then Excel Importer will migrate all the none blank excel sheets to RQM,
you can try to not specify the worksheet to have a try.
Comments
Hi
Thanks for your reply.
Here is the requirement that I was looking out forL
Say, there are multiple excel files (say 5 excel files) . The first
worksheet in all these excel files contain the relevant data that is
intended to be imported into RQM.
I'm creating a single configuration file which can be made used to read the data from the first worksheet from all the 5 excel files (so total of 5 first excel worksheets)
Hence making the worksheetID (testscript.XLSWorksheetID="ExcelWorkSheetName""
) to be kept dynamic which can read the first worksheet from all the
excel files automatically
Is there a way to achieve this ?
Hi Rajesh,
if you are using Excel Importer 4.0.1, and the 1st excel sheet for the 5 excel names are
"sheet11", "sheet21", "sheet31", "sheet41", "sheet51"
you can have a try with the following config
testscript.XLSWorksheetID="sheet11" : "sheet21" : "sheet31" : "sheet41" : "sheet51"
Hi Hao
Thanks for your input.
How can we achieve the same under RQM 3.0.1 ?
Will the same concept work under RQM 3.0.1 ??
Thanks again
Hi Rajesh,
I think you can have a try with Excel Importer 4.0.1 to export to RQM 3.x server for testscript, as it is capatible for most of the attributes.
Hi Hao