DirectExcel

JianzhaoFu - 2018/06/22

This plugin provides you with Blueprints and C++ to read & write Excel.xslx file data directly.

  • サポートされたプラットフォーム
  • サポートされたエンジンバージョン
    4.20 - 4.27
  • ダウンロードのタイプ
    エンジン プラグイン
    この製品には、コード プラグインが含まれており、ビルド済みのバイナリと Unreal Engine に統合される全ソースコードが完備されています。任意のエンジン バージョンにインストールし、プロジェクト毎に有効化することが可能です。

Preview: https://youtu.be/HHJsgH5NM_k

ExampleProject: https://github.com/fjz13/DirectExcelExample

Include C++ Source!

Easy to port to other platforms!


This plugin provides you with Blueprints and C++ to read & write Excel.xslx file data directly. 

Unlike UE has to import CSV as datatables to use excel data, it's super convenient to read excel sheets directly. Pushing a bit further, it's more efficient to sync excel data to UE automatically whenever excel file changed. 


Features:

  • Read/Write Excel file 
  • Read/Add/Remove/Copy excel sheets
  • Get/Set cell's value
  • Supported Types: bool, int, float, string, date
  • Watching excel file changed to notify events to reload game logic
  • Easy to use. >100 Blueprint nodes.
  • Read and write excel cell's appearance, like font, format...
  • Use whole excel file as Data Registry source
  • Read row items as a Struct item

Supported Platforms: Win64, Android, Mac, IOS

Example Project: https://github.com/fjz13/DirectExcelExample

Excel format:

  • Excel-style Workbook
  • LibreOffice-style Workbook
  • Numbers-style Workbook
  • Encrypted Workbook (Excel 2007-2010)
  • Encrypted Workbook (Excel 2013-2016)
  • Document Properties
  • Numeric Cell Values
  • Inline String Cell Values
  • Shared String Cell Values
  • Shared String Text Run Formatting (e.g. varied fonts within a cell)
  • Comments

Feel free to tell me(fjz13@live.cn) which features you need, they'll be added soon.

テクニカルノート

3.1-2021.11-11

  • Add ReadItem support, now you can read/write FVector/FRotator/FColor/FTransform/FMatrix……and even TArray/TSet/TMap from/into a single cell!

3.0-2021.08.24(a big change)

  • Add UE4.27 support
  • Add "Data Registry" support, see the last picture
  • Allow ExcelWorksheet to create a DataTable object for querying (need set table header at first)
  • Add some useful nodes, such as "ReadStructAtRowIndex"(convert one row's data to a struct item)
  • Fix bugs.

2.0-2021.01.06

2.0-2020.12.7

2.0-2019.4.8

1.5-2019.3.25

1.4-2019.2.15

1.3-2018.10.29

Feel free to tell me(fjz13@live.cn) which features you need, they'll be added soon.