Excel_Convert Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   Excel_Convert
( FilePath:STRING ) :STRING ;

Python:

def  vs.Excel_Convert(FilePath):
   return STRING

Description:

Convert Excel file to tab delimited text file.

説明

Excelファイルをタブ区切り形式のテキストファイルに変換します。



  EXL_AddSheet Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_AddSheet
( sheetName:STRING ) :BOOLEAN ;

Python:

def  vs.EXL_AddSheet(sheetName):
   return BOOLEAN

Description:

Add a sheet. If a sheet with this name exists, it will be overwritten.

説明

シートを追加します。同じ名前のシートが存在する場合は上書きされます。



  EXL_CloseBook Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_CloseBook
:BOOLEAN ;

Python:

def  vs.EXL_CloseBook():
   return BOOLEAN

Description:

Save and closes the Excel file.

説明

Excelファイルを保存して閉じます。



  EXL_DeleteSheet Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_DeleteSheet
( sheetName:STRING ) :BOOLEAN ;

Python:

def  vs.EXL_DeleteSheet(sheetName):
   return BOOLEAN

Description:

Delete the sheet with the specified name.

説明

指定した名前のシートを削除します。



  EXL_GetCellAlignment Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellAlignment
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outAlignmentH :INTEGER;
  VAR  outAlignmentV :INTEGER;
  VAR  outTextAngle :INTEGER;
  VAR  outWrapTextFlag :BOOLEAN;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellAlignment(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outAlignmentH, outAlignmentV, outTextAngle, outWrapTextFlag, outInconsistencyFound)

Description:

Get cell horizontal and vertical alignment, text angle, is text wrapped and is inconsistency found.

説明

指定したセルの水平と垂直方向の配置、文字列の方向、文字の折り返し、不一致の有無を返します。



  EXL_GetCellBordeDiff Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellBordeDiff
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellBordeDiff(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outInconsistencyFound)

Description:

Check is inconsistency found on cell borders.

説明

指定したセルの罫線で不一致があるかどうかを返します。



  EXL_GetCellBorderB Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellBorderB
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outWeight :INTEGER;
  VAR  outColor :INTEGER;
  VAR  outEnabled :BOOLEAN;
  VAR  outStyle :INTEGER
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellBorderB(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outWeight, outColor, outEnabled, outStyle)

Description:

Get cell bottom border - weight, color, is enable and style.

説明

指定したセルの下枠の太さ、色、有効/無効、スタイルを返します。



  EXL_GetCellBorderL Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellBorderL
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outWeight :INTEGER;
  VAR  outColor :INTEGER;
  VAR  outEnabled :BOOLEAN;
  VAR  outStyle :INTEGER
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellBorderL(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outWeight, outColor, outEnabled, outStyle)

Description:

Get cell left border - weight, color, is enable and style.

説明

指定したセルの左枠の太さ、色、有効/無効、スタイルを返します。



  EXL_GetCellBorderR Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellBorderR
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outWeight :INTEGER;
  VAR  outColor :INTEGER;
  VAR  outEnabled :BOOLEAN;
  VAR  outStyle :INTEGER
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellBorderR(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outWeight, outColor, outEnabled, outStyle)

Description:

Get cell right border - weight, color, is enable and style.

説明

指定したセルの右枠の太さ、色、有効/無効、スタイルを返します。



  EXL_GetCellBorderT Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellBorderT
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outWeight :INTEGER;
  VAR  outColor :INTEGER;
  VAR  outEnabled :BOOLEAN;
  VAR  outStyle :INTEGER
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellBorderT(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outWeight, outColor, outEnabled, outStyle)

Description:

Get cell top border - weight, color, is enable and style.

説明

指定したセルの上枠の太さ、色、有効/無効、スタイルを返します。



  EXL_GetCellFill Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellFill
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outStyle :INTEGER;
  VAR  outBgColor :INTEGER;
  VAR  outFgColor :INTEGER;
  VAR  outFillpattern :INTEGER;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellFill(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outStyle, outBgColor, outFgColor, outFillpattern, outInconsistencyFound)

Description:

Get cell fill style, background color, foreground color, fill pattern and is inconsistency found.

説明

