Excel Macro for exporting all sheets as csv

100%

Excel Macro for exporting all sheets as csv

✓ Published0🌍 Public

Last edited Apr 8, 2016

Created on Apr 8, 2016

This example presents a VBA macro that exports every worksheet in an Excel workbook to a separate CSV file. It iterates through each sheet using a `For Each` loop over `Application.ActiveWorkbook.Worksheets`. For each sheet, it copies the sheet to a new workbook and saves it with the sheet’s name using the `SaveAs` method with `FileFormat:=xlCSV`. The macro then closes the temporary workbook, leaving the original file untouched.

AI-generated description

Similar vizzes

Loading thumbnail…

Gist d2f55e96546318a1e8e393d423ea36e9

This example shows a SQL query that transfers data from one Excel sheet to another, creating a new table in a separate workbook file. The visualization demonstrates how data can be exported or copied between spreadsheet locations using an embedded query. The code uses the `SELECT * INTO` syntax with an `[Excel 8.0;DATABASE=...]` connection string, specifying the destination file path and sheet name. The query pulls all records from the source sheet and writes them to the target workbook, illustrating a straightforward data-migration pattern. The rendering approach relies on the database driver’s handling of the Excel file format, with no additional charting or graphics libraries involved.

HHugoberry

54% match

Loading thumbnail…

Convert powerpoint slides to images in VBA

This example shows how to batch-convert every slide in a PowerPoint presentation into JPEG images. The VBA macro iterates through all slides in the active presentation, exporting each one with a fixed output size of 2667 by 1500 pixels. The code uses the `Slide.Export` method, which is part of the PowerPoint object model, and references the `ActivePresentation` object. The filenames include a zero-padded slide index to preserve order. The macro relies on the built-in VBA `For Each` loop and the `Format` function to generate sequential names, with the output directory hardcoded as "Z:\". This approach automates slide-to-image conversion without manual screen captures.

CChristosT

53% match

Loading thumbnail…

Using R.Execute() in Power Query to export the contents of a table to CSV

This example demonstrates how to use R.Execute() in Power Query to export a table’s contents to a CSV file. The code generates a seed list of numbers from 1 to 1,000,000, converts it into a table, and then passes that dataset to R’s write.csv() function via the R.Execute() API. The R script writes the data to a specified file path. The visualization highlights the integration between Power Query and R, showing how R’s data-export capabilities can be invoked directly within a query pipeline, without additional manual steps.

HHugoberry

51% match

Loading thumbnail…

csv concatenation

This example demonstrates the simple concatenation of multiple CSV files into a single output file, combining rows from all input files without any transformation or filtering. The script uses the `csv.reader` and `csv.writer` APIs from Python’s standard library to parse and write each row, while the `glob` module collects every `.csv` filename in a specified directory, and `os.chdir` changes the working directory to that folder. All rows are appended into a flat list, then written to a designated output path. The visualization shows the raw data-merging process, not a graphical chart, and relies solely on file I/O and CSV handling.

IIanHopkinson

50% match

Loading thumbnail…

Quick node.js script to convert a CSV file to HTML

A quick Node.js script converts CSV spreadsheet data into standalone HTML pages by applying a template to each row. It uses the `csv` library to parse an input file with named columns and the `ejs` templating engine, configured with curly braces, to interpolate row values into the output. The script validates file extensions (`.csv`, `.ejs`, `.html`) and writes the rendered templates to a single output file, joining them with platform-appropriate line endings. The example includes a template that displays each item’s title, link, source, and year as formatted HTML.

RRandomEtc

49% match

Loading thumbnail…

Writing 10M lines of a query result to a table in Power Query via R

This example demonstrates how to write 10 million rows of a query result to a CSV file from Power Query by invoking an R script. It shows the integration of Power Query’s table generation with R’s file-export capabilities, specifically using the `R.Execute` function to run `write.csv` on a dataset. The Power Query code creates a list of numbers from 1 to 10,000,000 via `{1..10000000}`, converts it to a table with `Table.FromList`, and passes that table as the `dataset` parameter to the R script. The R script then writes the data to `d:\Downloads\out.csv`.

HHugoberry

49% match

Loading thumbnail…

Loading CSV data

This example demonstrates how to fetch a CSV file from a Google Sheets public URL and log its contents to the browser console. The code uses native JavaScript `fetch()` and `async`/`await` syntax to retrieve the text, avoiding external libraries. It features a simple HTML page with a centered "Hello CSV Fetch" heading and large font styling. The data source is a Google Sheets CSV export endpoint, and the fetched text is printed via `console.log()`. Two commented-out alternative promise-based approaches are also shown, though the active implementation is the async/await version.

KKelly Egan

48% match

Loading thumbnail…

Gist 585199

This visualization loads an external CSV file and parses its rows into JavaScript objects, mapping each column name from an array to the corresponding values in each line. It handles quoted fields that contain commas by merging split segments until the quote count is even, and it logs warnings for malformed lines that do not match the expected number of columns. The example demonstrates a reusable CSV-asynchronous-loading helper, but does not show any charting, layout, or rendering code beyond the data preparation stage.

RRandomEtc

48% match