{"id":5429,"date":"2023-09-22T01:31:51","date_gmt":"2023-09-22T00:31:51","guid":{"rendered":"https:\/\/www.baeldung.com\/java-convert-excel-data-into-list"},"modified":"2023-09-22T01:31:51","modified_gmt":"2023-09-22T00:31:51","slug":"how-to-convert-excel-data-into-list-of-java-objects","status":"publish","type":"post","link":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/2023\/09\/22\/how-to-convert-excel-data-into-list-of-java-objects\/","title":{"rendered":"How To Convert Excel Data Into List Of Java Objects"},"content":{"rendered":"

\"\"<\/p>\n

1. Introduction<\/h2>\n
<\/div>\n

Understanding data mapping is essential in software development. Excel is a widely used data management software, making it crucial for Java developers to know how to map data between Excel and Java objects.<\/p>\n

In this tutorial, we’ll explore converting Excel data into a list of Java objects.<\/p>\n

Several Java libraries are available on the Maven repository to work with Excel files in Java, with Apache POI being the most common. However, in this tutorial, we’ll use four Java Excel libraries, including Apache POI, Poiji, FastExcel, and JExcelApi (Jxl), to convert Excel data into a Java object list<\/strong>.<\/p>\n

2. Model Setup<\/h2>\n
<\/div>\n

To get started, we need to create our object’s blueprint, the FoodInfo<\/em> class:<\/p>\n

public class FoodInfo {\r\n    private String category; \r\n    private String name; \r\n    private String measure;\r\n    private double calories; \r\n   \r\n    \/\/ standard constructors, toString, getters and setters\r\n}<\/code><\/pre>\n
3. Apache POI<\/h2>\n
<\/div>\n
Apache POI (Poor Obfuscation Implementation) is a Java API for Microsoft documents. It’s a collection of pure Java libraries used to read and write data from\/to Microsoft Office files<\/strong> such as Word, Outlook, Excel, and others.<\/p>\n
3.1. Maven Dependency<\/h3>\n
<\/div>\n
Let’s add our Maven dependencies<\/strong><\/a> to the pom.xml<\/em> file:<\/p>\n
<dependency>\r\n    <groupId>org.apache.poi<\/groupId>\r\n    <artifactId>poi<\/artifactId>\r\n    <version>5.2.3<\/version>\r\n<\/dependency>\r\n<dependency>\r\n    <groupId>org.apache.poi<\/groupId>\r\n    <artifactId>poi-ooxml<\/artifactId>\r\n    <version>5.2.3<\/version>\r\n<\/dependency>\r\n<dependency>\r\n    <groupId>org.apache.poi<\/groupId>\r\n    <artifactId>poi-ooxml-schemas<\/artifactId>\r\n    <version>4.1.2<\/version>\r\n<\/dependency>\r\n<\/code><\/pre>\n
3.2. Converting Excel Data into a List of Objects<\/h3>\n
<\/div>\n
By using its Workbook<\/em> interface, we can access various features to read the sheets and cells of an Excel file. This interface has two implementations, one for each Excel format – HSSFWorkbook<\/em> for .xls<\/em> and XSSFWorkbook<\/em> for .xlsx<\/em>.<\/b><\/p>\n
This snippet reads and converts Excel data using the Apache POI library from a .xlsx<\/em> file into a list of FoodInfo<\/em> objects:<\/p>\n
public static List<FoodInfo> excelDataToListOfObjets_withApachePOI(String fileLocation)\r\n  throws IOException {\r\n    FileInputStream file = new FileInputStream(new File(fileLocation));\r\n    Workbook workbook = new XSSFWorkbook(file);\r\n    Sheet sheet = workbook.getSheetAt(0);\r\n    List<FoodInfo> foodData = new ArrayList<FoodInfo>();\r\n    DataFormatter dataFormatter = new DataFormatter();\r\n    for (int n = 1; n < sheet.getPhysicalNumberOfRows(); n++) {\r\n        Row row = sheet.getRow(n);\r\n        FoodInfo foodInfo = new FoodInfo();\r\n        int i = row.getFirstCellNum();\r\n        foodInfo.setCategory(dataFormatter.formatCellValue(row.getCell(i)));\r\n        foodInfo.setName(dataFormatter.formatCellValue(row.getCell(++i)));\r\n        foodInfo.setMeasure(dataFormatter.formatCellValue(row.getCell(++i)));\r\n        foodInfo.setCalories(row.getCell(++i).getNumericCellValue());\r\n       \r\n        foodData.add(foodInfo);\r\n    }\r\n    return foodData;\r\n}<\/code><\/pre>\n
To determine the number of non-empty rows in the sheet<\/em> object, we utilize the getPhysicalNumberOfRows()<\/em> method<\/strong>. We then loop through the rows, excluding the header row (i = 1<\/em>).<\/p>\n
Depending on the field of the food object that we need to populate, we either use the dataFormatter<\/em> object or the getNumericValue()<\/em> method to convert and assign the cell value to the appropriate data type<\/strong>.<\/p>\n
Let’s verify our code by writing a unit test to make sure it works as expected using an Excel file named food_info.xlsx<\/em>:<\/p>\n
\n
@Test\r\npublic void whenParsingExcelFileWithApachePOI_thenConvertsToList() throws IOException {\r\n    List<FoodInfo> foodInfoList = ExcelDataToListApachePOI\r\n      .excelDataToListOfObjets_withApachePOI("src\\\\main\\\\resources\/food_info.xlsx");\r\n    assertEquals("Beverages", foodInfoList.get(0).getCategory());\r\n    assertEquals("Dairy", foodInfoList.get(3).getCategory());\r\n}<\/code><\/pre>\n<\/div>\n
The Apache POI library offers assistance for both older and newer versions of Excel files, namely .xls<\/em> and .xlsx<\/em>.<\/b><\/p>\n
4. Poiji<\/h2>\n
<\/div>\n
Poiji is a thread-safe Java library that provides an API for one-way data mapping from Excel sheets to Java classes<\/strong>. It’s built on top of the Apache POI library. But unlike Apache POI, it’s much simpler to use and directly converts each Excel row into a Java object.<\/p>\n
4.1. Setting Up the Maven Dependency<\/h3>\n
<\/div>\n
Here’s the Poiji Maven dependency<\/strong><\/a> we need to add to the pom.xml<\/em> file:<\/p>\n
<dependency>\r\n    <groupId>com.github.ozlerhakan<\/groupId>\r\n    <artifactId>poiji<\/artifactId>\r\n    <version>4.1.1<\/version>\r\n<\/dependency>\r\n<\/code><\/pre>\n
4.2. Setting Up the Class with Annotations<\/h3>\n
<\/div>\n
The Poiji library simplifies Excel data retrieval by requiring class fields to be annotated with either @ExcelCellName(String cellName)<\/em> or @ExcelCell(int cellIndex)<\/em>.<\/b><\/p>\n
Below, we’re setting up our FoodInfo<\/em> class for the Poiji library by adding annotations:<\/p>\n
public class FoodInfo { \r\n    \r\n    @ExcelCellName("Category") \r\n    private String category; \r\n    \r\n    @ExcelCellName("Name") \r\n    private String name;\r\n \r\n    @ExcelCellName("Measure") \r\n    private String measure;\r\n \r\n    @ExcelCellName("Calories") \r\n    private double calories;\r\n \r\n    \/\/ standard constructors, getters and setters \r\n}<\/code><\/pre>\n
The API offers support for mapping an Excel workbook that has multiple sheets. When our file has several sheets, we can employ the @ExcelSheet(String sheetName)<\/em> annotation on our class to indicate which sheet we want to work with. Any other sheets will be disregarded<\/strong>.<\/p>\n
However, if we don’t use this annotation, only the first Excel sheet in the workbook will be taken into account.<\/p>\n
In certain situations, we may not need to extract data from every row in the Excel sheet we are targeting. To address this, we can include a private int<\/em> rowIndex <\/em>property that is annotated with @ExcelRow in our class<\/em>. This will allow us to specify the index of the row items we want to access<\/strong>.<\/p>\n
4.3. Converting Excel Data into a List of Objects<\/h3>\n
<\/div>\n
Unlike the libraries mentioned in this article, the Poiji library, by default, ignores the header row of the Excel sheet<\/b>.<\/p>\n
The following snippet extracts data from an Excel file and converts its data into a list of FoodInfo:<\/em><\/p>\n
public class ExcelDataToListOfObjectsPOIJI {\r\n    public static List<FoodInfo> excelDataToListOfObjets_withPOIJI(String fileLocation){\r\n        return Poiji.fromExcel(new File(fileLocation), FoodInfo.class);\r\n    }\r\n}<\/code><\/pre>\n
The program translates the first Excel sheet of the fileLocation file<\/em> into a FoodInfo<\/em> class. Each row becomes an instance of the FoodInfo<\/em> class, with the cell values representing the object’s properties. The output is a list of FoodInfo<\/em> objects with a size equivalent to the number of rows (excluding the header row) in the original Excel sheet.<\/b><\/p>\n
There are some cases where a password may protect our Excel sheet. We can define the password via PoijiOptionsBuilder<\/em>:<\/p>\n
PoijiOptions options = PoijiOptionsBuilder.settings()\r\n  .password("<excel_sheet_password>").build();\r\nList<FoodInfo> foodData = Poiji.fromExcel(new File(fileLocation), FoodInfo.class, options);<\/code><\/pre>\n
To make sure our code works as expected, we write a unit test:<\/p>\n
@Test\r\npublic void whenParsingExcelFileWithPOIJI_thenConvertsToList() throws IOException {\r\n    List<FoodInfo> foodInfoList = \r\n      ExcelDataToListOfObjectsPOIJI\r\n        .excelDataToListOfObjets_withPOIJI("src\\\\main\\\\resources\/food_info.xlsx");\r\n    assertEquals("Beverages", foodInfoList.get(0).getCategory());\r\n    assertEquals("Dairy", foodInfoList.get(3).getCategory());\r\n}<\/code><\/pre>\n
5. FastExcel<\/h2>\n
<\/div>\n
FastExcel is an efficient library that utilizes minimal memory and provides high performance for creating and reading basic Excel workbooks in Java. <\/b>It exclusively supports the newer version of Excel files (.xlsx<\/em>) and has limited features compared to Apache POI.<\/strong><\/p>\n
It only reads cell content and does not include graphs, styles, or other cell formatting.<\/p>\n
5.1. Setting Up the Maven Dependency<\/h3>\n
<\/div>\n
Below are the FastExcel<\/a> and the FastExcel reader Maven dependencies<\/a><\/strong> added to pom.xml<\/em>:<\/p>\n
\n
<dependency>\r\n      <groupId>org.dhatim<\/groupId>\r\n      <artifactId>fastexcel<\/artifactId>\r\n      <version>0.15.7<\/version>\r\n<\/dependency>\r\n<dependency>\r\n      <groupId>org.dhatim<\/groupId>\r\n      <artifactId>fastexcel-reader<\/artifactId>\r\n      <version>0.15.7<\/version>\r\n<\/dependency><\/code><\/pre>\n<\/div>\n
5.2. Converting Excel Data into a List of Objects<\/h3>\n
<\/div>\n
When dealing with large files, the FastExcel reader is a great option despite its limited features<\/strong>. It’s easy to use, and<\/strong> we can access the entire Excel workbook using the ReadableWorkbook<\/em> class.<\/strong><\/p>\n
This allows us to retrieve sheets individually, either by name or index.<\/p>\n
In the method below, we read data from an Excel sheet and convert it into a list of FoodInfo<\/em> objects:<\/p>\n
public static List<FoodInfo> excelDataToListOfObjets_withFastExcel(String fileLocation)\r\n   throws IOException, NumberFormatException {\r\n    List<FoodInfo> foodData = new ArrayList<FoodInfo>();\r\n    try (FileInputStream file = new FileInputStream(fileLocation);\r\n      ReadableWorkbook wb = new ReadableWorkbook(file)) {\r\n        Sheet sheet = wb.getFirstSheet();\r\n        for (Row row: sheet.read()) {\r\n            if (row.getRowNum() == 1) {\r\n                continue;\r\n            }\r\n            FoodInfo food = new FoodInfo();\r\n            food.setCategory(row.getCellText(0));\r\n            food.setName(row.getCellText(1));\r\n            food.setMeasure(row.getCellText(2));\r\n            food.setCalories(Double.parseDouble(row.getCellText(3)));\r\n            \r\n            foodData.add(food);\r\n        }\r\n    }\r\n    return foodData;\r\n}<\/code><\/pre>\n
Because the API reads all the rows(including the header row) <\/strong>in the sheet<\/em>, we need to skip the first row(non-zero-based index) when looping through rows.<\/p>\n
Accessing a cell is done either by instantiating a Cell<\/em> class: Cell cell = row.getCell()<\/em>, which has two implementations, one that takes an int cellIndex<\/em> and the other a String cellAddress<\/em>(e.g., “C4”) arguments. Or by directly getting the data in the cell: e.g., row.getCellText().<\/em><\/p>\n
Either way, after extracting each cell’s content, we need to make sure to cast it, where necessary, to the appropriate food <\/em>object field type.<\/p>\n
Let’s write a unit test to make sure the conversion works:<\/p>\n
@Test\r\npublic void whenParsingExcelFileWithFastExcel_thenConvertsToList() throws IOException {\r\n    List<FoodInfo> foodInfoList = ExcelDataToListOfObjectsFastExcel\r\n      .excelDataToListOfObjets_withFastExcel("src\\\\main\\\\resources\/food_info.xlsx");\r\n    assertEquals("Beverages", foodInfoList.get(0).getCategory());\r\n    assertEquals("Dairy", foodInfoList.get(3).getCategory());\r\n}<\/code><\/pre>\n
6. JExcelApi\u00a0(Jxl)<\/h2>\n
<\/div>\n
JExcelApi\u00a0(or Jxl) is a lightweight Java library for reading, writing, and modifying Excel spreadsheets<\/strong>.<\/p>\n
6.1. Setting Up the Maven Dependency<\/h3>\n
<\/div>\n
Let’s add the Maven dependency for JExcelApi<\/strong><\/a> to the pom.xml<\/em> file:<\/p>\n
<dependency>\r\n    <groupId>net.sourceforge.jexcelapi<\/groupId>\r\n    <artifactId>jxl<\/artifactId>\r\n    <version>2.6.12<\/version>\r\n<\/dependency><\/code><\/pre>\n
6.2. Converting Excel Data into a List of Objects<\/h3>\n
<\/div>\n
Though it only supports the older Excel format(.xls<\/em>) files, <\/strong>the JExcel library offers a range of classes for manipulating Excel files. The Workbook<\/em> class is used to access the list of Excel sheets within the file.<\/p>\n
The code below uses the library to convert data from a .xls<\/em> file to a list of FoodInfo<\/em> objects, foodData:<\/em><\/p>\n
public static List<FoodInfo> excelDataToListOfObjets_withJxl(String fileLocation) \r\n  throws IOException, BiffException {\r\n    List<FoodInfo> foodData = new ArrayList<FoodInfo>();\r\n    Workbook workbook = Workbook.getWorkbook(new File(fileLocation));\r\n    Sheet sheet = workbook.getSheet(0);\r\n    int rows = sheet.getRows();\r\n    for (int i = 1; i < rows; i++) {\r\n        FoodInfo foodInfo = new FoodInfo();\r\n        foodInfo.setCategory(sheet.getCell(0, i).getContents());\r\n        foodInfo.setName(sheet.getCell(1, i).getContents());\r\n        foodInfo.setMeasure(sheet.getCell(2, i).getContents());\r\n        foodInfo.setCalories(Double.parseDouble(sheet.getCell(3, i).getContents()));\r\n        \r\n        foodData.add(foodInfo);\r\n    }\r\n    return foodData;\r\n}<\/code><\/pre>\n
Since the header row is not ignored by the library, we must loop from i = 1<\/em><\/strong>. The sheet object is a zero-based index list of rows.<\/p>\n
Retrieving cell data using the JExcel library is quite similar to the FastExcel library. Both libraries use the getCell()<\/em> method with two implementations<\/strong>.<\/p>\n
However, in JExcel, this method is directly accessed from a Sheet<\/em> object rather than a Row<\/em> object. Additionally, one of the implementations for the getCell()<\/em> method in JExcel takes two arguments,\u00a0 colNum<\/em> and rowNum<\/em>, both of which are integers: sheet.getCell(colNum, rowNum).<\/em><\/p>\n
To make sure the conversion works well, let’s write a unit test for our method:<\/p>\n
@Test\r\npublic void whenParsingExcelFileWithJxl_thenConvertsToList()\r\n  throws IOException, BiffException {\r\n    List<FoodInfo> foodInfoList = ExcelDataToListOfObjectsJxl\r\n      .excelDataToListOfObjets_withJxl("src\\\\main\\\\resources\/food_info.xls");\r\n    assertEquals("Beverages", foodInfoList.get(0).getCategory());\r\n    assertEquals("Dairy", foodInfoList.get(3).getCategory());\r\n}<\/code><\/pre>\n
7. Conclusion<\/h2>\n
<\/div>\n
In this article, we explored the usage of several libraries, such as Apache POI, Poiji, FastExcel, and JExcelApi, to read and convert data from Excel files into Java objects. However, the choice of which library to use depends on the specific needs, considering the advantages and limitations of each of them.<\/p>\n
For instance, we might choose to use the Poiji library if we prioritize the simplest way to just read data from an Excel file and directly convert it into a list of Java objects.<\/p>\n
When it comes to performance and simplicity for two-way Excel data mapping in Java, FastExcel, and JExcelApi libraries are excellent options. However, they offer fewer features compared to Apache POI, which is a feature-rich library that supports styles and graphs.<\/p>\n
As always, the complete source code for this article is available over on GitHub<\/a>.<\/p>\n
\"\"<\/p>\n
<\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/a> <\/div>\n\n
Commercials Cooperation Advertisements:<\/b><\/h2>\r\n

(1) IT Teacher IT Freelance
 <\/p>\r\nIT\u96fb\u8166\u88dc\u7fd2<\/a>
\u7acb\u523b\u8a3b\u518a\u53ca\u5831\u540d\u96fb\u8166\u88dc\u7fd2\u8ab2\u7a0b\u5427! <\/a>
\r\n\r\n\u7535\u5b50\u8ba1\u7b97\u673a -\u6559\u80b2 -IT \u96fb\u8166\u73ed\u201d ( IT\u96fb\u8166\u88dc\u7fd2 ) \u63d0\u4f9b\u4e00\u500b\u65b9\u4fbf\u7684\u7535\u5b50\u8ba1\u7b97\u673a \u6559\u80b2\u5e73\u53f0, \u70ba\u5927\u5bb6\u914d\u5c0d\u4fe1\u606f\u6280\u672f, \u96fb\u8166 \u8001\u5e2b, IT freelance \u548c programming expert. \u8b93\u5927\u5bb6\u65b9\u4fbf\u5730\u5c31\u80fd\u627e\u5230\u5408\u9069\u7684\u96fb\u8166\u88dc\u7fd2, \u96fb\u8166\u73ed, \u5bb6\u6559, \u79c1\u4eba\u8001\u5e2b.  
\r\n\r\nWe are a education and information platform which you can find a IT private tutorial teacher or freelance. 
\r\n\r\nAlso we provide different information about information technology, Computer, programming, mobile, Android, apple, game, movie, anime, animation\u2026 \r\n<\/p>\n

(2) ITSec
 <\/p>https:\/\/itsec.vip\/\r\nSecure<\/a> \r\n

 \r\n
www.ITSec.vip<\/a> 
 
 \r\n
www.Sraa.com.hk<\/a> 
 
 \r\n
www.ITSec.hk<\/a> 
 
 \r\n
www.Penetrationtest.hk<\/a> 
 
 \r\n
www.ITSeceu.uk<\/a> 
 
 \r\nSecure Your Computers from Cyber Threats and mitigate risks with professional services to defend Hackers. 

\r\nITSec provide IT Security and Compliance Services, including IT Compliance Services, Risk Assessment, IT Audit, Security Assessment and Audit, ISO 27001 Consulting and Certification, GDPR Compliance Services, Privacy Impact Assessment (PIA), Penetration test, Ethical Hacking, Vulnerabilities scan, IT Consulting, Data Privacy Consulting, Data Protection Services, Information Security Consulting, Cyber Security Consulting, Network Security Audit, Security Awareness Training. \r\n

Contact us right away. 

Email (Prefer using email to contact us): 
SalesExecutive@ITSec.vip<\/p>","protected":false},"excerpt":{"rendered":"
\"\"<\/p>\n
Learn about the usage of several libraries, such as Apache POI, Poiji, FastExcel, and JExcelApi, to read and convert data from Excel files into Java objects.<\/p>\n
<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/a>\u00a0<\/div>\n","protected":false},"author":259,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"site-container-style":"default","site-container-layout":"default","site-sidebar-layout":"default","disable-article-header":"default","disable-site-header":"default","disable-site-footer":"default","disable-content-area-spacing":"default","footnotes":""},"categories":[22],"tags":[61,122,127,129,124,128,125,132,131,133,126,130,123,66,94,88,97,56,64,65,60,112,40,75,95,104,33,120,105,101,98,115,30,29,41,86,70,69,68,72,71,26,118,108,87,46,55,48,52,54,51,50,83,62,58,57,2484,2485,109,35,59,63,85,79,82,96,80,27,81,114,44,42,43,45,38,39,110,117,100,111,116,73,89,90,92,91,93,84,78,37,102,34,36,77,67,74,99,113,119,28,121,32,47,49,53,103,31,76],"class_list":["post-5429","post","type-post","status-publish","format-standard","hentry","category-mobile","tag-airpods","tag-anime","tag-anime-characters","tag-anime-cosplay","tag-anime-edits","tag-anime-merchandise","tag-anime-movies","tag-anime-news","tag-anime-recommendations","tag-anime-reviews","tag-anime-series","tag-anime-streaming","tag-animes","tag-app-store","tag-app-store-samsung","tag-appgallery","tag-appgallery-oneplus","tag-apple","tag-apple-music","tag-apple-tv","tag-apple-watch","tag-bbc-sport","tag-best-mobile-games","tag-bixby","tag-bixby-xiaomi","tag-champions-league","tag-cyberpunk","tag-cyberpunk-2077","tag-fantasy-football","tag-fifa","tag-football","tag-formula-1","tag-fortnite","tag-free-fire","tag-free-mobile-games","tag-freebuds-pro","tag-galaxy-a52","tag-galaxy-note-20","tag-galaxy-s21","tag-galaxy-watch-4","tag-galaxy-z-fold-3","tag-game","tag-games","tag-golf","tag-harmonyos","tag-how-to-backup-iphone","tag-how-to-factory-reset-iphone","tag-how-to-reset-iphone","tag-how-to-restore-iphone","tag-how-to-unlock-iphone","tag-how-to-unlock-iphone-5","tag-how-to-unlock-iphone-6","tag-huawei","tag-ios","tag-ipad","tag-iphone","tag-java-collections","tag-java-list","tag-live-soccer","tag-lol","tag-macbook","tag-macos","tag-mate-40-pro","tag-mi-11-lite","tag-mi-home-security-camera-basic-1080p","tag-mi-home-security-camera-basic-1080p-huawei","tag-mi-smart-band-6","tag-minecraft","tag-miui","tag-mlb-scores","tag-mobile-game-design","tag-mobile-game-development","tag-mobile-game-marketing","tag-mobile-game-monetization","tag-mobile-games","tag-mobile-gaming","tag-nba-scores","tag-nba-standings","tag-nfl","tag-nfl-scores","tag-nhl-scores","tag-one-ui","tag-oneplus","tag-oneplus-9-pro","tag-oneplus-buds-pro","tag-oneplus-nord-ce-5g","tag-oxygenos","tag-p40-pro-plus","tag-poco-x3-pro","tag-pokemon","tag-premier-league","tag-pubg","tag-pubg-mobile","tag-redmi-note-10-pro","tag-samsung","tag-samsung-pay","tag-soccer","tag-sports","tag-steam","tag-steeam","tag-top-10-anime","tag-valorant","tag-when-do-the-iphone-7-come-out","tag-when-does-the-iphone-7-come-out","tag-when-is-the-iphone-7-coming-out","tag-world-cup","tag-xbox-series-x","tag-xiaomi"],"aioseo_notices":[],"_links":{"self":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/posts\/5429","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/users\/259"}],"replies":[{"embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/comments?post=5429"}],"version-history":[{"count":1,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/posts\/5429\/revisions"}],"predecessor-version":[{"id":5430,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/posts\/5429\/revisions\/5430"}],"wp:attachment":[{"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/media?parent=5429"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/categories?post=5429"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/gamefootballmobileanimeiphone.com\/index.php\/wp-json\/wp\/v2\/tags?post=5429"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}