指定したセルの面の属性、背景色、前景色、模様、不一致の有無を返します。



  EXL_GetCellFont Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellFont
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outFontStyle :INTEGER;
  VAR  outFontSize :INTEGER;
  VAR  outFontIndex :INTEGER;
  VAR  outTextColorIndex :INTEGER;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellFont(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outFontStyle, outFontSize, outFontIndex, outTextColorIndex, outInconsistencyFound)

Description:

Get cell font style, font size, font index, text color index and is inconsistency found.

説明

指定したセルのフォントスタイル、フォントサイズ、フォントインデックス、文字の色のインデックス、不一致の有無を返します。



  EXL_GetCellStyle Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellStyle
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outNumStyleClass :INTEGER;
  VAR  outAccuracy :INTEGER;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellStyle(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outNumStyleClass, outAccuracy, outInconsistencyFound)

Description:

Get cell number style class, accuracy and is inconsistency found.

説明

指定したセルの番号スタイルクラス、小数点桁数、不一致の有無を返します。



  EXL_GetCellValue Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetCellValue
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
  VAR  outFormula :STRING;
  VAR  outString :STRING;
  VAR  outLeaderStr :STRING;
  VAR  outTrailerStr :STRING;
  VAR  outValue :REAL
) :BOOLEAN ;

Python:

def  vs.EXL_GetCellValue(sheetIndex, cellRow, cellColumn):
   return (BOOLEAN, outFormula, outString, outLeaderStr, outTrailerStr, outValue)

Description:

Get cell formula, string, leader string, trailer string and value.

説明

指定したセルの形式、ストリング、リーダーストリング、トレーラーストリングと値を返します。



  EXL_GetSheetCnt Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetSheetCnt
( VAR outSheetCount:INTEGER ) :BOOLEAN ;

Python:

def  vs.EXL_GetSheetCnt():
   return (BOOLEAN, outSheetCount)

Description:

Get counts of Excel sheets.

説明

Excelシートの枚数を返します。



  EXL_GetSheetIndex Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetSheetIndex
(   sheetName :STRING;
  VAR  outSheetIndex :INTEGER
) :BOOLEAN ;

Python:

def  vs.EXL_GetSheetIndex(sheetName):
   return (BOOLEAN, outSheetIndex)

Description:

Gets index of the Excel sheet.

説明

Excelシートのインデックスを返します。



  EXL_GetSheetName Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetSheetName
(   sheetIndex :INTEGER;
  VAR  outSheetName :STRING
) :BOOLEAN ;

Python:

def  vs.EXL_GetSheetName(sheetIndex):
   return (BOOLEAN, outSheetName)

Description:

Get name of Excel sheets.

説明

Excelシートの名前を返します。



  EXL_GetSheetSize Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_GetSheetSize
(   sheetIndex :INTEGER;
  VAR  outRows :INTEGER;
  VAR  outColumns :INTEGER
) :BOOLEAN ;

Python:

def  vs.EXL_GetSheetSize(sheetIndex):
   return (BOOLEAN, outRows, outColumns)

Description:

Get size of Excel sheets.

説明

Excelシートのサイズを返します。



  EXL_IsCellValid Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_IsCellValid
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER
) :BOOLEAN ;

Python:

def  vs.EXL_IsCellValid(sheetIndex, cellRow, cellColumn):
   return BOOLEAN

Description:

Check is cell in range of Excel sheets.

説明

指定したExcelシートの指定した範囲のセルが有効かどうかを返します。



  EXL_NewBook Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_NewBook
( filePath:STRING ) :BOOLEAN ;

Python:

def  vs.EXL_NewBook(filePath):
   return BOOLEAN

Description:

Create a new Excel file.

説明

新しいExcelファイルを作成します。



  EXL_ReadFile Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_ReadFile
( FilePath:STRING ) :BOOLEAN ;

Python:

def  vs.EXL_ReadFile(FilePath):
   return BOOLEAN

Description:

Read Excel file.

説明

Excelファイルを読み込みます。



  EXL_SaveAndCloseBook Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SaveAndCloseBook
( filePath:STRING ) :BOOLEAN ;

Python:

def  vs.EXL_SaveAndCloseBook(filePath):
   return BOOLEAN

Description:

Save and closes the Excel file.

説明

Excelファイルを保存して閉じます。



  EXL_SetCellAlignment Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellAlignment
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    AlignmentH :INTEGER;
    AlignmentV :INTEGER;
    TextAngle :INTEGER;
    WrapTextFlag :BOOLEAN;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellAlignment(sheetIndex, cellRow, cellColumn, AlignmentH, AlignmentV, TextAngle, WrapTextFlag):
   return (BOOLEAN, outInconsistencyFound)

