Create rows or table inside cell in excel [closed]










1















enter image description here



I am using apache poi creating the excel. I want to create the structure shown in above image.



I am not aware how to customise as per the image.






java apache-poi







share|improve this question















closed as too broad by Mark Rotteveel, greg-449, Erik Kalkoken, AmanicA, Matt Raines Nov 15 '18 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.













  • 1





    Which aspect is unclear to you? How to create merged cells?

    – Hulk
    Nov 15 '18 at 7:37






  • 1





    Possible duplicate of Merging cells in Excel using Apache POI

    – Hulk
    Nov 15 '18 at 7:40















1















enter image description here



I am using apache poi creating the excel. I want to create the structure shown in above image.



I am not aware how to customise as per the image.






java apache-poi







share|improve this question















closed as too broad by Mark Rotteveel, greg-449, Erik Kalkoken, AmanicA, Matt Raines Nov 15 '18 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.













  • 1





    Which aspect is unclear to you? How to create merged cells?

    – Hulk
    Nov 15 '18 at 7:37






  • 1





    Possible duplicate of Merging cells in Excel using Apache POI

    – Hulk
    Nov 15 '18 at 7:40













1












1








1








enter image description here



I am using apache poi creating the excel. I want to create the structure shown in above image.



I am not aware how to customise as per the image.






java apache-poi







share|improve this question
















enter image description here



I am using apache poi creating the excel. I want to create the structure shown in above image.



I am not aware how to customise as per the image.






java apache-poi




java apache-poi






share|improve this question















share|improve this question













share|improve this question




share|improve this question








edited Nov 15 '18 at 7:36









Hulk

3,42812142




3,42812142










asked Nov 15 '18 at 7:17









jagadeesan.pjagadeesan.p

213




213




closed as too broad by Mark Rotteveel, greg-449, Erik Kalkoken, AmanicA, Matt Raines Nov 15 '18 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.









closed as too broad by Mark Rotteveel, greg-449, Erik Kalkoken, AmanicA, Matt Raines Nov 15 '18 at 13:58


Please edit the question to limit it to a specific problem with enough detail to identify an adequate answer. Avoid asking multiple distinct questions at once. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.









  • 1





    Which aspect is unclear to you? How to create merged cells?

    – Hulk
    Nov 15 '18 at 7:37






  • 1





    Possible duplicate of Merging cells in Excel using Apache POI

    – Hulk
    Nov 15 '18 at 7:40












  • 1





    Which aspect is unclear to you? How to create merged cells?

    – Hulk
    Nov 15 '18 at 7:37






  • 1





    Possible duplicate of Merging cells in Excel using Apache POI

    – Hulk
    Nov 15 '18 at 7:40







1




1





Which aspect is unclear to you? How to create merged cells?

– Hulk
Nov 15 '18 at 7:37





Which aspect is unclear to you? How to create merged cells?

– Hulk
Nov 15 '18 at 7:37




1




1





Possible duplicate of Merging cells in Excel using Apache POI

– Hulk
Nov 15 '18 at 7:40





Possible duplicate of Merging cells in Excel using Apache POI

– Hulk
Nov 15 '18 at 7:40












1 Answer
1






active

oldest

votes


















1














You can use 



sheet.addMergedRegion(new CellRangeAddress(rowFrom,rowTo,colFrom,colTo));


And specify the row numbers and column numbers accordingly.






share|improve this answer























  • Thanks for the answer. I will try to use the CellRangeAddress and come back

    – jagadeesan.p
    Nov 15 '18 at 8:13

















1 Answer
1






active

oldest

votes








1 Answer
1






active

oldest

votes









active

oldest

votes






active

oldest

votes









1














You can use 



sheet.addMergedRegion(new CellRangeAddress(rowFrom,rowTo,colFrom,colTo));


And specify the row numbers and column numbers accordingly.






share|improve this answer























  • Thanks for the answer. I will try to use the CellRangeAddress and come back

    – jagadeesan.p
    Nov 15 '18 at 8:13















1














You can use 



sheet.addMergedRegion(new CellRangeAddress(rowFrom,rowTo,colFrom,colTo));


And specify the row numbers and column numbers accordingly.






share|improve this answer























  • Thanks for the answer. I will try to use the CellRangeAddress and come back

    – jagadeesan.p
    Nov 15 '18 at 8:13













