±âŸ(framework)
2017.04.27 / 21:36

[Apache POI ¶óÀ̺귯¸®] º´ÇÕµÈ cell ÀÎÁö È®ÀÎÇÏ´Â ÄÚµå

Scoda
Ãßõ ¼ö 273

Maven pom.xml ÀÇ ÀϺκÐ


  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.     xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/maven-v4_0_0.xsd">
  3.    
  4.     <properties>
  5.         <org.apache.poi.version>3.11</org.apache.poi.version>
  6.     </properties>
  7.    
  8.     <dependencies>
  9.    
  10.         <!-- org.apache.poi -->
  11.         <dependency>
  12.             <groupId>org.apache.poi</groupId>
  13.             <artifactId>poi</artifactId>
  14.             <version>${org.apache.poi.version}</version>
  15.         </dependency>

  16.         <dependency>
  17.             <groupId>org.apache.poi</groupId>
  18.             <artifactId>poi-ooxml</artifactId>
  19.             <version>${org.apache.poi.version}</version>
  20.         </dependency>

  21.         <dependency>
  22.             <groupId>org.apache.poi</groupId>
  23.             <artifactId>poi-ooxml-schemas</artifactId>
  24.             <version>${org.apache.poi.version}</version>
  25.         </dependency>

  26.         <!-- File Upload -->
  27.         <dependency>
  28.             <groupId>commons-fileupload</groupId>
  29.             <artifactId>commons-fileupload</artifactId>
  30.             <version>1.3.1</version>
  31.         </dependency>

  32.     </dependencies>

  33. </project>  


Java Code

  1. private boolean isMerged(org.apache.poi.ss.usermodel.Sheet sheet, int rowIdx, int colIdx) {

  2.     for(int i = 0; i < sheet.getNumMergedRegions(); ++i)
  3.     {
  4.         org.apache.poi.ss.util.CellRangeAddress range = sheet.getMergedRegion(i);

  5.         String message = String.format("%d - %d - %d - %d", range.getFirstRow(), range.getLastRow(), range.getFirstColumn(), range.getLastColumn());
  6.         System.out.println(message);

  7.         if( rowIdx >= range.getFirstRow() && rowIdx <= range.getLastRow() && colIdx >= range.getFirstColumn() && colIdx <= range.getLastColumn() ) {
  8.             return true;
  9.         }
  10.     }
  11.     return false;
  12. }


[Âü°í] 

How to Determine Merged Cells in a Certain Row


[POI] ¼¿ ÇÕÄ¡±â


XLS - Merge Cell Data - Java POI Example Program







Ãâó: http://bryan7.tistory.com/472 [¹Î¼­³×Áý]