实现效果:
using UnityEngine;
using System.Collections;
using System;
using System.Runtime.InteropServices;
[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;
}
public class DllTest
{
[DllImport("Comdlg32.dll", SetLastError = true, ThrowOnUnmappableChar = true, CharSet = CharSet.Auto)]
public static extern bool GetOpenFileName([In, Out] OpenFileName ofn);
public static bool GetOpenFileName1([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 GetSaveFileName1([In, Out] OpenFileName ofn)
{
return GetSaveFileName(ofn);
}
}
调用代码如下:
using System;
using System.Collections;
using System.Collections.Generic;
using System.Runtime.InteropServices;
using UnityEngine;
using UnityEngine.UI;
public class Test : MonoBehaviour
{
public Button button;
private void Start()
{
button.onClick.AddListener(OpenWindowsDialog);
}
private void OpenWindowsDialog()
{
OpenFileName ofn = new OpenFileName();
ofn.structSize = Marshal.SizeOf(ofn);
//ofn.filter = "All Files\0*.*\0\0";
//ofn.filter = "Image Files(*.jpg;*.png)\0*.jpg;*.png\0";
//ofn.filter = "Txt Files(*.txt)\0*.txt\0";
//ofn.filter = "Word Files(*.docx)\0*.docx\0";
//ofn.filter = "Word Files(*.doc)\0*.doc\0";
//ofn.filter = "Word Files(*.doc:*.docx)\0*.doc:*.docx\0";
//ofn.filter = "Excel Files(*.xls)\0*.xls\0";
ofn.filter = "Excel Files(*.xlsx)\0*.xlsx\0"; //指定打开格式
//ofn.filter = "Excel Files(*.xls:*.xlsx)\0*.xls:*.xlsx\0";
//ofn.filter = "Excel Files(*.xlsx:*.xls)\0*.xlsx:*.xls\0";
ofn.file = new string(new char[256]);
ofn.maxFile = ofn.file.Length;
ofn.fileTitle = new string(new char[64]);
ofn.maxFileTitle = ofn.fileTitle.Length;
ofn.initialDir = UnityEngine.Application.dataPath;//默认路径
ofn.title = "打开Excel";
ofn.defExt = "xlsx";
//注意 一下项目不一定要全选 但是0x00000008项不要缺少
ofn.flags = 0x00080000 | 0x00001000 | 0x00000800 | 0x00000200 | 0x00000008;//OFN_EXPLORER|OFN_FILEMUSTEXIST|OFN_PATHMUSTEXIST| OFN_ALLOWMULTISELECT|OFN_NOCHANGEDIR
//打开windows框
if (DllTest.GetSaveFileName(ofn))
{
//TODO
}
}
}
当然一般我们会选择文件然后进行操作,下一篇会讲如何读取Excle表格