DirectExcel

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

Technical Details

3.4-06/04/2025

• Add UE5.6 support

3.4-11/25/2022

• Fix bugs.

3.3-06/17/2022

• Add more check logs and fix bugs.

• Fix StartWatch trigger twice bug. Add reload strategy.

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