[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.IQRCode

IQRCode Interface

Represents a barcode object created by the BC_QRCODE formula.

This interface represents the QR Code symbology result returned by BC_QRCODE. It extends IBarcode and exposes QRCode-specific settings such as ErrorCorrectionLevel, model, version, mask pattern, structured append connection, character code, and character set.

Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
public interface IQRCode : IBarcode
Public Interface IQRCode
    Inherits IBarcode
Examples
worksheet.Range["A1"].Value = "www.example.com";
worksheet.Range["B1"].Formula = "=BC_QRCODE(A1,\"rgb(0, 0, 0)\",\"rgb(255, 255, 255)\",\"H\",1,\"auto\",\"auto\",FALSE,0,,\"UTF-8\",4,4,4,4)";
IQRCode qrCode = (IQRCode) worksheet.Range["B1"].Value;
ErrorCorrectionLevel level = qrCode.ErrorCorrectionLevel;
int model = qrCode.Model;

Properties

Name Description
CharCode

Gets the character code information used by the BC_QRCODE formula result.

This value maps to the tenth argument of the BC_QRCODE formula and is distinct from the QRCode content stored in the referenced cell.

CharSet

Gets the character set used by the BC_QRCODE formula result.

This value specifies which charset is used to encode the QRCode. Optional charsets include UTF-8, SHIFT-JIS, and SHIFT_JIS.

Connection

Gets whether connection is used for the barcode.

This property indicates whether the QRCode uses structured append connection.

ConnectionNo

Gets the connection number for the barcode.

This value identifies the structured append connection number used by the QRCode.

ErrorCorrectionLevel

Gets the error correction level used by the BC_QRCODE formula result.

This value specifies the level of data recovery available when the QRCode is damaged or partially obscured.

Mask

Gets the mask pattern used by the BC_QRCODE formula result.

Specify any value between 1 and 7; auto configuration is -1.

Model

Gets the QR Code model used by the BC_QRCODE formula result.

The default value is 2.

The example below explicitly sets the model to 1.

Version

Gets the QR Code version used by the BC_QRCODE formula result.

For Model 1, the version range is 1 to 14. For Model 2, the version range is 1 to 40. This property supports auto configuration, represented by -1, as well as explicit numeric version values.