Excel Importer: any changes for MS Office 2010 needed?
we have a cfg file which is working for my colleagues with MS Office 2003, but it's not working with MS Office 2010. Do we need to change the the parameters?
e.g. currently we have statements like this:
testscript.XLSWorksheetID="Template"
testscript.XLSStartRow=8
Do we need to change the config file to values like testscript.XLSXWorksheetID="Template"
testscript.XLSXStartRow=8 or something similar?
Regards
Judith
2 answers
You might have to re-install the Interop assemblies; instructions here (https://jazz.net/wiki/bin/view/Main/RQMExcelWordImporter) under "Add-in Installation" section.
Constructs such as you mentioned should still be OK. How, exactly, is your new stuff not working?
I think no changes needed for office 2010
does the MS office 2003 and office 2010 installed on the same windows?
would you take a look at the MSO2RQM_debug.log, to see if it is a network problem and attach the log here?
Comments
Hi Hao,
MS office 2003 and MS Office 2010 are installed on the same Windows/Laptop.
Here is the content of the logfile:
26.11.2012 14:04:13:
SESSION: 26.11.2012 14:04:12
26.11.2012 14:04:13: INFO: : RQMExporter created!
26.11.2012 14:04:13: INFO: : RQMExporter Startup!
26.11.2012 14:04:13: INFO: : Mso2Rqm: Mso2Rqm instantiated
26.11.2012 14:04:14: INFO: : ExcelApplicationContext: Destroyed commands
26.11.2012 14:04:14: INFO: : ExcelApplicationContext: Created commands
11/26/2012 2:05:38 PM: ERROR: : RQMConnector: Login - Error POSTing credentials to https://henry.ihost.com:9445/qm
11/26/2012 2:05:38 PM: EXCEPTION: : Object reference not set to an instance of an object.
11/26/2012 2:05:38 PM: at Mso2Rqm_Common.RQMConnector.GetFromServer(String url)
at Mso2Rqm_Common.RQMConnector.Login(String url, String username, String password)
11/26/2012 2:35:27 PM: INFO: : ExcelApplicationContext: Destroyed commands
11/26/2012 2:35:28 PM: INFO: : ExcelApplicationContext: Destroyed commands
11/26/2012 2:35:28 PM: INFO: : Mso2Rqm Shutdown!
I hope this helps....
Hi Judith, please sure the user have the correct permission and license.
and you can restart the RQM server and have a try again.
Hi Hao,
I am having issues getting the Mso2Rqm installer to appear in Excel 2010 once it has "successfully" installed. I have checked all pre requisites and still no luck. Please advise.
Thanks.