开发者

POI and Excel Lists or Tables

开发者 https://www.devze.com 2023-01-04 14:40 出处:网络
There is a requirement to read multiple Excel \"Lists\" from one sheet in an Excel file. I need to know if there is an inbuilt method/api to obtain the dimensions of a list or deal with list specific

There is a requirement to read multiple Excel "Lists" from one sheet in an Excel file. I need to know if there is an inbuilt method/api to obtain the dimensions of a list or deal with list specific data. At the bare minimum, is there a way of knowing the "headers" of the list and the number of rows cont开发者_JS百科ained in the list data?

I want the POI wrapper that I am writing to be aware of the data elements on the excel, rather than being told through properties/constants or worse; hardcoding the names of the headers/size of the list.

Regards, Vinu PS: No idea whether the question made any sense...but anyone who gets my drift...please!


I've just written something to do this. AFAIK, Poi itself doesn't understand lists/tables, but you can easily write a wrapper that does. Alternatively, there is the jxls project - this allows complex mappings from POJOs to spreadsheets, and has table reader functionality.

How to: Excel Files has a number of links to projects that might be useful, including an Excel JDBC driver.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号