ExcelCli 1.0.20
See the version list below for details.
dotnet tool install --global ExcelCli --version 1.0.20
dotnet new tool-manifest # if you are setting up this repo dotnet tool install --local ExcelCli --version 1.0.20
#tool dotnet:?package=ExcelCli&version=1.0.20
nuke :add-package ExcelCli --version 1.0.20
ExcelToDotnet
Nuget.org
https://www.nuget.org/packages/ExcelToDotnet/
introduce
English
Excel To Dotnet Compatible Data (Enum, Class, JSON)
It can be said to be a converter that can be used in Unity, C# applications, etc.
An Excel Sheet with a set rule is required.
In the case of Enum, only the Enum sheet must be registered. Otherwise, the sheet name becomes the class name.
In all cases, # is used as a comment (table, column, etc.).
In case of Enum, start :Begin and end point should be :End.
In the case of a table, the first row must be the column name, and the end point must be specified with :End. The second row is the data type, and it is possible to link to the Id column of another table with $.
Korean
Unity, C# 애플리케이션 등에서 사용할 수 있는 변환기라고 할 수 있습니다.
규칙이 설정된 Excel 시트가 필요합니다.
Enum의 경우 Enum 시트만 등록해야 합니다. 그렇지 않으면 시트 이름이 클래스 이름이 됩니다.
모든 경우에 #은 주석(테이블, 열 등)으로 사용됩니다.
Enum의 경우 시작 :Begin, 끝점은 :End여야 합니다.
테이블의 경우 첫 번째 행은 열 이름이어야 하며 끝점은 :End로 지정해야 합니다. 두 번째 행은 데이터 타입으로 $로 다른 테이블의 Id 컬럼과 연결이 가능 합니다.
Reserved Keyword
# (Comment)
comment or description
! (ignore)
ignore type check (Custom DataType)
% (Percent)
It should be 100 when summing the row values. dataType double
$ (Reference)
Refers to the key of the sheet (table) of the string following $. (Error if associated value does not exist
~ (SubIndex)
cleanup & generate all option.
This is a function to check for duplicates within a table using the same index by placing a secondary index.
Sample Excel (xlsx)
https://github.com/elky84/ExcelToDotnet/blob/main/ExcelCli/Character.xlsx
add package
dotnet add package ExcelToDotnet
Implment CLI. (link ExcelToDotnet)
Release: https://github.com/elky84/ExcelToDotnet/releases
Reference : https://github.com/elky84/ExcelToDotnet/blob/main/ExcelCli/Program.cs, https://github.com/elky84/ExcelToDotnet/blob/main/ExcelCli
install cli global tool
require dotnet 6 (LTS) or later (https://dotnet.microsoft.com/en-us/download)
dotnet tool install -g ExcelCli
global tool usage
execute command name is excel2dotnet
use single excel file (-f)
excel2dotnet -f {fileName}
use target directory (-d)
excel2dotnet -d {directory}
use enum generate mode (-e)
excel2dotnet -d {directory} -e
use validation mode (-v)
excel2dotnet d {directory} -v
use nullable mode (-l) ⇒ for .NET 6 or later
excel2dotnet d {directory} -l
Execute CLI options (execute build file)
execute file name excel2dotnet
instead of ExcelCli
all options
Version History
v1.0.20
- generate class to partial class
v1.0.19
- removed ignore mode
- added wide mode (cleanup & generate all option)
- fixed sub index, probability functions.
Product | Versions Compatible and additional computed target framework versions. |
---|---|
.NET | net6.0 is compatible. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed. net8.0 was computed. net8.0-android was computed. net8.0-browser was computed. net8.0-ios was computed. net8.0-maccatalyst was computed. net8.0-macos was computed. net8.0-tvos was computed. net8.0-windows was computed. |
This package has no dependencies.
Version | Downloads | Last updated |
---|---|---|
1.0.40 | 91 | 11/17/2024 |
1.0.39 | 123 | 5/29/2024 |
1.0.38 | 98 | 5/28/2024 |
1.0.36 | 228 | 12/28/2023 |
1.0.35 | 281 | 11/7/2023 |
1.0.34 | 242 | 11/7/2023 |
1.0.33 | 396 | 12/1/2022 |
1.0.32 | 408 | 10/29/2022 |
1.0.31 | 466 | 8/31/2022 |
1.0.30 | 440 | 8/24/2022 |
1.0.29 | 474 | 6/10/2022 |
1.0.27 | 438 | 6/5/2022 |
1.0.26 | 469 | 6/4/2022 |
1.0.25 | 503 | 4/21/2022 |
1.0.24 | 498 | 4/20/2022 |
1.0.23 | 519 | 4/20/2022 |
1.0.22 | 499 | 4/20/2022 |
1.0.20 | 531 | 2/21/2022 |
1.0.19 | 349 | 1/9/2022 |
1.0.18 | 318 | 1/5/2022 |
1.0.17 | 381 | 1/5/2022 |
1.0.16 | 308 | 1/5/2022 |
1.0.15 | 376 | 1/5/2022 |
1.0.14 | 329 | 1/5/2022 |
1.0.13 | 331 | 1/5/2022 |
1.0.12 | 353 | 1/5/2022 |
1.0.11 | 338 | 1/5/2022 |
1.0.10 | 363 | 1/3/2022 |
1.0.9 | 323 | 1/3/2022 |
1.0.8 | 296 | 1/3/2022 |
1.0.7 | 330 | 1/3/2022 |
1.0.6 | 335 | 1/3/2022 |
1.0.5 | 371 | 1/3/2022 |
1.0.4 | 319 | 1/3/2022 |