SSGear v3.40

SSGear is a C# ActiveX User Control that you can embed in your APL+Win Forms.

SSGear lets you display and use any Excel workbook or worksheet from APL+Win and is 100 faster than using Excel.Application.

SSGear includes a huge API allowing you to programmatically create the most complex Excel workbooks from APL+Win.

Requirements

SSGear requires:

  • a version of APL+Win at least equal to v15.1+
  • the .Net Framework v4.5+

Download

Download a fully functional 30-day Trial:

Download »

Versions History

Check the recent changes made to SSGear:

History »

Features

SSGear can be used interactively or through the SSGear ⎕wi API.

  • display the SSGear control in your APL+Win Forms or part of a Form (Selector, Frame)
  • display any Excel .XLS or .XLSX workbook in APL+Win Form or container control
  • includes 2 controls: the SSGear workbook and the SSGear Formula Bar
  • very fast: more than 100 times faster than Excel.Application
  • can create a workbook 1000 worksheets and populate them with data in way less than one second!
  • more than 27000 lines of C# code, 138 properties, 471 methods, 10 events
  • all properties and methods documentation available through ⎕wi
  • with SSGear you can programmatically:
  • • create Excel workbooks
  • • create and display Excel charts
  • • format Excel workbooks (fonts, sizes, colors, orientation, format numbers, palettes, ...)
  • • import Excel workbooks into an APL nested array
  • • import partial Excel workbooks into an APL nested array
  • • load any Excel workbook
  • • load part of any Excel workbook
  • • move charts
  • • save, or save as Excel workbooks
  • • add trend lines to your charts
  • • resize charts
  • • print and print preview
  • • print to PDF
  • • add controls to a worksheet (combo boxes, list boxes, buttons, check boxes, spinners, ...)
  • • add and use filters
  • • add and display cell comments
  • • add and display pictures
  • • add, remove or rename sheets
  • • add cell tooltips
  • • clear ranges, sheet or sheets
  • • cut, copy, paste and paste special
  • • undo, redo
  • • create custom context menus
  • • find, find all or find next occurences of a text
  • • get or set column widths
  • • get or set row heights
  • • autofit column widths abnd/or row heights in ranges or entire sheets
  • • get or set Excel forumlas in cells
  • • get or set Excel ranges
  • • use range names
  • • get or set page breaks
  • • hide or show rows
  • • hide or show columns
  • • hide or show sheets
  • • hide or show the Formula Bar
  • • hide or show the focus rectangle
  • • hide or show filter buttons
  • • hide or show cell tooltips
  • • hide or show scroll bars
  • • hide or show sheet tabs
  • • hide or show borders
  • • protect ot unprotect worksheets and/or workbooks
  • • protect formulas
  • • expand and/or offset ranges
  • • reorder worksheets
  • • scroll to a given location
  • • set alignments in cells or ranges
  • • set borders in cells or ranges
  • • get or set background colors
  • • get or set fixed rows
  • • get or set fixed columns
  • • change the text orientation in cells or ranges
  • • wrap text in cells
  • • show and use the SSGear Designer
  • • show and use the SSGear Explorer
  • • sort rows and/or columns
  • • get or set passwords
  • • get or set printer headings
  • • display dialogs (print, paste special, ...)
  • • remove charts
  • • remove column page breaks or remove row page breaks
  • • remove comments
  • • remove filters
  • • remove sheet or sheets
  • • get or set the DEVMODE printer structure
  • • indent text in cells, ranges
  • • blank zeros in cells, ranges, sheets
  • • autofill ranges
  • • bold, italic, underline, strike out, etc text in cells, ranges, sheets
  • • zoom
  • • set if the Tab key should move down or across
  • • retrieve all sheet names
  • • change sheet names
  • • get or set the current sheet
  • • get or set the current range
  • • get or set the current row, column or cell
  • • get the size of any range of cells
  • • get or set the Print area
  • • get or set the Print bottom margin
  • • get or set the Print file name
  • • get or set the Printer name
  • • get the list of available printer names
  • • get or set if Print pages are to be vertically or horizontally fit
  • • get or set the Print footers
  • • get or set the Print footer margin
  • • get or set the Print headers
  • • get or set the Print header margin
  • • get or set whether grid lines are to be printed
  • • get or set the Print left margin
  • • get or set whether printing has to be done left to right
  • • get or set whether printing has to be done in black and white
  • • get or set the Print paper size
  • • get or set the Print right margin
  • • get or set the Print scale
  • • get or set the Print title rows to be repeated top of each page
  • • get or set the Print title columns to be repeated left of each page
  • • get or set whether Print is to be done to a file rather than printer
  • • get or set the Print top margin
  • • get or set whether the Print page should be horizontally centered
  • • get or set whether the Print page should be vertically centered
  • • get or set the gird line colors
  • • get or set cell or range formulas
  • • get or set the Chart Y scale
  • • get or set whether Chart grid lines are to be displayed
  • • get or set whether Chart horizontal grid lines are to be displayed
  • • get or set whether Chart vertical grid lines are to be displayed
  • • get or set the Chart grid line colors
  • • get or set the Chart legends
  • • get or set whether the Chart legend should be visible
  • • get or set the Chart line weights
  • • get the Chart possible marker types
  • • get or set the Chart marker type
  • • get or set the Chart marker size
  • • get or set whether Chart point labels are visible
  • • get or set the Chart point labels border color
  • • get or set the Chart point labels fill color
  • • get or set the Chart series to be displayed
  • • get or set the Chart series names
  • • get or set the Chart size
  • • get or set the Chart styles
  • • get or set the Chart title
  • • get or set the Chart title font
  • • get the Chart possibles types
  • • get or set the Chart type
  • • get or set the Chart X-axis labels
  • • get or set the Chart X-axis labels font
  • • get or set the Chart X-axis range
  • • get or set the Chart X-axis title
  • • get or set the Chart X-axis title font
  • • get or set the Chart Y-axis labels
  • • get or set the Chart Y-axis labels font
  • • get or set the Chart Y-axis range
  • • get or set the Chart Y-axis title
  • • get or set the Chart Y-axis title font
  • • get or set the Excel workbook name
  • • ... many more properties and methods are available
  • includes a detailed SSGear.chm Help File