EdiotExcelExport.cs 794 B

123456789101112131415161718192021222324252627
  1. using UnityEngine;
  2. using System.Collections;
  3. using System.Collections.Generic;
  4. using System.Data;
  5. using System.Data.OleDb;
  6. using UnityEditor;
  7. [CustomEditor(typeof(ExcelExport))]
  8. public class EdiotExcelExport : Editor
  9. {
  10. [MenuItem("DashGame/Design Tools/ExportSignConfig")]
  11. public static void ExportSignConfig()
  12. {
  13. string connStr = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=Assets/XlsxSource/signin_config.xls;" + "Extended Properties='Excel 8.0'";
  14. OleDbConnection connection = new OleDbConnection(connStr);
  15. connection.Open();
  16. DataSet dataSet = new DataSet();
  17. OleDbDataAdapter adapter = new OleDbDataAdapter("select * from [Sheet1$]", connection);
  18. adapter.Fill(dataSet);
  19. Debug.Log(dataSet.Tables[0].Columns);
  20. }
  21. }