Description:

Set cell horizontal and vertical alignment, text angle, is text wrapped and is inconsistency found.

説明

指定したセルの水平と垂直方向の配置、文字列の方向、文字の折り返しを設定し、不一致の有無を返します。



  EXL_SetCellBorderB Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellBorderB
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    weight :INTEGER;
    color :INTEGER;
    style :INTEGER;
    enabled :BOOLEAN;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellBorderB(sheetIndex, cellRow, cellColumn, weight, color, style, enabled):
   return (BOOLEAN, outInconsistencyFound)

Description:

Set cell bottom border - weight, color, enable and style.

説明

指定したセルの下枠の太さ、色、有効/無効、スタイルを設定します。



  EXL_SetCellBorderL Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellBorderL
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    weight :INTEGER;
    color :INTEGER;
    style :INTEGER;
    enabled :BOOLEAN;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellBorderL(sheetIndex, cellRow, cellColumn, weight, color, style, enabled):
   return (BOOLEAN, outInconsistencyFound)

Description:

Set cell left border - weight, color, enable and style.

説明

指定したセルの左枠の太さ、色、有効/無効、スタイルを設定します。



  EXL_SetCellBorderR Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellBorderR
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    weight :INTEGER;
    color :INTEGER;
    style :INTEGER;
    enabled :BOOLEAN;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellBorderR(sheetIndex, cellRow, cellColumn, weight, color, style, enabled):
   return (BOOLEAN, outInconsistencyFound)

Description:

Set cell right border - weight, color, enable and style.

説明

指定したセルの右枠の太さ、色、有効/無効、スタイルを設定します。



  EXL_SetCellBorderT Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellBorderT
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    weight :INTEGER;
    color :INTEGER;
    style :INTEGER;
    enabled :BOOLEAN;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellBorderT(sheetIndex, cellRow, cellColumn, weight, color, style, enabled):
   return (BOOLEAN, outInconsistencyFound)

Description:

Set cell top border - weight, color, enable and style.

説明

指定したセルの上枠の太さ、色、有効/無効、スタイルを設定します。



  EXL_SetCellFont Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellFont
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    fontStyle :INTEGER;
    fontSize :INTEGER;
    fontIndex :INTEGER;
    textColorIndex :INTEGER;
  VAR  outInconsistencyFound :BOOLEAN
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellFont(sheetIndex, cellRow, cellColumn, fontStyle, fontSize, fontIndex, textColorIndex):
   return (BOOLEAN, outInconsistencyFound)

Description:

Set cell font style, font size, font index, text color index and is inconsistency found.

説明

指定したセルのフォントスタイル、フォントサイズ、フォントインデックス、文字の色のインデックスを設定し、不一致の有無を返します。



  EXL_SetCellNumber Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellNumber
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    value :REAL
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellNumber(sheetIndex, cellRow, cellColumn, value):
   return BOOLEAN

Description:

Write the cell value as a number.

説明

セルの値を数値として書き込みます。



  EXL_SetCellNumFormula Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellNumFormula
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    formulaString :STRING;
    formulaValue :REAL
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellNumFormula(sheetIndex, cellRow, cellColumn, formulaString, formulaValue):
   return BOOLEAN

Description:

Write cell value as a numeric formula.

説明

セルの値を計算式として書き込みます。



  EXL_SetCellStrFormula Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellStrFormula
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    formulaString :STRING;
    formulaValue :STRING
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellStrFormula(sheetIndex, cellRow, cellColumn, formulaString, formulaValue):
   return BOOLEAN

Description:

Write cell value as a string formula.

説明

セルの値を文字列形式で書き込みます。



  EXL_SetCellString Excel 
Vectorworks 2021

VectorScript Declaration:

FUNCTION   EXL_SetCellString
(   sheetIndex :INTEGER;
    cellRow :INTEGER;
    cellColumn :INTEGER;
    value :STRING
) :BOOLEAN ;

Python:

def  vs.EXL_SetCellString(sheetIndex, cellRow, cellColumn, value):
   return BOOLEAN

Description:

Write the cell value as a string.

説明

セルの値を文字列として書き込みます。