ButtonExcelUpload

 

 

Basic UI

엑셀 업로드 버튼은 주로 Table List 와 함께 사용되며 실제 적용한 모습은 다음과 같다.

( 참고: Event Component )

 

 

 


Development Guide

 

1. Summary


Upload excel file. The format supports: .xls, .xlsx

 

Video Guide:

 

 

 

File sample:

backendcore/src/main/resources/schema/core/builder/frontoffice/element/popUpProp.json

 

The first row is the property from the schema Popup Property: pageUrl, pageUrlContext, exposeDuration, width, height, etc.

The second row is just the table list column labels
The next rows are equivalent to the import data

 

 

 

 

 

 

 

 

 

 

 

 

 

 

2. Reference Data Sample

 

main Schema:

backendcore/src/main/resources/schema/test/backOfficeGuide/uploadExcelSampleSchema.json

 

 

Reference Data Schema:

backendcore/src/main/resources/schema/test/backOfficeGuide/sampleJobSchema.json

 

 

Reference Data:

backendcore/src/main/resources/schema/test/backOfficeGuide/data/sampleJobData.json

 

 

Excel Data:

  • first row: table pid list

  • second row: table column name list

  • over 3 row: table data. reference data must input existing reference id.

  • sheet: table tid