It's all about the answers!

Ask a question

RQMExcelImporter - Providing a dynamic value for the excel worksheet


Rajesh Avanthi (10815145173) | asked Oct 31 '12, 12:04 a.m.
Hi

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



permanent link
Hao Wan (1.5k35) | answered Oct 31 '12, 4:47 a.m.
JAZZ DEVELOPER
Hi Rajesh,
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
Rajesh Avanthi commented Oct 31 '12, 8:07 a.m.

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 ?



Hao Wan commented Oct 31 '12, 9:08 a.m.
JAZZ DEVELOPER

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"


Rajesh Avanthi commented Nov 03 '12, 12:05 a.m.

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


Hao Wan commented Nov 03 '12, 7:52 a.m.
JAZZ DEVELOPER

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.


Rajesh Avanthi commented Nov 06 '12, 5:34 a.m.

 Hi Hao


I was wondering if there is an option to provide a single variable name within the configuration file which would automatically pull the first worksheet from all the excel files ?

Any inputs on this please ?

Your answer


Register or to post your answer.


Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.