Shulou(Shulou.com)06/01 Report--

This article is about how to do Excel import and export. The editor thinks it is very practical, so share it with you as a reference and follow the editor to have a look.

Pom introduction

No other jar is needed.

Write entity classes

1. Note here that there must be an empty constructor, otherwise an "object creation error" will be reported.

2. With regard to the annotation @ Excel, there are other comments such as @ ExcelCollection,@ExcelEntity, @ ExcelIgnore,@ExcelTarget and so on. We don't need them here. We can check more officially.

Attribute

Type default value

Description

NameStringnull column name needMergebooleanfasle vertically merges cells

OrderNumString "0" sequence number replaceString [] {}

Value replaces widthdouble10D width isImportFieldString ""

Import check formatString "" format databaseFormatString "yyyyMMddHHmmss" Export time Settings numFormatString "" numeric format mergeVerticalbooleanfasle vertically merge the same cells

Export util

Import common methods

1. Traditional import, receiving file path as parameter

Yes, I read it correctly, so it can be exported and imported.

test

Thank you for reading! On "how to do Excel import and export" this article is shared here, I hope the above content can be of some help to you, so that you can learn more knowledge, if you think the article is good, you can share it out for more people to see it!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.