{"id":7301,"date":"2022-09-08T00:15:41","date_gmt":"2022-09-07T18:45:41","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/"},"modified":"2022-09-08T00:15:41","modified_gmt":"2022-09-07T18:45:41","slug":"solved-extract-gz-and-convert-csv-to-xlsx","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/","title":{"rendered":"[Solved] Extract gz and convert csv to xlsx"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-34583415\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"34583415\" data-parentid=\"34516812\" data-score=\"0\" data-position-on-page=\"1\" data-highest-scored=\"1\" data-question-has-accepted-highest-score=\"1\" itemprop=\"acceptedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<p>While I agree the OP does not appear to have done their fair share of figuring this out (how hard is Google?), I know someone else will be looking in the future.  Posting information will help them.<\/p>\n<p>@OP, I&#8217;m not going to do all your file handling work for you but here is the basic code to convert from CSV to XLSX which is probably the least common part of the question posed.<\/p>\n<pre><code>Option Explicit\n\nDim strCSVfile, strExcelFile, FSO\nDim objWorkbook, objWorksheet1\n\nset FSO = CreateObject(\"Scripting.FileSystemObject\")\n\nstrCSVfile = \"C:\\temp\\Excel Test\\myFile.csv\"\nstrExcelFile = \"C:\\temp\\Excel Test\\myFile.xlsb\"  'this was changed\n\nif FSO.FileExists(strCSVfile) then\n   Dim objExcel\n   Set objExcel = CreateObject(\"Excel.Application\")\n\n   objExcel.Visible = False\n   objExcel.displayalerts=false\n\n   'Import CSV into Spreadsheet\n   Set objWorkbook = objExcel.Workbooks.open(strCSVfile)\n   Set objWorksheet1 = objWorkbook.Worksheets(1)\n\n   'Save workbook (51 = 2010 format) \n   'Formats ref https:\/\/msdn.microsoft.com\/en-us\/library\/office\/ff198017.aspx\n   'Parameters ref https:\/\/msdn.microsoft.com\/en-us\/library\/office\/ff841185.aspx \n   objWorksheet1.SaveAs strExcelFile, 50  'this was changed\n   objExcel.Quit()\nelse\n   msgbox \"File Note found\"\nend if\n<\/code><\/pre>\n<p><strong>Edit:<\/strong>  <em>BTW, OP@<\/em>&#8230; post your code and more people will help you.  If you update your question with the code you have written for unzipping and file handling, I will help with that part.<\/p>\n<p><strong>Edit:<\/strong>  Updated for .xlsb format output.  Lines changed marked as such.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved Extract gz and convert csv to xlsx <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] While I agree the OP does not appear to have done their fair share of figuring this out (how hard is Google?), I know someone else will be looking in the future. Posting information will help them. @OP, I&#8217;m not going to do all your file handling work for you but here is the &#8230; <a title=\"[Solved] Extract gz and convert csv to xlsx\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\" aria-label=\"More on [Solved] Extract gz and convert csv to xlsx\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[483,400,2029,1403],"class_list":["post-7301","post","type-post","status-publish","format-standard","hentry","category-solved","tag-csv","tag-excel","tag-gzip","tag-vbscript"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] Extract gz and convert csv to xlsx - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] Extract gz and convert csv to xlsx - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] While I agree the OP does not appear to have done their fair share of figuring this out (how hard is Google?), I know someone else will be looking in the future. Posting information will help them. @OP, I&#8217;m not going to do all your file handling work for you but here is the ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-09-07T18:45:41+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] Extract gz and convert csv to xlsx\",\"datePublished\":\"2022-09-07T18:45:41+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\"},\"wordCount\":137,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"csv\",\"excel\",\"gzip\",\"vbscript\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\",\"name\":\"[Solved] Extract gz and convert csv to xlsx - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-09-07T18:45:41+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] Extract gz and convert csv to xlsx\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] Extract gz and convert csv to xlsx - JassWeb","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:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] Extract gz and convert csv to xlsx - JassWeb","og_description":"[ad_1] While I agree the OP does not appear to have done their fair share of figuring this out (how hard is Google?), I know someone else will be looking in the future. Posting information will help them. @OP, I&#8217;m not going to do all your file handling work for you but here is the ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/","og_site_name":"JassWeb","article_published_time":"2022-09-07T18:45:41+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] Extract gz and convert csv to xlsx","datePublished":"2022-09-07T18:45:41+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/"},"wordCount":137,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["csv","excel","gzip","vbscript"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/","url":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/","name":"[Solved] Extract gz and convert csv to xlsx - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-09-07T18:45:41+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-extract-gz-and-convert-csv-to-xlsx\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] Extract gz and convert csv to xlsx"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/7301","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=7301"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/7301\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=7301"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=7301"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=7301"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}