SyntaxFix

[java] Merging cells in Excel using Apache POI

You can use :

sheet.addMergedRegion(new CellRangeAddress(startRowIndx, endRowIndx, startColIndx,endColIndx));

Make sure the CellRangeAddress does not coincide with other merged regions as that will throw an exception.

  • If you want to merge cells one above another, keep column indexes same
  • If you want to merge cells which are in a single row, keep the row indexes same
  • Indexes are zero based

For what you were trying to do this should work:

sheet.addMergedRegion(new CellRangeAddress(rowNo, rowNo, 0, 3));

Examples related to java

• Under what circumstances can I call findViewById with an Options Menu / Action Bar item? • How much should a function trust another function • How to implement a simple scenario the OO way • Two constructors • How do I get some variable from another class in Java? • this in equals method • How to split a string in two and store it in a field • How to do perspective fixing? • String index out of range: 4 • My eclipse won't open, i download the bundle pack it keeps saying error log

Examples related to android

• Under what circumstances can I call findViewById with an Options Menu / Action Bar item? • How to implement a simple scenario the OO way • My eclipse won't open, i download the bundle pack it keeps saying error log • getting " (1) no such column: _id10 " error • java doesn't run if structure inside of onclick listener • Cannot retrieve string(s) from preferences (settings) • strange error in my Animation Drawable • how to put image in a bundle and pass it to another activity • FragmentActivity to Fragment • A failure occurred while executing com.android.build.gradle.internal.tasks

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to apache-poi

• Alternative to deprecated getCellType • Apache POI error loading XSSFWorkbook class • Cannot get a text value from a numeric cell “Poi” • org.apache.poi.POIXMLException: org.apache.poi.openxml4j.exceptions.InvalidFormatException: • Merging cells in Excel using Apache POI • get number of columns of a particular row in given excel using Java • How to get row count in an Excel file using POI library? • How to check if an excel cell is empty using Apache POI? • What is the better API to Reading Excel sheets in java - JXL or Apache POI • Using Apache POI how to read a specific excel column