TRY NEW VERSION

ASC

ASC(arg1) → { string }

For double-byte character set (DBCS) languages, the function changes full-width (double-byte) characters to half-width (single-byte) characters.

Parameters:

Name Type Description
arg1 string

The text or a reference to a cell containing the text to change.

Returns:

Type
string

Example

Copy code
builder.CreateFile("xlsx");
var oWorksheet = Api.GetActiveSheet();
var oFunction = Api.GetWorksheetFunction();
oWorksheet.GetRange("A1").SetValue(oFunction.ASC("text"));
builder.SaveFile("xlsx", "ASC.xlsx");
builder.CloseFile();

Resulting document