10월 세일을 시작합니다! 10월 24일(미국 동부시간)까지 엄선된 콘텐츠를 50% 할인받으세요!

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
  • 다운로드 유형
    엔진 플러그인
    이 제품은 코드 플러그인과 함께 미리 빌드한 바이너리와 언리얼 엔진에 통합되는 모든 소스 코드를 포함하고 있으며 원하시는 엔진 버전에 설치하여 프로젝트에 따라 활성화할 수 있습니다.

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. 

기술적 세부사항

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

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.