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?

Regards,

Oliver

Options: ReplyQuote


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