MySQL Forums
Forum List  »  MySQL for Excel

Re: Error on refresh data
Posted by: Oliver Busa
Date: January 10, 2018 03:06AM

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?



Options: ReplyQuote

Written By
December 13, 2017 07:50AM
January 09, 2018 06:36PM
Re: Error on refresh data
January 10, 2018 03:06AM
January 15, 2018 12:37PM
January 24, 2018 09:55AM
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.