Home
SpreadCommander is an application for data analysis using PowerShell. It allows to output text into console that supports rich formatted text, including use of html formatting, output data tables into spreadsheet and powerful grid. It also contains powerful controls for visual data analysis such as Chart, Pivot table and Dashboard.
SpreadCommander is designed for office style data analysis. Rich-text output and using spreadsheets, ability to save results to common formats (.docx, .xlsx, .pdf etc.) allows to generate documents ready for further use (send to clients or collegues etc.).
Using PowerShell as scripting language provides access to many libraries and .Net (Core) assemblies. This allows to use lot of existing code and solve different tasks.
.Net assemblies and Windows .dll files can be placed in %Project%\bin directory and referenced in PowerShell script.
SpreadCommander outputs data into full-featured rich-text editor and allows to directly generate ready-to-use documents and save them into MS Word, RTF, PDF, ePub and other formats. In addition to standard text output SpreadCommander allows to output HTML-formatted text, markdown-formatted text, generate tables in spreadsheet and copy them into console (in single cmdlet), use styles, sections, footnotes and endnotes, add charts, maps and other content and more.
Using spreadsheets is classic and one of most convenient ways for anaylising data. SpreadCommander contains full-feautred spreadsheet. Additional functions such as regular expressions provide ways for more complex work with data.
Spreadsheet is also one of output consoles in SpreadCommander. PowerShell script can output data not only into rich-text console but also into spreadsheet and grid. This allows to analyze table-like structures directly in SpreadCommander, without using third-party applications and without complex code to generate spreadsheet files.
Output data into spreadsheet is very convenient. But sometimes grid is even better. SpreadCommander allows to output data into advanced grid where data can be sorted, filtered, formatted using user-defined conditions and more. Powerful grid as one in SpreadCommander is very convenient when large amount of data needs to be analyzed.
SpreadCommander includes instruments for Visual data analysis. These instruments consist in Chart, PivotGrid and Dashboard.
SpreadCommander provides cmdlets to work with text (csv, fixed-length) data, Microsoft SQL Server, MySQL, SQLite database servers, ODBC and OLEDB data sources. These cmdlets allow to quickly load and save data to these data sources.
Internally SpreadCommander works with ADO.Net DataTable and lists of .Net objects.
SQL is classic way to work with data. SpreadCommander allows to run SQL scripts against most SQL databases, there is enhanced support for Microsoft SQL Server, MySQL and SQLite.
SpreadCommander adds mathematic and statistical functions for SQLite.
SpreadCommander allows to add client-side commands to SQL Script. These commands will not be sent to the server and are used to format output, add conditional formatting, specify grouping etc.
SpreadCommander includes Math.Net Numerics components that provide methods and algorithms for numerical computations in science, engineering and every day use.
SpreadCommander uses Math.Net Symbolics for computer algebra.
