{"id":226215,"date":"2020-01-28T04:11:37","date_gmt":"2020-01-28T04:11:37","guid":{"rendered":"https:\/\/webkul.com\/blog\/?p=226215"},"modified":"2020-01-28T13:38:25","modified_gmt":"2020-01-28T13:38:25","slug":"selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries","status":"publish","type":"post","link":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/","title":{"rendered":"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries"},"content":{"rendered":"\n

In the real word automation script, the test data shouldn\u2019t be hardcoded. Some external resources (excel sheet, properties file, xml file, json file etc.) should be used to read or write data.<\/p>\n\n\n\n

In Selenium, Java provides some different classes or interfaces to perform file manipulation. Apache POI libraries are used to perform such operations. Some of the interfaces are given below to read or write data from the external resources:<\/p>\n\n\n\n

  1. POIFS (Poor Obfuscation Implementation File System)<\/li>
  2. HSSF(Horrible Spreadsheet Format)<\/li>
  3. XSSF(XML Spreadsheet Format)<\/li>
  4. HPSF(Horrible Property Set Format)<\/li>
  5. HWPF(Horrible Word Processor Format)<\/li>
  6. XWPF(XML Word Processor Format)<\/li>
  7. HSLF(Horrible Slide Layout Format)<\/li>
  8. HGDF(Horrible Diagram Format)<\/li>
  9. HDBF(Horrible PuBlisher Format)<\/li><\/ol>\n\n\n\n

    To create or maintain Excel Workbooks , Apache POI provides \u201d Workbook\u201d as super-interface of all classes. It belongs to org.apache.poi.ss.usermodel <\/strong>package. It uses WorkbookFactory class for creating the appropriate kind of Workbook (i.e. HSSFWorkbook or XSSFWorkbook). The two classes which implements \u201cWorkbook\u201d interface are given below:<\/p>\n\n\n\n

    1. HSSFWorkbook- This class methods are used to read\/write data to Microsoft Excel file in .xls format. <\/li>
    2. XSSFWorkbook- This class methods are used to read write data to Microsoft Excel and OpenOffice xml files in .xls or .xlsx format. <\/li><\/ol>\n\n\n\n

      Note:<\/strong> For Apache POI<\/code> Libraries installation, please refer to the blog– https:\/\/webkul.com\/blog\/apache-poi-installation-to-project-library\/<\/a><\/p>\n\n\n\n

      Read Data From Excel Sheet:<\/h3>\n\n\n\n

      Below Code is written to read the data from the excel sheet:<\/p>\n\n\n\n

      package testng;\nimport java.io.File;\nimport java.io.FileInputStream;\nimport java.io.FileNotFoundException;\nimport java.io.IOException;\n\nimport org.apache.poi.EncryptedDocumentException;\nimport org.apache.poi.openxml4j.exceptions.InvalidFormatException;\nimport org.apache.poi.ss.usermodel.Sheet;\nimport org.apache.poi.ss.usermodel.Workbook;\nimport org.apache.poi.ss.usermodel.WorkbookFactory;\nimport org.testng.annotations.Test;\n\npublic class excelsheet \n{\n  @Test\n  public void excel() throws EncryptedDocumentException, InvalidFormatException, FileNotFoundException, IOException { \n                \/\/get the excel sheet file location               \n                String filepath=".\\\\excelsheet\\\\testdata.xlsx";\n\t              Workbook wb= new WorkbookFactory().create(new FileInputStream(new \n                              File(filepath)));\n                \/\/get the sheet which needs read operation\n\t\t            Sheet sh = wb.getSheet("sheet1");\n                \/\/get the total row count in the excel sheet\t\n\t\t            int rowcount = sh.getLastRowNum();\n\t\t              for (int i = 0; i <= rowcount; i++) \n                  {\n                    \/\/ get the total cell count in the excel sheet\n\t\t\t               int cellcount = sh.getRow(i).getLastCellNum();\n\t\t\t                  for (int j = 0; j < cellcount; j++) \n                        {                         \n                            \/\/get cell value at the given position [i][j]\n\t\t                        String value = sh.getRow(i).getCell(j).getStringCellValue();\n                            \/\/print the cell value\n\t\t\t\t                    System.out.println(value);\n\t\t\t\t\n\t\t\t                   }\t\t\t\n\t\t                }\t\n\t\t          }\n}<\/pre>\n\n\n\n
      “Workbook” interface throws some exceptions which needs to be handled i.e. EncryptedDocumentException, InvalidFormatException, FileNotFoundException & IOException.<\/p>\n\n\n\n
      Note:<\/strong> In Excel Sheet, there shouldn’t be any voided cell in-between the data fields, else the code will throw an error message at the time of execution & the data after the voided cell will be skipped.<\/p>\n\n\n\n
       Workbook wb= new WorkbookFactory().create(new FileInputStream(new File(filepath)));<\/pre>\n\n\n\n
      The above code can also be written as below for better understanding:<\/p>\n\n\n\n
      File file= new File(".\\\\excelsheet\\\\testdata.xlsx");\n\t  FileInputStream fis= new FileInputStream(file);\n\t  Workbook wb= WorkbookFactory.create(fis);<\/pre>\n\n\n\n
      Write Data to Excel Sheet:<\/h2>\n\n\n\n
      Below code is written to write the code to the excel sheet:<\/p>\n\n\n\n
      package testng;\nimport java.io.File;\nimport java.io.FileNotFoundException;\nimport java.io.FileOutputStream;\nimport java.io.IOException;\nimport org.apache.poi.ss.usermodel.Cell;\nimport org.apache.poi.ss.usermodel.CellType;\nimport org.apache.poi.ss.usermodel.Row;\nimport org.apache.poi.ss.usermodel.Sheet;\nimport org.apache.poi.ss.usermodel.Workbook;\nimport org.apache.poi.xssf.usermodel.XSSFWorkbook;\nimport org.testng.annotations.Test;\n\npublic class writeexcel {\n\t@Test\n\tpublic void write() throws IOException\n\t{\n        \/\/define the file path where excel sheet will be generated\n\tString filepath= (".\\\\excelsheet\\\\write.xlsx");\n\tFile file= new File(filepath);\n\tFileOutputStream fos=new FileOutputStream(file);\n        \/\/create the blank workbook\n\tWorkbook wb= new XSSFWorkbook();\n        \/\/create the blank excel sheet\n\tSheet sh= wb.createSheet("Webkul");\n\t\/\/define the position in the excel sheet where write operation needs to perform\n        Row rw= sh.createRow(4);\n\tCell cl=rw.createCell(1);\n        \/\/define input type\n\tcl.setCellType(CellType.STRING);\n        \/\/define the data value\n\tcl.setCellValue("Webkul Software");\n        \/\/write the workbook\n\twb.write(fos);\n\t}\n}<\/pre>\n\n\n\n
      In case you have any queries then feel free to ask in the comment section below.<\/p>\n","protected":false},"excerpt":{"rendered":"
      In the real word automation script, the test data shouldn\u2019t be hardcoded. Some external resources (excel sheet, properties file, xml file, json file etc.) should be used to read or write data. In Selenium, Java provides some different classes or interfaces to perform file manipulation. Apache POI libraries are used to perform such operations. Some […]<\/a><\/p>\n","protected":false},"author":192,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-226215","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nSelenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries - Webkul Blog<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries - Webkul Blog\" \/>\n<meta property=\"og:description\" content=\"In the real word automation script, the test data shouldn\u2019t be hardcoded. Some external resources (excel sheet, properties file, xml file, json file etc.) should be used to read or write data. In Selenium, Java provides some different classes or interfaces to perform file manipulation. Apache POI libraries are used to perform such operations. Some [...]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/\" \/>\n<meta property=\"og:site_name\" content=\"Webkul Blog\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/webkul\/\" \/>\n<meta property=\"article:published_time\" content=\"2020-01-28T04:11:37+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-01-28T13:38:25+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"630\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Vrinda Sharma\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@webkul\" \/>\n<meta name=\"twitter:site\" content=\"@webkul\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Vrinda Sharma\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/\"},\"author\":{\"name\":\"Vrinda Sharma\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/e936c679e3d52624ed5c67d965efbb38\"},\"headline\":\"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries\",\"datePublished\":\"2020-01-28T04:11:37+00:00\",\"dateModified\":\"2020-01-28T13:38:25+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/\"},\"wordCount\":345,\"commentCount\":17,\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/\",\"url\":\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/\",\"name\":\"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries - Webkul Blog\",\"isPartOf\":{\"@id\":\"https:\/\/webkul.com\/blog\/#website\"},\"datePublished\":\"2020-01-28T04:11:37+00:00\",\"dateModified\":\"2020-01-28T13:38:25+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/webkul.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/webkul.com\/blog\/#website\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"name\":\"Webkul Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/webkul.com\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/webkul.com\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/webkul.com\/blog\/#organization\",\"name\":\"WebKul Software Private Limited\",\"url\":\"https:\/\/webkul.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"contentUrl\":\"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png\",\"width\":380,\"height\":380,\"caption\":\"WebKul Software Private Limited\"},\"image\":{\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/webkul\/\",\"https:\/\/x.com\/webkul\",\"https:\/\/www.instagram.com\/webkul\/\",\"https:\/\/www.linkedin.com\/company\/webkul\",\"https:\/\/www.youtube.com\/user\/webkul\/\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/e936c679e3d52624ed5c67d965efbb38\",\"name\":\"Vrinda Sharma\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/de5c9d7485ea2c21a79ddd9c407fcc23d4c8bbb9ed7913cbcbc01dd938fa9952?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/de5c9d7485ea2c21a79ddd9c407fcc23d4c8bbb9ed7913cbcbc01dd938fa9952?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g\",\"caption\":\"Vrinda Sharma\"},\"url\":\"https:\/\/webkul.com\/blog\/author\/vrindasharma-tester205\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries - Webkul Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/","og_locale":"en_US","og_type":"article","og_title":"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries - Webkul Blog","og_description":"In the real word automation script, the test data shouldn\u2019t be hardcoded. Some external resources (excel sheet, properties file, xml file, json file etc.) should be used to read or write data. In Selenium, Java provides some different classes or interfaces to perform file manipulation. Apache POI libraries are used to perform such operations. Some [...]","og_url":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/","og_site_name":"Webkul Blog","article_publisher":"https:\/\/www.facebook.com\/webkul\/","article_published_time":"2020-01-28T04:11:37+00:00","article_modified_time":"2020-01-28T13:38:25+00:00","og_image":[{"width":1200,"height":630,"url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-og.png","type":"image\/png"}],"author":"Vrinda Sharma","twitter_card":"summary_large_image","twitter_creator":"@webkul","twitter_site":"@webkul","twitter_misc":{"Written by":"Vrinda Sharma","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#article","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/"},"author":{"name":"Vrinda Sharma","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/e936c679e3d52624ed5c67d965efbb38"},"headline":"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries","datePublished":"2020-01-28T04:11:37+00:00","dateModified":"2020-01-28T13:38:25+00:00","mainEntityOfPage":{"@id":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/"},"wordCount":345,"commentCount":17,"publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/","url":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/","name":"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries - Webkul Blog","isPartOf":{"@id":"https:\/\/webkul.com\/blog\/#website"},"datePublished":"2020-01-28T04:11:37+00:00","dateModified":"2020-01-28T13:38:25+00:00","breadcrumb":{"@id":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/webkul.com\/blog\/selenium-webdriver-read-and-write-data-from-excel-file-using-apache-poi-libraries\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/webkul.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Selenium Webdriver: Read and Write Data from Excel Sheet using Apache POI Libraries"}]},{"@type":"WebSite","@id":"https:\/\/webkul.com\/blog\/#website","url":"https:\/\/webkul.com\/blog\/","name":"Webkul Blog","description":"","publisher":{"@id":"https:\/\/webkul.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/webkul.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/webkul.com\/blog\/#organization","name":"WebKul Software Private Limited","url":"https:\/\/webkul.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","contentUrl":"https:\/\/cdnblog.webkul.com\/blog\/wp-content\/uploads\/2021\/08\/webkul-logo-accent-sq.png","width":380,"height":380,"caption":"WebKul Software Private Limited"},"image":{"@id":"https:\/\/webkul.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/webkul\/","https:\/\/x.com\/webkul","https:\/\/www.instagram.com\/webkul\/","https:\/\/www.linkedin.com\/company\/webkul","https:\/\/www.youtube.com\/user\/webkul\/"]},{"@type":"Person","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/e936c679e3d52624ed5c67d965efbb38","name":"Vrinda Sharma","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/webkul.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/de5c9d7485ea2c21a79ddd9c407fcc23d4c8bbb9ed7913cbcbc01dd938fa9952?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/de5c9d7485ea2c21a79ddd9c407fcc23d4c8bbb9ed7913cbcbc01dd938fa9952?s=96&d=https%3A%2F%2Fcdnblog.webkul.com%2Fblog%2Fwp-content%2Fuploads%2F2019%2F10%2Feva.png&r=g","caption":"Vrinda Sharma"},"url":"https:\/\/webkul.com\/blog\/author\/vrindasharma-tester205\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/226215","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/users\/192"}],"replies":[{"embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/comments?post=226215"}],"version-history":[{"count":17,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/226215\/revisions"}],"predecessor-version":[{"id":226510,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/posts\/226215\/revisions\/226510"}],"wp:attachment":[{"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/media?parent=226215"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/categories?post=226215"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/webkul.com\/blog\/wp-json\/wp\/v2\/tags?post=226215"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}