- DsExcel .NET API Overview
-
DS.Documents.Excel Assembly
-
GrapeCity.Documents.Excel
-
Classes
- AIMessage
- AIModelRequest
- AIModelResponse
- AsyncCustomFunction
- BaseCellType
- ButtonCellType
- CalcReference
- CellColorSortField
- CellDecoration
- CellDecorationIcon
- CellInfo
- CellPadding
- CellPicture
- CheckBoxCellType
- CheckBoxListCellType
- ColorUtilities
- ComboBoxCellItem
- ComboBoxCellType
- CornerFold
- CsvOpenOptions
- CsvParseContext
- CsvParseResult
- CsvSaveOptions
- CustomBorderStyle
- CustomFunction
- DataImportOptions
- DataImportResult
- DataValidationJsonError
- DateTimeConverter
- DeserializationOptions
- DocumentProperties
- FindOptions
- FontColorSortField
- FormulaJsonError
- HtmlSaveOptions
- HyperLinkCellType
- IconSortField
- ImageSaveOptions
- ImageSource
- InvalidFormulaException
- InvalidTemplateException
- JsonDataSource
- JsonError
- LicenseManager
- Margin
- NumberFormatParseException
- OpenOptions
- OpenOptionsBase
- PageContentInfo
- PageInfo
- PagePrintedEventArgs
- PagePrintEventArgs
- PagePrintingEventArgs
- PageSettings
- Parameter
- PasteOption
- PdfSaveOptions
- PdfSecurityOptions
- PivotFieldCustomGroupOptions
- PivotFieldDateGroupOptions
- PivotFieldNumberGroupOptions
- PivotFilterOptions
- PrintManager
- PrintOutOptions
- RadioButtonListCellType
- RangeEventArgs
- RangeTemplateCellType
- RepeatSetting
- ReplaceOptions
- SaveOptions
- SaveOptionsBase
- SelectFieldItem
- SerializationOptions
- SheetEventArgs
- SignatureDetails
- SjsOpenOptions
- SjsSaveOptions
- SortFieldBase
- TextFormatInfo
- Theme
- Themes
- ValueSortField
- ViewerPreferences
- WebRequestResult
-
Workbook
- Constructors
- Events
-
Methods
- AddCustomFunction
- AddDataSource
- Calculate
- ConvertBarcodeToPicture
- Dirty
- FromJson
- FromSjsJson
- GenerateReport
- GetExcelLinkSources
- GetNames
- GetUsedFonts
- ImportData
- IsEncryptedFile
- Open
- PrintOut
- ProcessTemplate
- Protect
- Save
- SetLicenseKey
- ToJson
- ToSjsJson
- Unprotect
- UpdateExcelLink
- UpdateExcelLinks
- WaitForCalculationToFinish
- Properties
- WorkbookOptions
- WriteProtection
- XlsmOpenOptions
- XlsmSaveOptions
- XlsxOpenOptions
- XlsxSaveOptions
- XltxOpenOptions
- XltxSaveOptions
- Enums
- Interfaces
- Structs
-
Classes
- GrapeCity.Documents.Excel.Drawing
- GrapeCity.Documents.Excel.Expressions
- GrapeCity.Documents.Excel.Forms
-
GrapeCity.Documents.Excel
GrapeCity.Documents.Excel.Workbook.ConvertBarcodeToPicture
ConvertBarcodeToPicture Method
ConvertBarcodeToPicture(ImageType)
Converts calculated barcode formulas to pictures.
The converted pictures are placed at the original barcode positions, and the original barcode formulas are cleared after the conversion.
Declaration
public void ConvertBarcodeToPicture(ImageType imageType = ImageType.SVG)Public Sub ConvertBarcodeToPicture(Optional imageType As ImageType = ImageType.SVG)Parameters
| Type | Name | Description |
|---|---|---|
| ImageType | imageType | The ImageType of the converted barcode pictures. |
Implements
Examples
worksheet.Range["A1"].Value = "Policy:411";
worksheet.Range["B1"].Formula = "=BC_QRCODE(A1)";
workbook.ConvertBarcodeToPicture(ImageType.JPG);
int pictureCount = worksheet.Shapes.Count;
string fileName = "BarcodeReport.xlsx";
workbook.Save(fileName);Exceptions
| Type | Condition |
|---|---|
| NotSupportedException |