{"id":18183,"date":"2024-03-15T16:24:38","date_gmt":"2024-03-15T16:24:38","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/"},"modified":"2024-03-21T12:42:02","modified_gmt":"2024-03-21T12:42:02","slug":"how-to-set-column-width-in-easyexcel-for-java","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/","title":{"rendered":"How to set column width in EasyExcel for Java?"},"content":{"rendered":"<p>In EasyExcel, you can use the setColumnWidth method of the Sheet object to set the width of a column. This method takes two parameters: the first parameter is the index of the column to be set (starting from 0), and the second parameter is the value of the column width in characters.<\/p>\n<p>Here&#8217;s an example code showing how to set column width.<\/p>\n<pre class=\"post-pre\"><code>\/\/ \u521b\u5efa\u4e00\u4e2a\u5de5\u4f5c\u7c3f\u5bf9\u8c61\r\nWorkbook workbook = new Workbook();\r\n\/\/ \u521b\u5efa\u4e00\u4e2a\u5de5\u4f5c\u8868\u5bf9\u8c61\r\nSheet sheet = workbook.createSheet(\"Sheet1\");\r\n\/\/ \u8bbe\u7f6e\u5217\u5bbd\uff0c\u53c2\u6570\u5206\u522b\u4e3a\u5217\u7d22\u5f15\u548c\u5217\u5bbd\u7684\u503c\r\nsheet.setColumnWidth(0, 10);\r\nsheet.setColumnWidth(1, 15);\r\nsheet.setColumnWidth(2, 20);\r\n\r\n\/\/ ... \u5176\u4ed6\u64cd\u4f5c\r\n\r\n\/\/ \u4fdd\u5b58\u5de5\u4f5c\u7c3f\r\nworkbook.save(\"output.xlsx\");\r\n<\/code><\/pre>\n<p>In the example above, we created a worksheet object and set the width of columns 0, 1, and 2 to 10, 15, and 20 characters wide, respectively. Finally, we used the save method of the workbook to save the workbook as an xlsx file.<\/p>\n<p>When setting column widths, it is important to consider the relationship between character width and the actual displayed width. Different fonts and font sizes may result in slight discrepancies between the displayed width and the set column width.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>In EasyExcel, you can use the setColumnWidth method of the Sheet object to set the width of a column. This method takes two parameters: the first parameter is the index of the column to be set (starting from 0), and the second parameter is the value of the column width in characters. Here&#8217;s an example [&hellip;]<\/p>\n","protected":false},"author":8,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-18183","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to set column width in EasyExcel for Java? - Blog - Silicon Cloud<\/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:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to set column width in EasyExcel for Java?\" \/>\n<meta property=\"og:description\" content=\"In EasyExcel, you can use the setColumnWidth method of the Sheet object to set the width of a column. This method takes two parameters: the first parameter is the index of the column to be set (starting from 0), and the second parameter is the value of the column width in characters. Here&#8217;s an example [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-15T16:24:38+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T12:42:02+00:00\" \/>\n<meta name=\"author\" content=\"William Carter\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"William Carter\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/\"},\"author\":{\"name\":\"William Carter\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\"},\"headline\":\"How to set column width in EasyExcel for Java?\",\"datePublished\":\"2024-03-15T16:24:38+00:00\",\"dateModified\":\"2024-03-21T12:42:02+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/\"},\"wordCount\":147,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/\",\"name\":\"How to set column width in EasyExcel for Java? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-15T16:24:38+00:00\",\"dateModified\":\"2024-03-21T12:42:02+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How to set column width in EasyExcel for Java?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0\",\"name\":\"William Carter\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g\",\"caption\":\"William Carter\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How to set column width in EasyExcel for Java? - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/","og_locale":"en_US","og_type":"article","og_title":"How to set column width in EasyExcel for Java?","og_description":"In EasyExcel, you can use the setColumnWidth method of the Sheet object to set the width of a column. This method takes two parameters: the first parameter is the index of the column to be set (starting from 0), and the second parameter is the value of the column width in characters. Here&#8217;s an example [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-15T16:24:38+00:00","article_modified_time":"2024-03-21T12:42:02+00:00","author":"William Carter","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"William Carter","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/"},"author":{"name":"William Carter","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0"},"headline":"How to set column width in EasyExcel for Java?","datePublished":"2024-03-15T16:24:38+00:00","dateModified":"2024-03-21T12:42:02+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/"},"wordCount":147,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/","url":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/","name":"How to set column width in EasyExcel for Java? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-15T16:24:38+00:00","dateModified":"2024-03-21T12:42:02+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-to-set-column-width-in-easyexcel-for-java\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How to set column width in EasyExcel for Java?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/f697031891aacefc4b681d139781d3c0","name":"William Carter","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1786698071dd8d74bec894b512f9e3c610c3a2a32985f67e688976cee3c8bbef?s=96&d=mm&r=g","caption":"William Carter"},"url":"https:\/\/www.silicloud.com\/blog\/author\/williamcarter\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18183","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/8"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=18183"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18183\/revisions"}],"predecessor-version":[{"id":51845,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/18183\/revisions\/51845"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=18183"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=18183"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=18183"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}