Re: Error on refresh data
Dear Javier,
Thanks for the feedback.
Indeed I think it is a bug and I might found the issue yesterday.
It seems to be related to renaming of Excel sheets after import of data. I was able to fix the connection by renaming the sheet back to it's original name. I noticed strange entries within the xml content of the xlsx-file located in .\customXml\ comparing working and non-working sheets.
By modifying the XML attributes WorkbookName= and WorksheetName= of the element <ArrayOfImportConnectionInfo> it worked as well.
It looks like that those values are not updated if renaming occurs in Excel.
Are these the values where you store the data now?
Does this sounds reasonable?
Regards,
Oliver
Subject
Views
Written By
Posted
1306
December 13, 2017 07:50AM
734
January 09, 2018 06:36PM
Re: Error on refresh data
734
January 10, 2018 03:06AM
696
January 15, 2018 12:37PM
746
January 24, 2018 09:55AM
646
January 25, 2018 10:57AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.