123456789101112131415161718192021222324252627 |
- using UnityEngine;
- using System.Collections;
- using System.Collections.Generic;
- using System.Data;
- using System.Data.OleDb;
- using UnityEditor;
- [CustomEditor(typeof(ExcelExport))]
- public class EdiotExcelExport : Editor
- {
- [MenuItem("DashGame/Design Tools/ExportSignConfig")]
- public static void ExportSignConfig()
- {
- string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Assets/XlsxSource/signin_config.xls;" + "Extended Properties='Excel 8.0'";
- OleDbConnection connection = new OleDbConnection(connStr);
- connection.Open();
- DataSet dataSet = new DataSet();
- OleDbDataAdapter adapter = new OleDbDataAdapter("select * from [Sheet1$]", connection);
- adapter.Fill(dataSet);
- Debug.Log(dataSet.Tables[0].Columns);
- }
- }
|