[轉載] EXCEL 巨集與VBA介紹

轉載自：EXCEL 巨集與VBA介紹

巨集：一連串的執行指令所構成，可以利用Visual Basic程式指令、也可以利用錄製巨集的方式來錄寫指令。

如何錄製巨集：

1. 如果要執行巨集，則需要更改「EXCEL選項」\「信任中心」\「信任中心設定」\「巨集設定」
2. 在「檢視」、「巨集」/「錄製巨集」
3. 設定「巨集名稱」、快速鍵(Ctrl+英文鍵)，將巨集儲存位置
4. 開始錄製相關動作(錄製是以絕對位址方式來錄製，如果要以相對位址來錄製則要選「以相對位置錄製」)
5. 停止錄製
6. 查看巨集程式碼，並作必要的修正
7. 執行巨集(可以利用「執行巨集」或快速鍵、或利用表單按鈕來執行)，如果要編修表單時，可以按下Ctrl+該物件，進行修改。

---

範例：(錄製巨集)

1. C6至C12的數值格式設定「"進貨" #,##0;"出貨" #,##0」
2. 「檢視」、「巨集」、「開始錄製」，並開始執行下列指令
3. 選取範圍C6至C12，並執行「複製」
4. 選取範圍B6至B12，並按下「選擇性貼上」，選擇貼上「值」與運算「加」
5. 選取範圍C6至C12，並按下「Del」，清除儲存格內容
6. 在儲存格C6按一下
7. 停止錄製巨集
8. 在工作表中，產生一個按鈕，並指定該按鈕執行該巨集，並將其按鈕文字改為異動
9. 每次輸入異動資料(正的表示進貨，負的表示出貨)，按下按鈕即可執行巨集

---

VBA簡介：
Visual Basic for Applications，利用VB來延申Office的能力。開啟EXCEL 顯示開發人員(在「EXCEL選項」/「常用」中勾選)，再撰寫或修改VBA程式。

VBA主要的組成要件：物件，其中包括

1. 屬性：對物件狀態的描述，可以定義物件的特性(大小、顏色、狀態等)。
2. 方法：物件的某些特定動作，可以指定動作的細別內容。其主要結構如下：
   物件.方法 指定引數1:=xl常數1, 指定引數2:=xl常數2,....
   
   指定引數設定為某些內建常數，每個內建常數前會有前綴字連接。
   
   • EXCEL物件的常數會以xl開始。
   • VB的陳述式及函數的常數會以vb開始。
   • Office物件模式的常數會以mso開始。
3. 事件：物件的觸發反應。

---

EXCEL常用的物件

