Click here to Skip to main content
15,896,912 members
Home / Discussions / C#
   

C#

 
GeneralRe: PDF Creation Thank You Pin
M. J. Jaya Chitra7-Jun-07 19:55
M. J. Jaya Chitra7-Jun-07 19:55 
GeneralRe: PDF Creation Pin
Sathesh Sakthivel7-Jun-07 20:07
Sathesh Sakthivel7-Jun-07 20:07 
GeneralThank you Pin
M. J. Jaya Chitra7-Jun-07 20:31
M. J. Jaya Chitra7-Jun-07 20:31 
QuestionProblem with Drag-Drop operation with Picture Box.Pls Help Pin
Chintan.Desai7-Jun-07 18:22
Chintan.Desai7-Jun-07 18:22 
AnswerRe: Problem with Drag-Drop operation with Picture Box.Pls Help Pin
JoeSharp7-Jun-07 20:15
JoeSharp7-Jun-07 20:15 
GeneralRe: Problem with Drag-Drop operation with Picture Box.Pls Help Pin
Chintan.Desai7-Jun-07 21:19
Chintan.Desai7-Jun-07 21:19 
QuestionEditing a Textbox and CheckBox in Excel file using Interop Pin
TheMajorRager7-Jun-07 17:51
TheMajorRager7-Jun-07 17:51 
AnswerRe: Editing a Textbox and CheckBox in Excel file using Interop Pin
Ray2Boston13-Jul-10 11:37
Ray2Boston13-Jul-10 11:37 
I assume here that you can get the Excel, Workbook and Worksheet objects...

String sFileName = <full path to file>;

Microsoft.Office.Interop.Excel.Application oApp =
new Microsoft.Office.Interop.Excel.Application();

Workbook wkb = oApp.Workbooks.Open(sFileName, .....);

Worksheet sheet1 = wkb.Worksheets["Sheet 1"] as Worksheet;

Microsoft.Office.Interop.Excel.CheckBox cb = sheet1.CheckBoxes("Check Box 101");

...the rest should be obvious. For example, cb.Value = true;


That's the code. The non-obvious part to me was the name - in this case "Check Box 101". In the upper left corner of Excel, as you click from cell to cell, it shows the name of the cell. For example, A1, A2, etc... If you RMB on the CheckBox it will show the name of the CheckBox in this very same location. You can change the name to whatever you want. That's the name you use in code to access the CheckBox from the list. Excel will auto-name them so there is some predictability. But I've received spreadsheets where the names are all over the map.

Good luck!
Questionhow can I get the next item? Pin
lockepeak7-Jun-07 16:45
lockepeak7-Jun-07 16:45 
AnswerRe: how can I get the next item? Pin
Christian Graus7-Jun-07 17:44
protectorChristian Graus7-Jun-07 17:44 
QuestionTableLayoutPanel repaint issue. Pin
Zerox MXI7-Jun-07 16:42
Zerox MXI7-Jun-07 16:42 
AnswerRe: TableLayoutPanel repaint issue. Pin
Salogus7-Jun-07 16:52
Salogus7-Jun-07 16:52 
GeneralRe: TableLayoutPanel repaint issue. Pin
Zerox MXI7-Jun-07 16:59
Zerox MXI7-Jun-07 16:59 
QuestionIs software installed on pc? Pin
Adeel Chaudhry7-Jun-07 13:21
Adeel Chaudhry7-Jun-07 13:21 
AnswerRe: Is software installed on pc? Pin
Mark Greenwood7-Jun-07 14:56
Mark Greenwood7-Jun-07 14:56 
AnswerRe: Is software installed on pc? Pin
Niiiissssshhhhhuuuuu7-Jun-07 18:37
Niiiissssshhhhhuuuuu7-Jun-07 18:37 
QuestionLimiting DB access to only through application Pin
tempmail17-Jun-07 11:33
tempmail17-Jun-07 11:33 
AnswerRe: Limiting DB access to only through application Pin
Christian Graus7-Jun-07 11:47
protectorChristian Graus7-Jun-07 11:47 
AnswerRe: Limiting DB access to only through application Pin
Russell Jones7-Jun-07 22:38
Russell Jones7-Jun-07 22:38 
QuestionHierarchical Distributed Genetic Algorithm for Image Segmentation Pin
Petra7-Jun-07 10:46
Petra7-Jun-07 10:46 
AnswerRe: Hierarchical Distributed Genetic Algorithm for Image Segmentation Pin
Dave Kreskowiak7-Jun-07 13:28
mveDave Kreskowiak7-Jun-07 13:28 
AnswerRe: Hierarchical Distributed Genetic Algorithm for Image Segmentation Pin
Christian Graus7-Jun-07 15:35
protectorChristian Graus7-Jun-07 15:35 
QuestionFileSystemWatcher Pin
LCI7-Jun-07 10:28
LCI7-Jun-07 10:28 
AnswerRe: FileSystemWatcher Pin
Ylno7-Jun-07 11:42
Ylno7-Jun-07 11:42 
GeneralRe: FileSystemWatcher Pin
LCI8-Jun-07 9:36
LCI8-Jun-07 9:36 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.