can i retrieve excel datas in unity

Not sure about ODBC but you can read TextAsset (which is just your .txt or .xml file) either:

• Hung as a public TextAsset field on a MonoBehaviour... just drag the txt onto it. This way lets you have the file anywhere in the project.
• Loaded from an asset bundle (bundle has to be prebuilt with the text asset in it).
• Loaded from the Resources folder. See Resources.load(). This means the file must be in a folder named Resources as documented.

No matter how you read the text asset, you can use standard .NET System.Xml or String tools to parse XML or a CSV file. There are lots of examples of both in C# on the web. We load XML configuration files from bundles this way frequently. Note that a CSV file will still have a txt extension.

One note, make sure if you use XML that your XML document does not have a BOM as it will confuse the parser. This is discussed in other posts on this forum.

Such question is resolved very easy. All that you need to is recovery excel 2007 files damaged

This item is situated to the address of http://www.excel.recoverytoolbox.com

you can use Uni-Excel Package for Read, Write, and edit excel files

https://assetstore.unity.com/packages/tools/uni-excel-47540

The most convenient way to parse an excel sheet in Unity3D is to convert it into CSV. You would beed a TextAsset field for the CSV file. Check out this link:

http://codesaying.com/unity-parse-excel-in-unity3d/

Well dear,

I don’t know whether these solutions work to retrieve your Excel data in unity or not. As I haven’t used this unity tool but I can assure you that it will definitely work to retrieve your lost Excel data. I am telling this with full surety because a few days back only I have tried the following solution to repair corrupted Excel file and successfully retrieved my Excel data.

So try it once, maybe it works for you too.