1












1








1







You can use 



sheet.addMergedRegion(new CellRangeAddress(rowFrom,rowTo,colFrom,colTo));


And specify the row numbers and column numbers accordingly.






share|improve this answer













You can use 



sheet.addMergedRegion(new CellRangeAddress(rowFrom,rowTo,colFrom,colTo));


And specify the row numbers and column numbers accordingly.







share|improve this answer












share|improve this answer



share|improve this answer










answered Nov 15 '18 at 7:21









Pooja AggarwalPooja Aggarwal

870212




870212












  • Thanks for the answer. I will try to use the CellRangeAddress and come back

    – jagadeesan.p
    Nov 15 '18 at 8:13

















  • Thanks for the answer. I will try to use the CellRangeAddress and come back

    – jagadeesan.p
    Nov 15 '18 at 8:13
















Thanks for the answer. I will try to use the CellRangeAddress and come back

– jagadeesan.p
Nov 15 '18 at 8:13





Thanks for the answer. I will try to use the CellRangeAddress and come back

– jagadeesan.p
Nov 15 '18 at 8:13





-

Popular posts from this blog

Use pre created SQLite database for Android project in kotlin

Image
0 I am trying to use an already existing sqLite database in my android app. I have verified that it is loaded into the project in the assets folder and I can browse it in DB browser when I open it directly from the project. This is the schema for the table I am trying to query CREATE TABLE "ACTIVITY_LIST_TBL" ( `_ID` INTEGER NOT NULL, `ACT_NAME` VARCHAR NOT NULL, `ACT_CODE` VARCHAR, `IS_ACTIVE` INTEGER DEFAULT -1, PRIMARY KEY(`_ID`) ) Below is the activity that creates the sqlite helper and then on a button click I execute a query on the ACTIVITY_LIST_TBL. When the query is executed this exception is thrown: android.database.sqlite.SQLiteException: no such table: ACTIVITY_LIST_TBL (code 1 SQLITE_ERROR): , while compiling: SELECT * FROM ACTIVITY_LIST_TBL class CalendarActivity : AppCompatActivity() { private var cursor:Cursor? = null override fun onCreate(savedInstanceState:Bundle?) { super.onCreate(savedInstanceState) setContentView(R.layout.calendar_activity...
Read more

Darth Vader #20

Image
Wiki Characters Creators Teams Volumes Issues Publishers Locations Concepts Things Story Arcs Movies Series Episodes New Comics Forums Gen. Discussion Bug Reporting Delete/Combine Pages Artist Show-Off Off-Topic Contests Battles Fan-Fic RPG Comic Book Preview API Developers Editing & Tools Podcast Quests Community Top Users Activity Feed User Lists Community Promos Archives News Reviews Videos Podcasts Previews Login / Sign Up All Wiki     Arcs     Characters     Companies     Concepts     Issues     Locations     Movies     People     Teams     Things     Volumes     Series     Episodes Editorial     Videos     Articles     Reviews     Features ...
Read more

Ondo

Image
Der Titel dieses Artikels ist mehrdeutig. Zu weiteren Bedeutungen siehe Ondo (Begriffsklärung). Ondo Basisdaten Hauptstadt: Akure gegründet: 3. Februar 1976 Gouverneur: Rotimi Akeredolu ISO 3166-2: NG-ON Fläche Fläche: 15.500 km² Rang in Nigeria: 25 Bevölkerung Einwohner: 4.671.700 (2016) Bevölkerungsdichte: 320 Einw./km² (2016) Rang in Nigeria: 18 Lage von Ondo in Nigeria Ondo ist ein Bundesstaat des westafrikanischen Landes Nigeria mit der Hauptstadt Akure, die mit 420.623 Einwohnern (2005) auch die größte Stadt des Bundesstaates ist. Inhaltsverzeichnis 1 Geografie 2 Geschichte 2.1 Liste der Gouverneure und Administratoren 3 Verwaltung 4 Wirtschaft Geografie | Der Bundesstaat liegt im Südwesten des Landes und grenzt im Norden an den Bundesstaat Ekiti, im Nordwesten an den Bundesstaat Osun, im Nordosten an den Bundesstaat Kogi, im Süden an den Atlantik, im Südosten an den Bundesstaat Delta, im Westen an den Bundess...
Read more