{"id":3571,"date":"2018-05-29T22:05:31","date_gmt":"2018-05-29T15:05:31","guid":{"rendered":"http:\/\/mahisaajy.web.id\/blog\/?p=3571"},"modified":"2022-12-29T10:50:11","modified_gmt":"2022-12-29T03:50:11","slug":"memisahkan-sheet-di-excel-menjadi-file-excel-lain","status":"publish","type":"post","link":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/","title":{"rendered":"Memisahkan Sheet di Excel Menjadi File Excel Lain"},"content":{"rendered":"\n<p>Malam ini terbesit ide untuk menuliskan tentang sebuah tips dan trik yang saya dapatkan ketika di kantor.<\/p>\n\n\n\n<p>Rekan kerja di kantor saya meminta tolong untuk memisahkan sheet di excel menjadi file excel lain secara terpisah.<\/p>\n\n\n\n<p>Dari sheet-sheet berikut ini:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\"><img loading=\"lazy\" decoding=\"async\" width=\"388\" height=\"85\" data-attachment-id=\"3574\" data-permalink=\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/screenshot-from-2018-05-29-21-27-05\/\" data-orig-file=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\" data-orig-size=\"388,85\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot from 2018-05-29 21-27-05\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\" data-large-file=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\" src=\"http:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\" alt=\"\" class=\"wp-image-3574\" srcset=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png 388w, https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05-150x33.png 150w\" sizes=\"auto, (max-width: 388px) 100vw, 388px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Dipecah menjadi file-file terpisah seperti ini:<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter\"><a href=\"http:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-48-58-1.png\"><img loading=\"lazy\" decoding=\"async\" width=\"161\" height=\"242\" data-attachment-id=\"3577\" data-permalink=\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/screenshot-from-2018-05-29-21-48-58-2\/\" data-orig-file=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-48-58-1.png\" data-orig-size=\"161,242\" data-comments-opened=\"1\" data-image-meta=\"{&quot;aperture&quot;:&quot;0&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;0&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;0&quot;,&quot;iso&quot;:&quot;0&quot;,&quot;shutter_speed&quot;:&quot;0&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"Screenshot from 2018-05-29 21-48-58\" data-image-description=\"\" data-image-caption=\"\" data-medium-file=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-48-58-1.png\" data-large-file=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-48-58-1.png\" src=\"http:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-48-58-1.png\" alt=\"\" class=\"wp-image-3577\" srcset=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-48-58-1.png 161w, https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-48-58-1-100x150.png 100w\" sizes=\"auto, (max-width: 161px) 100vw, 161px\" \/><\/a><\/figure><\/div>\n\n\n\n<p>Awalnya saya mau melakukan ini secara manual, namun setelah melakukannya pada beberapa sheet, kok rasanya pekerjaan ini berulang-ulang dan terasa &#8220;membosankan&#8221;. Dan juga sheet-sheet yang ada ini juga terlalu banyak, kurang lebih ada 20an. Berhubung saya <del>rajin<\/del> malas (hehehe), maka saya coba riset sedikit di google. &#8220;Apakah bisa pekerjaan ini diotomatisasi?&#8221; begitu pikir saya&nbsp; dalam hati.<\/p>\n\n\n\n<p>BANG! Setelah saya googling sedikit, maka ketemu caranya. Ada pada halaman <a href=\"https:\/\/www.extendoffice.com\/documents\/excel\/785-excel-save-export-sheet-as-new-workbook.html\" target=\"_blank\" rel=\"noopener\">berikut ini<\/a>&nbsp;. Saya lihat tutorial tersebut dan melihat pada bagian berikut:<\/p>\n\n\n\n<blockquote class=\"wp-block-quote is-layout-flow wp-block-quote-is-layout-flow\"><p>Export And Save Worksheets As New Workbook With VBA Code<\/p><\/blockquote>\n\n\n\n<p>Tanpa ragu, saya mencobanya. BANG! Berhasil ternyata. Ini magic. Hehehe.<\/p>\n\n\n\n<p>Alhasil saya bisa menghemat waktu untuk menyelesaikan pekerjaan tersebut.<\/p>\n\n\n\n<p>Jadi berikut ini scriptnya. Silahkan mencoba. Dan tutorial lengkapnya ada di sini ya:&nbsp;https:\/\/www.extendoffice.com\/documents\/excel\/785-excel-save-export-sheet-as-new-workbook.html<\/p>\n\n\n\n<pre class=\"wp-block-code\"><code><meta charset=\"utf-8\"><p>Sub SplitWorkbook()\n'Updateby20140612\nDim FileExtStr As String\nDim FileFormatNum As Long\nDim xWs As Worksheet\nDim xWb As Workbook\nDim FolderName As String\nApplication.ScreenUpdating = False\nSet xWb = Application.ThisWorkbook\nDateString = Format(Now, \"yyyy-mm-dd hh-mm-ss\")\nFolderName = xWb.Path &amp; \"\\\" &amp; xWb.Name &amp; \" \" &amp; DateString\nMkDir FolderName\nFor Each xWs In xWb.Worksheets\nxWs.Copy\nIf Val(Application.Version) &lt; 12 Then\nFileExtStr = \".xls\": FileFormatNum = -4143\nElse\nSelect Case xWb.FileFormat\nCase 51:\nFileExtStr = \".xlsx\": FileFormatNum = 51\nCase 52:\nIf Application.ActiveWorkbook.HasVBProject Then\nFileExtStr = \".xlsm\": FileFormatNum = 52\nElse\nFileExtStr = \".xlsx\": FileFormatNum = 51\nEnd If\nCase 56:\nFileExtStr = \".xls\": FileFormatNum = 56\nCase Else:\nFileExtStr = \".xlsb\": FileFormatNum = 50\nEnd Select\nEnd If\nxFile = FolderName &amp; \"\\\" &amp; Application.ActiveWorkbook.Sheets(1).Name &amp; FileExtStr\nApplication.ActiveWorkbook.SaveAs xFile, FileFormat:=FileFormatNum\nApplication.ActiveWorkbook.Close False\nNext\nMsgBox \"You can find the files in \" &amp; FolderName\nApplication.ScreenUpdating = True\nEnd Sub<\/p><\/code><\/pre>\n\n\n\n<p>Semoga bermanfaat untuk rekan-rekan BMKG yang mengalami hal serupa di atas seperti saya. Dan juga semoga bermanfaat untuk para pembaca blog ini.<\/p>\n\n\n\n<p>Berhubung ini masih di pertengahan Ramadhan. Terus tingkatkan ibadah, ya Guys.<\/p>\n\n\n\n<p>See you.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Malam ini terbesit ide untuk menuliskan tentang sebuah tips dan trik yang saya dapatkan ketika di kantor. Rekan kerja di kantor saya meminta tolong untuk memisahkan sheet di excel menjadi file excel lain secara terpisah. Dari sheet-sheet berikut ini: Dipecah menjadi file-file terpisah seperti ini: Awalnya saya mau melakukan ini secara manual, namun setelah melakukannya [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":3574,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"jetpack_post_was_ever_published":false,"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":true,"jetpack_social_options":{"image_generator_settings":{"template":"highway","default_image_id":0,"font":"","enabled":false},"version":2},"_links_to":"","_links_to_target":""},"categories":[322,390,3,30],"tags":[],"class_list":["post-3571","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bmkg","category-excel","category-personal","category-tutorial"],"blocksy_meta":{"styles_descriptor":{"styles":{"desktop":"","tablet":"","mobile":""},"google_fonts":[]}},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.0 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Memisahkan Sheet di Excel Menjadi File Excel Lain - Mahisa Ajy Kusuma<\/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:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Memisahkan Sheet di Excel Menjadi File Excel Lain - Mahisa Ajy Kusuma\" \/>\n<meta property=\"og:description\" content=\"Malam ini terbesit ide untuk menuliskan tentang sebuah tips dan trik yang saya dapatkan ketika di kantor. Rekan kerja di kantor saya meminta tolong untuk memisahkan sheet di excel menjadi file excel lain secara terpisah. Dari sheet-sheet berikut ini: Dipecah menjadi file-file terpisah seperti ini: Awalnya saya mau melakukan ini secara manual, namun setelah melakukannya [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/\" \/>\n<meta property=\"og:site_name\" content=\"Mahisa Ajy Kusuma\" \/>\n<meta property=\"article:publisher\" content=\"mahisaajy\" \/>\n<meta property=\"article:author\" content=\"mahisaajy\" \/>\n<meta property=\"article:published_time\" content=\"2018-05-29T15:05:31+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-12-29T03:50:11+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\" \/>\n\t<meta property=\"og:image:width\" content=\"388\" \/>\n\t<meta property=\"og:image:height\" content=\"85\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"mahisaajy\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@mahisaajy\" \/>\n<meta name=\"twitter:site\" content=\"@mahisaajy\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"mahisaajy\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/\"},\"author\":{\"name\":\"mahisaajy\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\"},\"headline\":\"Memisahkan Sheet di Excel Menjadi File Excel Lain\",\"datePublished\":\"2018-05-29T15:05:31+00:00\",\"dateModified\":\"2022-12-29T03:50:11+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/\"},\"wordCount\":219,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\"},\"image\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\",\"articleSection\":[\"BMKG\",\"Excel\",\"Personal\",\"Tutorial\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/\",\"url\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/\",\"name\":\"Memisahkan Sheet di Excel Menjadi File Excel Lain - Mahisa Ajy Kusuma\",\"isPartOf\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\",\"datePublished\":\"2018-05-29T15:05:31+00:00\",\"dateModified\":\"2022-12-29T03:50:11+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage\",\"url\":\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\",\"contentUrl\":\"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png\",\"width\":388,\"height\":85},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/mahisaajy.web.id\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Memisahkan Sheet di Excel Menjadi File Excel Lain\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#website\",\"url\":\"https:\/\/mahisaajy.web.id\/blog\/\",\"name\":\"Mahisa Ajy Kusuma\",\"description\":\"Kewajiban kita lebih banyak dari waktu yang tersedia.\",\"publisher\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/mahisaajy.web.id\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":[\"Person\",\"Organization\"],\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c\",\"name\":\"mahisaajy\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g\",\"caption\":\"mahisaajy\"},\"logo\":{\"@id\":\"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/\"},\"description\":\"Seorang pemuda yang mempunyai hobi menulis, membaca, dan bermusik. Tertarik dengan bidang ilmu komputer untuk memecahkan beberapa persoalan. Sejak tahun 2018 bekerja di BMKG di Direktorat Data dan Komputasi.\",\"sameAs\":[\"http:\/\/mahisaajy.web.id\/blog\/\",\"mahisaajy\",\"https:\/\/x.com\/mahisaajy\",\"mahisaful\"],\"url\":\"https:\/\/mahisaajy.web.id\/blog\/author\/mahisaajy\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Memisahkan Sheet di Excel Menjadi File Excel Lain - Mahisa Ajy Kusuma","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:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/","og_locale":"en_US","og_type":"article","og_title":"Memisahkan Sheet di Excel Menjadi File Excel Lain - Mahisa Ajy Kusuma","og_description":"Malam ini terbesit ide untuk menuliskan tentang sebuah tips dan trik yang saya dapatkan ketika di kantor. Rekan kerja di kantor saya meminta tolong untuk memisahkan sheet di excel menjadi file excel lain secara terpisah. Dari sheet-sheet berikut ini: Dipecah menjadi file-file terpisah seperti ini: Awalnya saya mau melakukan ini secara manual, namun setelah melakukannya [&hellip;]","og_url":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/","og_site_name":"Mahisa Ajy Kusuma","article_publisher":"mahisaajy","article_author":"mahisaajy","article_published_time":"2018-05-29T15:05:31+00:00","article_modified_time":"2022-12-29T03:50:11+00:00","og_image":[{"width":388,"height":85,"url":"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png","type":"image\/png"}],"author":"mahisaajy","twitter_card":"summary_large_image","twitter_creator":"@mahisaajy","twitter_site":"@mahisaajy","twitter_misc":{"Written by":"mahisaajy","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#article","isPartOf":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/"},"author":{"name":"mahisaajy","@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c"},"headline":"Memisahkan Sheet di Excel Menjadi File Excel Lain","datePublished":"2018-05-29T15:05:31+00:00","dateModified":"2022-12-29T03:50:11+00:00","mainEntityOfPage":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/"},"wordCount":219,"commentCount":0,"publisher":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c"},"image":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage"},"thumbnailUrl":"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png","articleSection":["BMKG","Excel","Personal","Tutorial"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/","url":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/","name":"Memisahkan Sheet di Excel Menjadi File Excel Lain - Mahisa Ajy Kusuma","isPartOf":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage"},"image":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage"},"thumbnailUrl":"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png","datePublished":"2018-05-29T15:05:31+00:00","dateModified":"2022-12-29T03:50:11+00:00","breadcrumb":{"@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#primaryimage","url":"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png","contentUrl":"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png","width":388,"height":85},{"@type":"BreadcrumbList","@id":"https:\/\/mahisaajy.web.id\/blog\/2018\/05\/memisahkan-sheet-di-excel-menjadi-file-excel-lain\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/mahisaajy.web.id\/blog\/"},{"@type":"ListItem","position":2,"name":"Memisahkan Sheet di Excel Menjadi File Excel Lain"}]},{"@type":"WebSite","@id":"https:\/\/mahisaajy.web.id\/blog\/#website","url":"https:\/\/mahisaajy.web.id\/blog\/","name":"Mahisa Ajy Kusuma","description":"Kewajiban kita lebih banyak dari waktu yang tersedia.","publisher":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/mahisaajy.web.id\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":["Person","Organization"],"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/d9bfa055f34d78537afcc2d6079ff40c","name":"mahisaajy","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/84e68a607b6f3a00fdbccb0e208f3f66e31685e032a45bceac18338a091b5361?s=96&d=monsterid&r=g","caption":"mahisaajy"},"logo":{"@id":"https:\/\/mahisaajy.web.id\/blog\/#\/schema\/person\/image\/"},"description":"Seorang pemuda yang mempunyai hobi menulis, membaca, dan bermusik. Tertarik dengan bidang ilmu komputer untuk memecahkan beberapa persoalan. Sejak tahun 2018 bekerja di BMKG di Direktorat Data dan Komputasi.","sameAs":["http:\/\/mahisaajy.web.id\/blog\/","mahisaajy","https:\/\/x.com\/mahisaajy","mahisaful"],"url":"https:\/\/mahisaajy.web.id\/blog\/author\/mahisaajy\/"}]}},"jetpack_publicize_connections":[],"jetpack_featured_media_url":"https:\/\/mahisaajy.web.id\/blog\/wp-content\/uploads\/2018\/05\/Screenshot-from-2018-05-29-21-27-05.png","jetpack_shortlink":"https:\/\/wp.me\/p3PanY-VB","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts\/3571","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/comments?post=3571"}],"version-history":[{"count":5,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts\/3571\/revisions"}],"predecessor-version":[{"id":4647,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/posts\/3571\/revisions\/4647"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/media\/3574"}],"wp:attachment":[{"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/media?parent=3571"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/categories?post=3571"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mahisaajy.web.id\/blog\/wp-json\/wp\/v2\/tags?post=3571"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}