/ExSQell

Let's running a SQL statement and Shell commands in Excel

Primary LanguageVisual Basic

ExSQell = Excel + SQL + Shell

Let's running a SQL statements and Shell commands in Excel

Usage

  • When you press Ctrl + Q to a cell that is written by SQL statement or shell command , it outputs the run result
  • See "How to Use" sheet for details

Features

  • Run SQL statement
  • DB Object List, Definition Viewer
  • Table Query Editor
  • Table Data Maintenance
  • SQL Beautifier, Converter, Generator
  • Run shell command [New]

Requirement

  • Microsoft Windows
  • Microsoft Excel
  • (Optional: Run Shell Command) Cygwin or Other UNIX Environment Clone
    "Bash on Ubuntu on Windows" only supports 64bit versions of MS-Office

Screenshot

Settings Sheet
ExSQell1.png

Inline Output
ExSQell2.png

Auto Filter Sheet
ExSQell3.png

Licence

MIT

Author

nmrmsys