Click here to Skip to main content
15,909,939 members
Home / Discussions / C#
   

C#

 
AnswerRe: How to access cell information and controls of DevExpress Spreadsheet Form from another form in the same application? Pin
OriginalGriff25-Mar-21 5:03
mveOriginalGriff25-Mar-21 5:03 
GeneralRe: How to access cell information and controls of DevExpress Spreadsheet Form from another form in the same application? Pin
Gerry Schmitz25-Mar-21 7:42
mveGerry Schmitz25-Mar-21 7:42 
GeneralRe: How to access cell information and controls of DevExpress Spreadsheet Form from another form in the same application? Pin
OriginalGriff25-Mar-21 11:09
mveOriginalGriff25-Mar-21 11:09 
AnswerRe: How to access cell information and controls of DevExpress Spreadsheet Form from another form in the same application? Pin
Gerry Schmitz25-Mar-21 7:40
mveGerry Schmitz25-Mar-21 7:40 
QuestionChecking for existing open forms Pin
Alex Dunlop24-Mar-21 23:26
Alex Dunlop24-Mar-21 23:26 
AnswerRe: Checking for existing open forms Pin
OriginalGriff24-Mar-21 23:38
mveOriginalGriff24-Mar-21 23:38 
GeneralRe: Checking for existing open forms Pin
Alex Dunlop25-Mar-21 0:08
Alex Dunlop25-Mar-21 0:08 
GeneralRe: Checking for existing open forms Pin
OriginalGriff25-Mar-21 0:37
mveOriginalGriff25-Mar-21 0:37 
AnswerRe: Checking for existing open forms Pin
Richard Deeming25-Mar-21 2:51
mveRichard Deeming25-Mar-21 2:51 
QuestionCopy a selected gridview row to the same gridview Pin
Member 1493285423-Mar-21 2:41
Member 1493285423-Mar-21 2:41 
AnswerRe: Copy a selected gridview row to the same gridview Pin
Gerry Schmitz23-Mar-21 7:08
mveGerry Schmitz23-Mar-21 7:08 
GeneralRe: Copy a selected gridview row to the same gridview Pin
Nathan Minier24-Mar-21 1:20
professionalNathan Minier24-Mar-21 1:20 
GeneralRe: Copy a selected gridview row to the same gridview Pin
jsc4224-Mar-21 1:25
professionaljsc4224-Mar-21 1:25 
GeneralRe: Copy a selected gridview row to the same gridview Pin
Nathan Minier24-Mar-21 1:38
professionalNathan Minier24-Mar-21 1:38 
GeneralRe: Copy a selected gridview row to the same gridview Pin
jsc4225-Mar-21 3:54
professionaljsc4225-Mar-21 3:54 
QuestionHow to able to have the information of the particular image button clicked? Pin
Member 1508474922-Mar-21 10:50
Member 1508474922-Mar-21 10:50 
AnswerRe: How to able to have the information of the particular image button clicked? Pin
OriginalGriff22-Mar-21 11:18
mveOriginalGriff22-Mar-21 11:18 
GeneralRe: How to able to have the information of the particular image button clicked? Pin
Richard Deeming22-Mar-21 22:25
mveRichard Deeming22-Mar-21 22:25 
AnswerRe: How to able to have the information of the particular image button clicked? Pin
Richard Deeming22-Mar-21 22:33
mveRichard Deeming22-Mar-21 22:33 
AnswerRe: How to able to have the information of the particular image button clicked? Pin
DerekT-P23-Mar-21 0:46
professionalDerekT-P23-Mar-21 0:46 
QuestionC# Excel test specific cells in a column Pin
Steve Rudd22-Mar-21 5:59
Steve Rudd22-Mar-21 5:59 
AnswerRe: C# Excel test specific cells in a column Pin
Gerry Schmitz22-Mar-21 7:40
mveGerry Schmitz22-Mar-21 7:40 
GeneralRe: C# Excel test specific cells in a column Pin
Steve Rudd22-Mar-21 9:31
Steve Rudd22-Mar-21 9:31 
OK Gerry, here is the full scenario.
My program functions inside of AutoCAD and is intended to export some product data to a "Packing List"
which is a spreadsheet in Excel.
This is the workflow:
1. The draughtsman is prompted to make a selection from a number of products (AutoCAD entities) on the drawing which will comprise of the items to be added to the Packing List.
2. He then allocates the selection to a Bundle number, which he is prompted for and defines himself.
3. The program then looks for an excel book with the same name as the drawing file and if it does not exist, creates a new one from a defined template.
4. It then iterates through the selection set and extracts all of the part numbers and builds a string of the numbers to be written out i.e. 1, 2, 3, 4, 5 etc.
5. If we are in a new workbook, the string is written into the first cell at row 7.
6. The workbook is then saved and closed.
7. When this process is finished, the draughtsman can then start over again and make another selection which he then allocates to a different Bundle number.
8. At this point, the program finds the existing workbook and opens it, but now needs to start at the first cell on row 11 as cell 7, 1 already holds data.

This workflow can carry-on upto 13 times, when the last row will be reached.

Hope this is clearer.

Steve

ps I can't see how to include a snapshot of the packing list spread sheet.
GeneralRe: C# Excel test specific cells in a column Pin
Richard MacCutchan22-Mar-21 22:56
mveRichard MacCutchan22-Mar-21 22:56 
GeneralRe: C# Excel test specific cells in a column Pin
Steve Rudd23-Mar-21 0:13
Steve Rudd23-Mar-21 0:13 

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.