使用Unity导出excel表
你好! 这是你第一次使用 Markdown编辑器 所展示的欢迎页。如果你想学习如何使用Markdown编辑器, 可以仔细阅读这篇文章,了解一下Markdown的基本语法知识。
1.导入EPPlus.dll到Plguins
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.如果打包后使用报错
找到
放入所在目录