Skip to content

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

Notifications You must be signed in to change notification settings

nmrmsys/ExSQell

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

14 Commits
 
 
 
 
 
 
 
 

Repository files navigation

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

About

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

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published