Importing data from excel using javascript; Assembly reference error.

Questions & Answers
1

I followed the “Load Data from Excel 2003” tutorial from the Unity3D wiki and everything went oke from there. The thing is that the script there is in C#, but all my other script that I’m using is in Javascript. So I translated all of the script to Javascript… but probably not good enough. It start failing at the start where I should be loading the Excel tool.

import System; 
import System.Data; 
import System.Data.Odbc;

The following error occurs:

Namespace 'System.Data' not found, maybe you forgot to add an assembly reference?
Namespace 'System.Data.Odbc' not found, maybe you forgot to add an assembly reference?

The thing is that it works fine in C#, where I found that most people were having this problem the other way around. Anyway I added the System.Data.dll and the SystemEnterpriseServices.dll to the Assets folder.

Yes, there are a lot of other posts on this topic, but none of them gave me an answer to my problem.

Thanks

  • Danny
2

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