No tables displayed in select table dropdown on binding excel

[Rohit]

Hi,

I am using Teleric standalone version 2011.2.1117.0. After Adding any excel sheet as data source when I try to Bind that excel with any of my test, no tables are displayed in Select Table dropdown due to which I am unable to bind Excel. Please suggest the reason behind this.I I am using office 2010 on win7 64 bit machine.

[Anthony]

Hi Rohit,

The issue you're experiencing is a rare UI bug. We have yet to reproduce it locally to figure out the root cause. I can offer a few work-arounds, however, that have worked for previous customers:

• Save the file in the old Excel 97-2003 format and then using that file (.xls instead of .xlsx).
• Clear the WPF Font Cache.

Greetings,
Anthony
the Telerik team

[Catalin]

This is also reproducing to me, using Windows 10 x64 Professional  and Office 2013 Professional.

 

Any updates to this issue? It's very annoying, since I have a project which using a data source and all my bindings are there. Will be very time consuming to update each test to change the datasource(around 20-25 tests).

[Boyan Boev]

Hello Catalin,

You don't need to update each data file.

Please install this (x86) which should fix the issue.

Let me know if that helps.

Regards,
Boyan Boev
Telerik

 

[Catalin]

Hi,

 

Thank you! This worked like a charm.

 

Regards,

Catalin

[Boyan Boev]

Hello Catalin,

Happy to hear that.

Should have any additional questions please let us know.

Regards,
Boyan Boev
Telerik