Excel中的Excel单元格位置 [英] excel cell position in java
问题描述
在一项要求中,我需要解析一个excel文件,其中数据可以在单元格中以及行跨度和列跨度中.解析后,我需要创建一个xml文件.还需要将女巫作为现有算法的参数传递,该算法根据某些位置逻辑提取数据.我需要一个可以使用以下元数据提取数据的解析器- 1单元格位置(行,列) 2行跨度和列跨度 两者的3高度和宽度
In one requirement I need to parse a excel file where data can be in cell as well as in row-span and column-span. after parsing I need to create a xml file. witch further needs to be pass as an argument to pre-existing algorithm, which extracts data depending upon some position logic. I need a parser which can extract data with following meta data-- 1-cell position (row, column) 2-row-span and column-span 3-height and width of both
如果可能的话请帮助.我正在使用Java.谢谢.
if possible please help.I am using java. Thanks.
推荐答案
您可以为此尝试 jxl [JExcelApi]库.
有一个 getMergedCells 方法,返回Range
引用,其中包含有关合并单元格的信息.
You can try jxl [JExcelApi] library for that.
There is a getMergedCells method which return Range
reference containing information about merged cell.
这篇关于Excel中的Excel单元格位置的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!