mardi 13 juin 2017

VB.Net: Insert Checkboxes in Excel Cells

I'm attempting to make a reader friendly Excel spreadsheet from a bunch of different data sources. One part of this is adding checkbox's to every row in a certain column. I believe that this can't be done by "cell" per say but by location on the spreadsheet from what I've read.

I've attempted...

    Dim cb As ICheckBox = protoWorksheet.CheckBoxes.AddCheckBox(4, 2, 15, 100)
    cb.CheckState = CheckState.Checked
    cb.Text = "Test"

but received the following error An unhandled exception of type 'System.MissingMemberException' occurred in Microsoft.VisualBasic.dll Additional information: Public member 'AddCheckBox' on type 'CheckBoxes' not found.

Any help is much appreciated!




Aucun commentaire:

Enregistrer un commentaire