- Office Namespace
/documentation/pages/Ref/Api/Namespace/Office/index.xml
Classes to read and write Excel documents and example Pages.
- Office Example: Spreadsheet with picture
/documentation/pages/Ref/Api/Namespace/Office/Examples/SpreadsheetWithPicture.xml
This example creates a simple spreadsheet and adds a picture to the workbook, then sets the picture into a cell of the spreadsheet
- Office Example: Multiple spreadsheets
/documentation/pages/Ref/Api/Namespace/Office/Examples/MultipleSpreadsheets.xml
This example creates a multiple spreadsheets in a single document:
- Office Example: Update a spreadsheet
/documentation/pages/Ref/Api/Namespace/Office/Examples/UpdateSpreadsheet.xml
This example demonstrates opening an existing spreadsheet and updating one or more values. First, we generate the same spreadsheet as seen in the simple weekly sales sample. Then we open the spreadsheet and update the Sales and Expense columns.After the spreadsheet is updated, it is opened in Microsoft Excel.
- Office Example: Simple Weekly sales spreadsheet
/documentation/pages/Ref/Api/Namespace/Office/Examples/WeeklySales.xml
This example creates a simple spreadsheet with summarized sales and expense data for a single week. The spreadsheet is populated with a title, column headings, labels, and formulas to calculate the daily gross profit, summarize the weeks sales and expenses and the week's gross profit.
After the spreadsheet is populated, it is opened in Microsoft Excel.
- Office Example: Spreadsheet from SQL query
/documentation/pages/Ref/Api/Namespace/Office/Examples/SpreadsheetFromSQLQuery.xml
An example of a simple spreadsheet from a SQL Query using Alpha's Northwind.mdb.
- Office Namespace Examples
/documentation/pages/Ref/Api/Namespace/Office/Examples/index.xml
A collection of examples demonstrating how to use the Office namespace to perform spreadsheet operations.
- WorldPayAPI Namespace
/documentation/pages/Ref/Api/Namespace/WorldPayAPI/index.xml
Payment processing classes for working with WorldPayAPI.
- "Hello, World" Spreadsheet
/documentation/pages/Ref/Api/Namespace/Office/Examples/HelloWorld.xml
Copy the code below into an Alpha Anywhere Xbasic script and run it.
The code assumes that you have a version of Excel that can handle .XLSX files installed. If you have an older version of Excel, change ExcelDocument to Excel2003Document, and .xlsx to .xls. If you don't have Excel or a compatible spreadsheet program installed, remove the line that starts with sys_open.
- Microsoft Office Functions
/documentation/pages/Ref/Api/Functions/Document Types/Office Functions/index.xml
Functions for creating and working with Microsoft Office files.