|
|
-
Original broadcast date: March 14th, 2007
Controlling Excel using VSTO
With the Visual Studio Tools for Office Visual Studio Add-in, you can control all aspects of any and all applications in the Microsoft Office Suite of products.
This Screencast highlights the use of VSTO to control and design an Excel workbook.
Using VSTO, your development experience in Visual Studio will be just as though you are developing your application in Excel.
Using the VSTO Excel templates, you have full access to all features of Excel as you develop, just as though you were actually in Excel as you were creating your applicaton!
Visual APL is a 100% managed code .Net language, with full integration with Visual Studio. A large part of this integration is the ability to seamlessly cross language bounderies when programming your Solution in Visual Studio. This webcast will show how to use the VSTO templates for C# as the front end of your VSTO application, with Visual APL powering the back end calculations of the workbook operations!
Using the VSTO templates, you can visually design your workbook with Visual Studio designer interfaces, just as you would design a Form for a Windows project using the Visual Studio Forms Designer.
Note: This ScreenCast has not yet been edited for quality assurance. An edited and remastered version will be available for viewing soon.
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Original broadcast date: Feb 28th, 2007
Technologies presented in this screencast:
The general use, creation, and management of the CieloSession project.
Choose which loaded CieloSesison project in your Solution to use as the active back-end of the Cielo Explorer session in Visual Studio.
This screencast is a subset of Screencast: Session Integration, script editing features, and edit variables as XML
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Original broadcast date: Feb 28th, 2007
How to create and use script files in the active CieloSession project from the Cielo Explorer in Visual Studio.
How to use the CieloSession project: Create, Modify
This screencast is a subset of Screencast: Session Integration, script editing features, and edit variables as XML
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Original broadcast date: Feb 28th, 2007
Technologies presented in this screencast:
The session in Visual APL is tightly integrated with Visual Studio, making the process of prototyping and testing code only a keystroke away with the Cielo Explorer.
The creation and organizing of script files used with the Cielo Explorer is also tightly integrated with the Solution Explorer via the CieloSession project type, allowing the developer to take advantage of all features they are accustomed to for arranging and partitioning files in their Visual Studio Solutions. By using multiple CieloSession projects, you can choose which project will be the active project back-end of your Cielo Explorer.
Visual APL allows developers to modify complex array and data structures via the built-in ")xmlout" session command, and modifications made by the developer to the variable in XML form can be saved back to the session for further testing and experimentation. Variables edited using the ")xmlout" command automatically appear in the active CieloSession project as XML data files. You can also load XML data files created during previous editing sessions, allowing data to be persisted across opening and closing Visual Studio.
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
Most .Net languages only allow the importing of .Net assemblies at build time. This means that you can only use the classes, methods, properties, events, etc, of assemblies which exist, on your computer, at the time you build your assembly with Visual Studio. Here is a common example of referencing an assembly:
refbyname System .Windows .Forms using System .Windows .Forms
In Visual APL, you can also import assemblies at runtime using the []reference and []using expressions. By using these system functions, the importing of the specified assemblies is only performed at the moment the []reference or []using function is executed, making it possible for your code to import assemblies that do not or cannot exist at the time you build your assembly. Here is the runtime equivalent of the System.Windows.Forms directive import above:
⎕reference "System.Windows.Forms"
⎕using "System.Windows.Forms"
This screencast is a subset of Screencast: The Using Directive, Expression, and Statement
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
The using statment has an entirely seperate functionallity from the using directive, but has a somewhat similar syntax. Here is an example showing the difference between the using directive and using statement:
// The using directive
using System.IO
// The using statement
using (stream = File.Open( "c:\testfile.txt", FileMode.Create)) {
// some code
}
The purpose of the using statement is to ensure that each argument variable to the statement is disposed of after the statement has completed execution. In the above example, this would mean that the "stream" variable would be disposed of, or have its system resources released, once execution reached the closing brace of the statement.
This screencast is a subset of Screencast: The Using Directive, Expression, and Statement
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
Most .Net languages only allow the importing of .Net assemblies at build time. This means that you can only use the classes, methods, properties, events, etc, of assemblies which exist, on your computer, at the time you build your assembly with Visual Studio. Here is a common example of referencing an assembly:
refbyname System .Windows .Forms using System .Windows .Forms
In Visual APL, you can also import assemblies at runtime using the []reference and []using expressions. By using these system functions, the importing of the specified assemblies is only performed at the moment the []reference or []using function is executed, making it possible for your code to import assemblies that do not or cannot exist at the time you build your assembly. Here is the runtime equivalent of the System.Windows.Forms directive import above:
⎕reference "System.Windows.Forms"
⎕using "System.Windows.Forms"
Next in the screencast is the Using statement. The using statment has an entirely seperate functionallity from the using directive, but has a somwhat similar syntax. Here is an example showing the difference between the using directive and using statement:
// The using directive
using System .IO
// The using statement
using (stream = File.Open( "c:\testfile.txt", FileMode.Create)) {
// some code
}
The purpose of the using statement is to ensure that each argument variable to the statement is disposed of after the statement has completed execution. In the above example, this would mean that the "stream" variable would be disposed of, or have its system resources released, once execution reached the closing brace of the statement.
This screencast also shows how to remap APL keyboard shortcut sequences, allowing you to customize all of the APL character "Alt+" sequences on the keyboard in Visual Studio.
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
How to remap the "Alt+" keyboard shortcut key sequence for any APL character. Via the Visual Studio Options form, you can change the keyboard shortcut for any Visual Studio command.
This screencast is a subset of Screencast: The Using Directive, Expression, and Statement
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
This screencast shows an example of using the Visual Studio Forms Designer to create a simple form, and assign event handlers to events on the form via the designer interface.
This screencast is a subset of Screencast: Windows Interface
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
Using []WI in a Visual APL class. This segment shows the active debugging of the class as it is creating objects and handling events, and also how to use the more advanced features of []WI, such as onNew and onAction.
This screencast is a subset of Screencast: Windows Interface
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
Using []WI in the Visual APL session to create a simple Form, several controls, and set events through []WI. Also shown is how to access the .Net objects created with []WI and set properties and events directly on those objects. Using the object directly, you can set multiple event handlers to fire when a single event occurs.
This screencast is a subset of Screencast: Windows Interface
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
Using []WI in the Visual APL session to create a simple Form, several controls, and set events through []WI. Also shown is how to access the .Net objects created with []WI and set properties and events directly on those objects. Using the object directly, you can set multiple event handlers to fire when a single event occurs.
Using []WI in a Visual APL class. This segment shows the active debugging of the class as it is creating objects and handling events, and also how to use the more advanced features of []WI, such as onNew and onAction.
Finally, this screencast shows an example of using the Visual Studio Forms Designer to create a simple form, and assign event handlers to events on the form via the designer interface.
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
Native .Net replacements for common legacy APL utilities. These include date processing (using System.DateTime), and accessing file system information (Last access time, directory path manipulation, and more via the System.IO namespace.)
This screencast is a subset of Screencast: Using System.
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
Dynamic creation and execution of APL code in Visual APL.
This screencast is a subset of Screencast: Using System.
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
-
Examples presented in this screencast:
The start to finish creation of a simple Visual APL console application which can send SMTP email messages, done using the System.Net.Mail namespace.
To view this webcast directly in Windows Media Player, click on "Direct Link" above.
If you are behind a restrictive firewall, you can view this screencast Here
Viewing directly in Windows Media Player allows the use of all video playback controls, such as skipping over parts of the screencast, and viewing at 2x speed.
|
|
|