Skip to main content
100%

Gist 40be33d9a867660bd732

✓ Published0🌍 Public
Aandybak
Last edited Aug 16, 2014
Created on Aug 16, 2014

This example shows how to export every user table from an Access database to a single Excel workbook. The VBA macro iterates through all table definitions, skipping system tables whose names start with “MSys.” For each remaining table, it calls `DoCmd.TransferSpreadsheet` to export the table’s data into the file `excel_out.xls`, using the `acSpreadsheetTypeExcel9` format. It replaces the `dbo_` prefix in table names when creating the destination worksheet names. The output file path is derived from the current project’s directory.

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
65% match
Loading thumbnail…

Excel Macro for exporting all sheets as csv

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.

LLeeMendelowitz
62% match
Loading thumbnail…

Gist f43601b1f490d87ec6f8

This example shows a Python script that downloads a Google Spreadsheet as a CSV file and prints its rows. The code defines a `Spreadsheet` class and a `Client` class that handles authentication via Google’s ClientLogin API, using `urllib` and `urllib2` for HTTP requests and `re` for parsing the authentication token. It then fetches the spreadsheet’s contents through the Google Sheets export feed, specifying the format as CSV and a worksheet ID, and parses the result with the standard `csv` module. The script demonstrates a straightforward command-line workflow for accessing spreadsheet data programmatically.

Aandybak
57% match
Loading thumbnail…

Exporting data out of Power Query via AdoDb route

This example demonstrates how to export data out of Power Query by directly inserting rows into a SQL Server table through an ADO.NET connection. It uses the `Sql.Database` function to connect to a local server instance and the `Value.NativeQuery` API to execute a parameterized `INSERT` statement, passing literal values for the `@key` and `@value` parameters. The code shows a concrete way to push query results into an external database, bypassing Excel’s native output options. The visible data source is a SQL table named `[dbo].[Demo]`, and the approach highlights ADO.NET’s role in bridging Power Query transformations to persistent storage.

HHugoberry
55% match
Loading thumbnail…

Gist 4b994292f7eab4f3bd2781a92c4978c1

This visualization demonstrates a command-line workflow for exploring a MySQL database using Sqoop. It shows two shell commands that list databases and tables from a remote MySQL server (`ms.itversity.com`), connecting with the `retail_user` account. The first command retrieves available databases via `sqoop list-databases`, while the second lists tables within the `retail_db` database using `sqoop list-tables`. The example relies on Sqoop’s JDBC connector to communicate with MySQL, with credentials passed directly as command-line arguments. No graphical rendering library is involved; the output is purely textual, displaying the database and table names returned by the tool.

Aackuser
55% match
Loading thumbnail…

Gist 44e95c5ae2e212c1b41485ea7e31e0c4

This example shows a Power Query function that connects to an embedded Power BI Desktop tabular model and retrieves session information from the `$SYSTEM.DISCOVER_SESSIONS` dynamic management view. The function first locates the most recently accessed user profile folder, reads the `msmdsrv.port.txt` file to obtain the local port number, then uses that port to list available databases via the `AnalysisServices.Databases` API. It selects the first database and executes the provided DAX query using `AnalysisServices.Database`. The code demonstrates dynamic file system traversal, port discovery, and parameterized Analysis Services queries within the Power Query M language.

HHugoberry
53% match
Loading thumbnail…

Tableau2csv

This example shows how to export a Tableau view’s underlying data to a CSV file via the Tableau REST API. It connects to a Tableau server using personal access tokens, iterates through all workbooks to find a matching workbook and project, then populates the specified view and writes its CSV content to a local file. The script uses the `tableauserverclient` library, with `TSC.Server`, `TSC.PersonalAccessTokenAuth`, `TSC.Pager`, and `server.views.populate_csv` to retrieve the data, and logs success or failure to `tableau2csv.log`.

Aantichaos
53% match
Loading thumbnail…

Gist 6bae1006f0a86eb81bd0914e96710170

This example demonstrates how to inspect and export metadata from Power BI files on macOS without Power BI Desktop. Using the Python library PBIXRay, it loads a `.pbix` file with `on_disk=True` for memory-mapped access, then exports model schema, DAX measures, calculated columns, relationships, and Power Query expressions to CSV files. The code also shows extracting stored table data via `model.get_table()` and pandas DataFrames, with a separate example using `iter_table()` for handling larger models in chunks.

HHugoberry
53% match