使用Unity导出excel表

使用Unity导出excel表

你好！ 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Markdown编辑器, 可以仔细阅读这篇文章，了解一下Markdown的基本语法知识。

1.导入EPPlus.dll到Plguins

EPPlus.dll

2.添加脚本

using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.InteropServices;
using UnityEngine;

[StructLayout(LayoutKind.Sequential, CharSet = CharSet.Auto)]

public class OpenFileName

{

    public int structSize = 0;

    public IntPtr dlgOwner = IntPtr.Zero;

    public IntPtr instance = IntPtr.Zero;

    public String filter = null;

    public String customFilter = null;

    public int maxCustFilter = 0;

    public int filterIndex = 0;

    public String file = null;

    public int maxFile = 0;

    public String fileTitle = null;

    public int maxFileTitle = 0;

    public String initialDir = null;

    public String title = null;

    public int flags = 0;

    public short fileOffset = 0;

    public short fileExtension = 0;

    public String defExt = null;

    public IntPtr custData = IntPtr.Zero;

    public IntPtr hook = IntPtr.Zero;

    public String templateName = null;

    public IntPtr reservedPtr = IntPtr.Zero;

    public int reservedInt = 0;

    public int flagsEx = 0;

}

using System.Collections;
using System.Collections.Generic;
using System.Runtime.InteropServices;
using UnityEngine;

public class LocalDialog

{

    //链接指定系统函数 打开文件对话框

    [DllImport("Comdlg32.dll", SetLastError = true, ThrowOnUnmappableChar = true, CharSet = CharSet.Auto)]

    public static extern bool GetOpenFileName([In, Out] OpenFileName ofn);

    public static bool GetOFN([In, Out] OpenFileName ofn)

    {

        return GetOpenFileName(ofn);

    }

    //链接指定系统函数 另存为对话框

    [DllImport("Comdlg32.dll", SetLastError = true, ThrowOnUnmappableChar = true, CharSet = CharSet.Auto)]

    public static extern bool GetSaveFileName([In, Out] OpenFileName ofn);

    public static bool GetSFN([In, Out] OpenFileName ofn)

    {

        return GetSaveFileName(ofn);

    }

}

using System.Collections;
using System.Collections.Generic;
using System.IO;
using System.Runtime.InteropServices;
using OfficeOpenXml;
using UnityEngine;

public class ExcelManager{

    public static void WriteExcel(string excelName, string sheetName, Dictionary<string, Dictionary<string,string>> data)
    {
        OpenFileName openFileName = new OpenFileName();
        openFileName.structSize = Marshal.SizeOf(openFileName);
        openFileName.filter = "Excel文件(* .xlsx)\0* .xlsx";
        openFileName.file = new string(new char[256]);
        openFileName.maxFile = openFileName.file.Length;
        openFileName.fileTitle = new string(new char[64]);
        openFileName.maxFileTitle = openFileName.fileTitle.Length;
        openFileName.initialDir = Application.streamingAssetsPath.Replace(oldChar: '/', newChar: '\\');//默认路径
        openFileName.title = "窗口标题";
        openFileName.flags = 0x0080000 | 0x00001000 | 0x00000800 | 0x00000008;
        if (LocalDialog.GetSaveFileName(openFileName))
        {
            string trulyPath = openFileName.file.Substring(startIndex: 0, length: openFileName.file.Length - (openFileName.fileTitle.Length + 1));
            FileInfo newFile = new FileInfo(trulyPath);
            newFile = new FileInfo(fileName: openFileName.file + ".xlsx");
            if (newFile.Exists)
            {
                //如果已有该文件则覆盖
                newFile.Delete();
            }

            //通过ExcelPackage打开文件
            using (ExcelPackage package = new ExcelPackage(newFile))
            {
                //在excel空文件添加新sheet
                ExcelWorksheet worksheet = package.Workbook.Worksheets.Add(sheetName);
                List<string> keyArray = new List<string>(data.Keys);

                for (int i = 0; i < keyArray.Count; i++)
                {
                    List<string> array = new List<string>();
                    Dictionary<string, string> dict = data[keyArray[i]];
                    foreach (var item in dict)
                    {
                        array.Add(item.Key);
                        array.Add(item.Value);

                    }
                    worksheet.Cells[i + 1, 1].Value = keyArray[i];
                    for (int j = 0; j < array.Count; j++)
                    {
                        worksheet.Cells[i + 1, j + 2].Value = array[j];
                    }
                }
                package.Save();
                System.Diagnostics.Process.Start(trulyPath);
            }
        }
    }
}

3.使用

4.如果打包后使用报错

找到

放入所在目录