1. Workbook 活頁簿
2. Workbooks 活頁簿集合
3. Workbooks("filename") 檔名為filename的活頁簿
4. ActiveWorkbook 正在作用中的活頁簿
5. Sheets 活頁簿中所有工作表
6. Sheets(n) 活頁簿中第n張工作表
7. Worksheet 工作表
8. Worksheets 所有工作表(包括圖表)
9. Worksheets("sheet") 指表名為sheet工作表
10. ActiveSheet 正在作用中的工作表
11. Columns("c1:c2") c1至c2欄(其中c1,c2為A~Z或AA~XFD等欄名)
12. Rows("r1:r2") r1至r2列(其中r1,r2為1~1048576等列名
13. Range("x1:x2") x1至x2間的儲存格(其中x1,x2為儲存格位址名稱)
14. cells(i,j) 儲存格(第i列、第j行)
15. ActiveCell 目前的儲存格
16. Selection 目前所選取的物件

範例：

Workbooks("Book1").Sheets("Sheet1").Range("A1:D5").Font.Bold = True
Worksheets("Sheet1").Cells.ClearContents
Worksheets("Sheet1").Rows(1).Font.Bold = True
Range("1:1,3:3,8:8")
Worksheets("Sheet1").Cells(6, 1).Value = 10
Worksheets("Sheet1").[A1:B5].ClearContents
ActiveCell.Offset(1, 3).Font.Underline = xlDouble 

---

活頁簿常用屬性：

• ActiveWorkBook.Name 目前活頁簿的名稱
• ActiveWorkBook.Save 儲存目前的活頁簿
• ActiveWorkBook.SaveAs Filename := "filename" 另儲新檔
• WorkBooks.Add 新增活頁簿
• WorkBooks(i).Close [SaveChange, Filename, RouteWorkbook] 關閉指定的第i個活頁簿
  
  • SaveChange := True 改變儲存
  • SaveChange := False 不會改變儲存
  • SaveChange 省略時，會出現對話方塊
  • filename := "檔名"
• WorkBooks.Open "filename" 開啟一個活頁簿
• Application.Windows 所有活頁簿視窗
• WorkBooks.Count 活頁簿的數量
• WorkBooks.Item(Index) 傳回單一活頁簿，由索引值指定

---

工作表常用屬性：

• Worksheets.Add [Before, After, Count, Type] 新增工作表
  
  • Before := Worksheets(n) 出現於某工作表之前
  • After := Worksheets(n) 出現於某工作表之後
  • Count := n 新增工作表數量
  • Type := xlWorksheet (工作表) 或 xlChart (圖表)
• WorkSheets.Name 工作表名稱
• WorkSheets("Sheet1").Activate 設定工作表為目前作用的功作表

---

儲存格常用屬性：

• Rows.RowHeight 指定範圍內的所有列高
• Columns.ColumnsWidth：指定範圍內的所欄寬
• expression.NumberFormatLocal 以本地的數字格式
• Range.CurrentRegion 目前區域是指以任意空白列及空白欄的組合為邊界的範圍
  範例：

  Worksheets("Sheet1").Activate
  ActiveCell.CurrentRegion.Select
  

• expression.Address(RowAbsolute, ColumnAbsolute, ReferenceStyle, External, RelativeTo) 以參照的方式
  
  • RowAbsolute 為True，則用列的絕對位址
  • ColumnAbsolute 為True，則用欄的絕對位址
  • ReferenceStyle 預設值為xlA1，如為xlR1C1則為R1C1的表達方式
• expression.count 傳回範圍的數量(可以是欄數、列數或儲存格數量)
• expression.Item(RowIndex, ColumnIndex) 代表相對於指定之範圍某個位移距離的範圍。
• expression.value 傳回或設定物件的值
• expression.Formula 傳回或設定物件的公式，代表 A1 樣式註解以及巨集語言中的物件公式。
  範例：Worksheets("Sheet1").Range("A1").Formula = "=$A$4+$A$10"
  
• expression.FormulaR1C1 傳回或設定物件的公式，並以巨集語言中的 R1C1 樣式標記法表示
  範例：Worksheets("Sheet1").Range("B1").FormulaR1C1 = "=SQRT(R1C1)"
  
• expression.Text 傳回或設定物件的文字
  範例：

  Set c = Worksheets("Sheet1").Range("B14")
  c.Value = 1198.3
  c.NumberFormat = "$#,##0_);($#,##0)"
  MsgBox c.Value
  MsgBox c.Text
  

---

常用方法：

• Range.Select方法/Selection屬性 設定目前選取的範圍/使用目前所選取的範圍
  範例：

  Sub Macro1()
      Sheets("Sheet1").Select
      Range("A1").Select
      ActiveCell.FormulaR1C1 = "Name"
      Range("B1").Select
      ActiveCell.FormulaR1C1 = "Address"
      Range("A1:B1").Select
      Selection.Font.Bold = True
  End Sub
  

• expression.Copy 將目前所選取的物件復製至剪貼簿
• expression.Cut 將目前所選取的物件剪下
• expression.Delete 將目前所選取的物件刪除
• expression.Paste 將剪貼簿的內容貼上
  範例：

  Sub CopyRow()
      Worksheets("Sheet1").Rows(1).Copy
      Worksheets("Sheet2").Select
      Worksheets("Sheet2").Rows(1).Select
      Worksheets("Sheet2").Paste
  End Sub
  

• expression.RasteSpecial(Paste,Operation, SkipBlanks, Transpose)
  範例：

  With Worksheets("Sheet1")
      .Range("C1:C5").Copy
      .Range("D1:D5").PasteSpecial _
          Operation:=xlPasteSpecialOperationAdd
  End With
  

• Range.Activate 目前的儲存格
• Range.Clear 清除資料
• Range.ClearContents 清除資料內容
• Range.ClearFormats 清除資料格式
• Range.ClearComments 清除註解
• expression.AutoFit 自動調整列高和欄寬
• Range.FillDown、Range.FillUp、Range.FillLeft、Range.FillRight 填滿
• Range.Offset(RowOffset, ColumnOffset) 指定區域的位移列與行
  範例：

  Sub MoveActive()
      Worksheets("Sheet1").Activate
      Range("A1:D10").Select
      ActiveCell.Value = "Monthly Totals"
      ActiveCell.Offset(0, 1).Activate
  End Sub
  

---

程式語法：

• 
  

  Dim 陳述式(變數)

  Dim varname [ As [New] type]
  type 包括 Byte、Boolean、Integer、Long、Single、Double、Date、String、Object等

  Set 陳述式(物件)

  Set objectvar = {[New] objectexpression | Nothing}
  例：Set RangeA = Range("A1:B2")

  範例：

  Sub Random()
      Dim myRange As Range
      Set myRange = Worksheets("Sheet1").Range("A1:D5")
      myRange.Formula = "=RAND()"
      myRange.Font.Bold = True
  End Sub
  

  With 多種屬性設定

  With 物件
      .屬性1 = 設定值
      .屬性2 = 設定值
      ....
  End With

  範例：

  Sub AddNew()
  Set NewBook = Workbooks.Add
      With NewBook
          .Title = "All Sales"
          .Subject = "Sales"
          .SaveAs Filename:="Allsales.xls"
      End With
  End Sub
  

  Array 陣列

  Array(Range1, Range2, ....)

  範例：

  Sub Several()
      Worksheets(Array("Sheet1", "Sheet2", "Sheet4")).Select
  End Sub
  

  InputBox 函數

  InputBox("文字說明",[,title][,default][,xpos][,ypos][,helpfile, context])

  MsgBox 函數

  MsgBox "文字說明"

  Union 將多個範圍合併成單一Range物件

  Union(Range1, Range2, ...)

  範例：

  Sub MultipleRange()
      Dim r1, r2, myMultipleRange As Range
      Set r1 = Sheets("Sheet1").Range("A1:B2")
      Set r2 = Sheets("Sheet1").Range("C3:D4")
      Set myMultipleRange = Union(r1, r2)
      myMultipleRange.Font.Bold = True
  End Sub
  

  For... Next 陳述式

  For counter = start to end [ step stepvalue]
      [statements]
      [Exit For]
      [statements]
  Next [counter]

  範例：

  Sub CycleThrough()
      Dim Counter As Integer
      For Counter = 1 To 20
          Worksheets("Sheet1").Cells(Counter, 3).Value = Counter
      Next Counter
  End Sub
  

  For Each... Next 陳述式

  For Each element In group 
      [statements]
      [Exit For]
      [statements]
  Next [element]

  範例：

  Sub ApplyColor()
      Const Limit As Integer = 25
      For Each c In Range("MyRange")
          If c.Value > Limit Then
              c.Interior.ColorIndex = 27
          End If
      Next c
  End Sub
  

  Do ... Loop 陳述式

  Do [{While | Until} condition]
      [statements]
      [Exit Do]
      [statements]
  Loop

  或

  Do
      [statements]
      [Exit Do]
      [statements]
  Loop [{While | Until} condition]

  If ... Then ... Else ... 陳述式

  If condition Then [statements][Else elsestatements]

  或

  If condition Then
      [statements]
  [ElseIf condition-n Then
      [elseifstatements]...
  [Else
      [elsestatements]]
  End If

---

範例：(VBA程式範例)

Sub pmt_title()
    Dim rate As Single
    Dim nper, i As Integer
    Dim pv, totali, totalp As Double
    Dim start As Date
    Dim color1 As Variant

    start = Range("C2").Value
    pv = Range("C3").Value
    rate = Range("C4").Value
    nper = Range("C6").Value

    '清除所有有明細表
    Range("A11:E65536").Clear

    With Cells(11, 1)
        .Value = 0
        .HorizontalAlignment = xlCenter
        .Interior.Color = RGB(255, 255, 255)
    End With

    With Cells(11, 2)
        .Value = start
        .HorizontalAlignment = xlCenter
        .NumberFormat = "ge年mm月dd日"
    End With

    Cells(11, 5) = pv
    pv1 = pv

    For i = 1 To nper
        If i Mod 2 = 1 Then
            color1 = RGB(255, 255, 150)
        Else
            color1 = RGB(255, 255, 255)
        End If

        With Cells(11 + i, 1)
            .Value = i
            .HorizontalAlignment = xlCenter
            .Interior.Color = color1
        End With

        With Cells(11 + i, 2)
            .Value = DateAdd("m", i, start)
             .HorizontalAlignment = xlCenter
             .Interior.Color = color1
            .NumberFormatLocal = "ge年mm月dd日"
        End With

        With Cells(11 + i, 3)
            .Value = -IPmt(rate / 12, i, nper, pv)
            .Interior.Color = color1
            .NumberFormat = "_-$* #,##0.00_-"
        End With
        totali = totali + Cells(11 + i, 3)

        With Cells(11 + i, 4)
            .Value = -PPmt(rate / 12, i, nper, pv)
            .Interior.Color = color1
            .NumberFormat = "_-$* #,##0.00_-"
        End With
        totalp = totalp + Cells(11 + i, 4)

        With Cells(11 + i, 5)
            .Value = pv - totalp
            .Interior.Color = color1
            .NumberFormat = "_-$* #,##0.00_-"
        End With
    Next i


    With Range(Cells(10, 1), Cells(11 + nper, 5)).Borders
        .LineStyle = xlContinuous
        .Weight = xlThin
        .Color = RGB(0, 0, 0)
    End With
    Cells(12 + nper, 1) = "合計"

    With Range(Cells(12 + nper, 1), Cells(12 + nper, 2))
        .MergeCells = True
        .HorizontalAlignment = xlCenter
        .Interior.Color = RGB(255, 200, 255)
    End With

    With Cells(12 + nper, 3)
        .Value = totali
        .Interior.Color = RGB(255, 200, 255)
        .NumberFormat = "_-$* #,##0.00_-"
    End With

    With Cells(12 + nper, 4)
        .Value = totalp
        .Interior.Color = RGB(255, 200, 255)
        .NumberFormat = "_-$* #,##0.00_-"
    End With

    With Range(Cells(12 + nper, 1), Cells(12 + nper, 4)).Borders
        .LineStyle = xlContinuous
        .Weight = xlThin
        .Color = RGB(0, 0, 0)
    End With

End Sub

'===================================================================
Sub clearall()
    Range("A11:E65536").Clear
End Sub

[轉載] Aptana Scripting 一個背景處理的範例

轉載自：Monkeying with Eclipse | Info Support

/*
 * Menu: Info Support > Find commented code
 * Kudos: Peter Hendriks
 * License: EPL 1.0
 * DOM: http://download.eclipse.org/technology/dash/update/org.eclipse.eclipsemonkey.lang.javascript
 */
function main() {
    loadBundle("org.eclipse.core.jobs");

    var ProgressMonitorDialog = Packages.org.eclipse.jface.dialogs.ProgressMonitorDialog;
    var IRunnableWithProgress = Packages.org.eclipse.jface.operation.IRunnableWithProgress;

    var runnableWithProgress = new IRunnableWithProgress({ run: runCommentSearch });
    new ProgressMonitorDialog(window.getShell()).run(true, true, runnableWithProgress);

    window.getActivePage().showView("org.eclipse.ui.views.TaskList");
}

function runCommentSearch(monitor) {
    var files = resources.filesMatching(".*\\.java");
    monitor.beginTask("Searching for commented code...", files.length);
    try {
        var match;
        for each( file in files ) {
            monitor.subTask(file.getEclipseObject().getName());
            file.removeMyTasks();
            var previousLineCodeComment = false;
            for each( line in file.lines ) {
                if (monitor.isCanceled()) {
                    return;
                }
                if (match = line.string.match(/^.*\/\/.*[;{}]\s*$/)) {
                    if (!previousLineCodeComment) {
                        line.addMyTask("Commented code: " + match[0]);
                    }
                    previousLineCodeComment = true;
                } else {
                    previousLineCodeComment = false;
                }
            }
            monitor.worked(1);
        }
    } finally {
        monitor.done();
    }
}

Aptana Scripting - Find TODOs 範例中的參數

/*
 * Menu: Editors > Find TODOs
 * Kudos: Ingo Muschenetz
 * License: EPL 1.0
 * DOM: http://download.eclipse.org/technology/dash/update/org.eclipse.eclipsemonkey.lang.javascript
 */

function main() {
    var files = resources.filesMatching(".*\\.js");
    var match;

    for each( file in files ) {
        file.removeMyTasks( );
        for each( line in file.lines ) {
            if (match = line.string.match(/\/\/TODO: (.*)/)) {
                line.addMyTask( match[1] );
            }
        }
    }
    window.getActivePage().showView("org.eclipse.ui.views.TaskList");
}

只列出當前文件的方法

var files = resources.filesMatching('.*/'+editors.activeEditor.textEditor.titleToolTip);

resources 部分的方法

filesMatching(".*\\.js")
filesMatchingForProject("Project Name",".*\\.js")
filesMatchingIgnoreCase(".*\\.js")
filesMatchingForProjectIgnoreCase("Project Name",".*\\.js")

file 部分的方法

size
lines
removeMyTasks()

line 部分的方法

lineNumber
string
addMyTask('Task String')

Aptana Scripting 學習筆記

• 在任何一個專案的頂層目錄，建立一個名稱為 scripts 或 monkey 的目錄
• 在此目錄下建立副檔名為 *.js 或 *.em 的 JavaScript 的文件

一個空白文件的內容如下：

/*
 * Menu: Samples > Execute Snippet
 * Key: M1+M2+M3+F
 * Kudos: Jax Hu
 * License: EPL 1.0
 * DOM: http://download.eclipse.org/technology/dash/update/org.eclipse.eclipsemonkey.lang.javascript
 */

function main(){
}

快捷鍵的代號對應：

M1	Control/Command
M2	Shift
M3	Alt/Option

一個可以用來顯示物件成員的函數：

/**顯示物件的成員
 * @param {Object} val 物件
 */
function var_dump(val){
    var name, value, temp=[];

    for (name in val) {
        try {
            value = (val[name]+'').
                replace("function",'<b style="color:#00f;">$&</b>');
        }catch (e) {
            value = (e+'').fontcolor('red');
        }
        temp.push('<b style="color:#707;">'+name+'</b> = '+value);
    }

    webView = views.getView("var_dump");
    webView.showView(true);
    webView.setTitle('var_dump');
    webView.setHTML(temp.join("<hr/>").fixed());
}

常用方法以及數值：

/*當前文件的位置
 * => D:/WorkSpace/my_project/test.js */
location

/*當前文件的名稱
 * => test.js */
editors.activeEditor.title

/*當前的文件內容*/
editors.activeEditor.source

/*當前文件的 URI 位址*/
editors.activeEditor.uri

/*儲存當前文件*/
editors.activeEditor.save();

/*對當前文件-開啟另存新檔的對話匡*/
editors.activeEditor.textEditor.doSaveAs()

/*對當前文件的目錄路徑
 * => D:/WorkSpace/my_project */
editors.activeEditor.textEditor.editorInput.file.parent.location

/*目前開啟的所有文件*/
editors.all[];

/*儲存全部編輯器，傳入 true 會開啟存檔提示*/
window.workbench.saveAllEditors(false);

/*重新開啟 Eclipse*/
window.workbench.restart();

/*關閉 Eclipse*/
window.workbench.close();

/* 開新的編輯器，可以透過這個開啟空白文件，或是已經存在的檔案，
 * 之後 editors.activeEditor 會轉到這個文件上 */
fileUtils.open('textile_to_redmine.txt');

/*取得當前的專案名稱*/
editors.activeEditor.textEditor.editorInput.file.project.name;

/*取得所有的專案*/
Packages.org.eclipse.core.resources.ResourcesPlugin.workspace.root.projects;
editors.activeEditor.textEditor.editorInput.file.workspace.root.projects

建立一個新的視圖，或開啟已存在的視圖:

webView = views.getView("my_view_name");

/*顯示視圖*/
webView.showView(true);

/*設定標題*/
webView.setTitle("My View Title");

/*設定內容的HTML*/
webView.setHTML('<h1>OK</h1>');

/*或指定內容的網址*/
webView.url = "http://www.google.com";
webView.addEventListener("LocationChanging", function(event){
    var location = event.innerEvent.location;

    // Print out the location to the Java console
    Packages.java.lang.System.out.println("You clicked on: " + location);
});

替換選擇的文字區段:

/*選擇的起始位置*/
var starting = editors.activeEditor.selectionRange.startingOffset;

/*選擇的結束位置*/
var ending = editors.activeEditor.selectionRange.endingOffset;

/*選擇的文字內容*/
var text = editors.activeEditor.source.substring(starting, ending);

/*文字跳脫處理，或其他自訂的處理*/
text = escape(text);

/*替換選擇的文字*/
editors.activeEditor.applyEdit(starting, ending-starting, text);

/*重新選擇文字區段*/
editors.activeEditor.selectAndReveal(starting, text.length);

檔案存取:

var file = new File("myFile.txt");
file.createNewFile();
file.write("Date: ");
var text = file.readLines();

Web 資料請求的方式:

var req = new WebRequest();
req.open("GET", "http://xml.weather.yahoo.com/forecastrss?p=94103");
var text = req.send();

[轉載] Aptana Scripting File.js Class Document

轉載自：Koders Code Search: File.js - JavaScript

/**
 * File.js
 *
 * Adding this file to your Active Libraries will give you code assist for the
 * Aptana Studio scripting engine.
 *
 * @author Kevin Lindsey
 * @version 1.0
 */

/**
 * This object represents a file or a directory in the file system
 *
 * @constructor
 * @param {String} name
 *      The relative or absolute path to a file or directory
 */
function File(name) {}

/*
 * Properties
 *

/**
 * Get the absolute path for this file or directory
 *
 * @type {String} Returns the absolute path to this file or directory
 */
File.prototype.absolutePath = "";

/**
 * Get the file's base name. This is the filename only without the extension.
 * If the file does not have an extension, then this will return the full
 * name
 *
 * @type {String} Returns this file's base name
 */
File.prototype.baseName = "";

/**
 * Determine if this file is readable
 * 
 * @type {Boolean} Returns true if this File is readable
 */
File.prototype.canRead = false;

/**
 * Determine if ths file is writable
 * 
 * @type {Boolean} Returns true if this File is writable
 */
File.prototype.canWrite = false;

/**
 * Determine if this file or directory exists in the file system
 *
 * @type {Boolean} Returns true if this File exists in the file system
 */
File.prototype.exists = false;

/**
 * Returns the file extension of this File
 *
 * @type {String} Returns the last instance of "." and the text after it.
 *      An empty string will be returned if no extension if found. The return
 *      value includes the '.'
 */
File.prototype.extension = "";

/**
 * Determines if thie File is a file in the file system
 *
 * @type {Boolean} Returns true if this File is a file in the file system
 */
File.prototype.isFile = false;

/**
 * Determines if this File is a directory in the file system
 *
 * @type {Boolean} Returns true if this File is a directory in the file
 *      system
 */
File.prototype.isDirectory = false;

/**
 * Returns a list of File objects for all files in the File. This is equivalent
 * to listing out all files in a directory
 *
 * @type {Array} Returns an array of File objects, one for each file and
 *      directory in this File
 */
File.prototype.list = [];

/**
 * Returns the file's name without path information
 *
 * @type {String} Returns the file's name
 */
File.prototype.name = "";

/**
 * Returns a new File object of this object's parent directory
 *
 * @type {File} Returns this file's parent File
 */
File.prototype.parentFile = {};

/**
 * Returns the character used to separate directories on the underlying OS
 *
 * @type {String} Returns the directory separator
 */
File.prototype.separator = "";

/*
 * Methods
 */

/**
 * Create a new file in the file system at the location specified by this
 * object
 *
 * @return {Boolean} Returns true if the file was created successfully.
 */
File.prototype.createNewFile = function() {};

/**
 * Return all lines from this File's text file
 * 
 * @return {Array} Returns an array of strings, one for each line in the file.
 */
File.prototype.readLines = function() {};


//eof

[轉載] Aptana Scripting PrintStream.js Class Document

轉載自：Koders Code Search: PrintStream.js - JavaScript

/**
 * PrintStream.js
 *
 * Adding this file to your Active Libraries will give you code assist for the
 * Aptana Studio scripting engine.
 *
 * @author Kevin Lindsey
 * @version 1.0
 */

/**
 * This object represents an underlying Java PrintStream
 *
 * @constructor
 *
 /
function PrintStream() {}

/*
 * Methods
 */

/**
 * Print the given text to the underlying stream
 *
 * @param {String} text
 *      The text to send to the stream
 */
PrintStream.prototype.print = function(text) {};

/**
 * Print the given text to the underlying stream followed by end-of-line
 *
 * @param {String} text
 *      The text to send to the stream
 */
PrintStream.prototype.println = function(text) {};


//eof

[轉載] Aptana Scripting Editor.js Class Document

轉載自：Koders Code Search: Editor.js - JavaScript

/**
 * Editor.js
 *
 * Adding this file to your Active Libraries will give you code assist for the
 * Aptana Studio scripting engine.
 *
 * @author Kevin Lindsey
 * @version 1.0
 */

/**
 * Editor
 *
 * @constructor
 * @extends {EventTarget}
 */
function Editor() {}

/*
 * Properties
 */

/**
 * Get/set the position of the cursor in this editor
 * 
 * @type {Number} The current cursor offset position
 */
Editor.prototype.currentOffset = 0;

/**
 * Get the File object that this editor is editing
 *
 * @type {File} Returns a File object or undefined
 */
Editor.prototype.file = {};

/**
 * Get the language MIME type for this editor
 * 
 * @type {String} Returns this editors language type
 */
Editor.prototype.language = "";

/**
 * Get the lexemes associated with this editor
 *
 * @type {Array} Returns an array of Lexemes
 */
Editor.prototype.lexemes = [];

/**
 * Get the line delimiter for this editor
 * 
 * @type {String} Returns the editor's line terminator
 */
Editor.prototype.lineDelimiter = "";

/**
 * Get the source associated with this editor
 *
 * @type {String} Returns the source text in this editor
 */
Editor.prototype.source = "";

/**
 * Get the length of the source in this editor
 * 
 * @type {Number} Returns the number of characters in this editor's document
 */
Editor.prototype.sourceLength = 0;

/**
 * Get the number of columns in a tab
 * 
 * @type {Number} Returns the number of spaces that equal one tab
 */
Editor.prototype.tabWidth = 0;

/**
 * Get the zero-based line number of the line at the top of the editor
 * 
 * @type {Number} The top-most line's index
 */
Editor.prototype.topIndex = 0;

/**
 * Get/set the editor's word wrap setting. Setting this to true turns on word
 * wrapping.
 * 
 * @type {Boolean} The word wrap setting.
 */
Editor.prototype.wordWrap = false;

/*
 * Methods
 */
 
/**
 * Apply an edit to the current document. This function allows you to delete
 * and insert text in one operation, if desired.
 *
 * @param {Number} offset
 *      The offset within the source where this edit is to take place
 * @param {Number} deleteLength
 *      The number of characters to remove before inserting the new text
 * @param {String} insertText
 *      The new text to insert at the given offset
 */
Editor.prototype.applyEdit = function(offset, deleteLength, insertText) {};

/**
 * Get the zero-based line number at the specified character offset
 * 
 * @param {Number} offset
 *       The character offset within the editor's document
 */
Editor.prototype.getLineAtOffset = function(offset) {};

/**
 * Scroll the editor to bring the current selection or caret position into
 * view.
 */
Editor.prototype.showSelection = function() {};


//eof

[轉載] Aptana Scripting Global.js Document

轉載自：Koders Code Search: Global.js - JavaScript

/**
 * Global.js
 *
 * Adding this file to your Active Libraries will give you code assist for the
 * Aptana Studio scripting engine.
 *
 * @author Kevin Lindsey
 * @version 1.0
 */
 
/*
 * Properties
 */

/**
 * Retrieve the Editors object to access editors and editor events
 *
 * @type {Editors} Returns the global Editors object
 */
var editors = {};

/**
 * Retrieve the error print stream.
 *
 * @type {PrintStream} Returns the output stream used to display errors
 */
var err = {};

/**
 * This is a reference to the only instance of this object. All scripts run in
 * their own protected scope. However, this Global is accessible from all
 * scripts. Properties placed on "global" will be accessible to all scripts
 *
 * @type {Global} Returns a reference to the global scope
 */
var global = {};

/**
 * Retrieve the Menus object to access menus and menu events
 *
 * @type {Menus} Returns the global Menus object
 */
var menus = {};

/**
 * Retrieve the standard output print stream.
 *
 * @type {PrintStream} Returns the standard output stream
 */
var out = {};

/**
 * Retrieve the View object to access views and view events
 *
 * @type {Views} Returns the global Views object
 */
var views = {};

/*
 * Methods
 */

/**
 * Display an alert dialog with the given message
 *
 * @param {String} message
 *      The message to display in the dialog
 */
var alert = function(message) {};

/**
 * Execute a string in the current shell. This is experimental and may be
 * removed in a future version of the scripting environment
 *
 * @param {String} command
 *      The command to execute in the shell
 * @return {Object} Returns an object with the following properties: code,
 *      stdout, stderr. Code is the return code from the command. Stdout
 *      contains any text that was emitted to standard out while it was
 *      executing. Likewise, stderr contains any errors that were emitted.
 */
var execute = function(command) {};

/**
 * Call Java's System.getProperty.
 *
 * @param {String} property
 *      The name of the property to retrieve
 * @return {String} Returns the specified property value or the string
 *      "undefined" if the property does not exist
 */
var getProperty = function(property) {};

/**
 * Include a JavaScript file into the current script's scope. this is used to 
 * load dependent libraries into the script that invokes this function.
 * 
 * @param {String} filename
 *      The name of the file to include in the script
 */
var include = function(filename) {};

/**
 * Load a library into the scripting environment. Each script loaded with this
 * function will be assigned a unique ID and, if it exists, the init() function
 * will be invoked. This gives each script the ability to initialize itself and
 * to setup any event listeners it wishes to subscribe to.
 *
 * Each script will exist in its own scope; however, this Global is also
 * included in the scope chain. All variables and functions defined in the
 * script will not collide with any other scripts.
 *
 * Shared properties can be placed on the "global" property. All scripts loaded
 * via this function will then be able to see those properties. This can be
 * used to share data between scripts.
 *
 * @param {String} filename
 *      The file system path to the script to load
 * @return {String} Returns a unique string identifier for the loaded script.
 *      This identifier can be used later to invoke functions within the
 *      script; however, this is more for internal use at this point. If the
 *      script fails to load, this will return undefined.
 */
var loadBundle = function(filename) {};


//eof