Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
MIT License
Import and export general library, support Dto import and export, template export, fancy export and dynamic export, support Excel, Csv, Word, Pdf and Html.
For details, see: https://dev.azure.com/xinlaiopencode/Magicodes.IE/_build?definitionId=4&_a=summary
See below for other tutorials or unit tests
See below for update history.
[Fact(DisplayName = "DTO export supports dynamic types")]
public async Task ExportAsByteArraySupportDynamicType_Test()
{
IExporter exporter = new ExcelExporter();
var filePath = GetTestFilePath($"{nameof(ExportAsByteArraySupportDynamicType_Test)}.xlsx");
DeleteFile(filePath);
var source = GenFu.GenFu.ListOf<ExportTestDataWithAttrs>();
string fields = "text,number,name";
var shapedData = source.ShapeData(fields) as ICollection<ExpandoObject>;
var result = await exporter.ExportAsByteArray<ExpandoObject>(shapedData);
result.ShouldNotBeNull();
result.Length.ShouldBeGreaterThan(0);
File.WriteAllBytes(filePath, result);
File.Exists(filePath).ShouldBeTrue();
}
/// <summary>
/// Gender
/// </summary>
[ImporterHeader(Name = "Gender")]
[Required(ErrorMessage = "Gender cannot be empty.")]
[ValueMapping(text: "Male", 0)]
[ValueMapping(text: "Female", 1)]
public Genders Gender { get; set; }
Support the generation of imported data verification items of enumeration and Bool type, and related data conversion
Enumeration will automatically obtain the description, display name, name and value of the enumeration by default to generate data items
/// <summary>
/// Student Status
/// </summary>
public enum StudentStatus
{
/// <summary>
/// Normal
/// </summary>
[Display(Name = "正常")]
Normal = 0,
/// <summary>
/// Pupils away
/// </summary>
[Description("流水")]
PupilsAway = 1,
/// <summary>
/// Suspension
/// </summary>
[Display(Name = "休学")]
Suspension = 2,
/// <summary>
/// Work-study
/// </summary>
[Display(Name = "勤工俭学")]
WorkStudy = 3,
/// <summary>
/// Internships
/// </summary>
[Display(Name = "顶岗实习")]
PostPractice = 4,
/// <summary>
/// Graduate
/// </summary>
[Display(Name = "毕业")]
Graduation = 5,
/// <summary>
/// Join the army
/// </summary>
[Display(Name = "参军")]
JoinTheArmy = 6,
}
The bool type will generate "yes" and "no" data items by default
If custom value mapping has been set, no default options will be generated
Support excel multi-sheet import
Support Excel template export, and support image rendering
The rendering syntax is as follows:
{{Company}} //Cell rendering
{{Table>>BookInfos|RowNo}} //Table rendering start syntax
{{Remark|>>Table}}//Table rendering end syntax
{{Image::ImageUrl?Width=50&Height=120&Alt=404}} //Picture rendering
{{Image::ImageUrl?w=50&h=120&Alt=404}} //Picture rendering
{{Image::ImageUrl?Alt=404}} //Picture rendering
Custom pipelines will be supported in the future.
Support Excel import template to generate annotation
Support Excel image import and export
Support multiple entities to export multiple Sheets
Support using some features under the System.ComponentModel.DataAnnotations namespace to control import and export #63
Support the use of custom formatter in ASP.NET Core Web API to export content such as Excel, Pdf, Csv #64
Support export by column, sheet, and additional rows
exporter.Append(list1).SeparateByColumn().Append(list2).ExportAppendData(filePath);
For details, see the above tutorial "Magicodes.IE Fancy Export"
[ExporterHeader(Width = 100)]
public DateTime Time3 { get; set; }
**Excel export supports HeaderRowIndex. Add the HeaderRowIndex attribute to the ExcelExporterAttribute export attribute class, so that it is convenient to specify the export from the first row when exporting. **
Excel generated import template supports built-in data verification
The support for the built-in data validation can be turned on through the IsInterValidation attribute, and it should be noted that only MaxLengthAttribute, MinLengthAttribute, StringLengthAttribute, and RangeAttribute support the opening operation of the built-in data validation.
Support display operations for input prompts:
This project exists thanks to all the people who contribute. [Contribute].
Become a financial contributor and help us sustain our community. [Contribute]
Support this project with your organization. Your logo will show up here with a link to your website. [Contribute]