Click here to Skip to main content
15,917,702 members
Home / Discussions / .NET (Core and Framework)
   

.NET (Core and Framework)

 
QuestionIs there any.... Pin
MMaines20055-Oct-07 16:49
MMaines20055-Oct-07 16:49 
AnswerRe: Is there any.... Pin
lmoelleb6-Oct-07 1:26
lmoelleb6-Oct-07 1:26 
GeneralRe: Is there any.... Pin
George L. Jackson6-Oct-07 5:00
George L. Jackson6-Oct-07 5:00 
QuestionMaking a menu-like form. Pin
chaiguy13375-Oct-07 15:56
chaiguy13375-Oct-07 15:56 
AnswerRe: Making a menu-like form. Pin
chaiguy13375-Oct-07 16:17
chaiguy13375-Oct-07 16:17 
QuestionHow can I Read Excel-documents? Pin
MaWeRic5-Oct-07 15:18
MaWeRic5-Oct-07 15:18 
AnswerRe: How can I Read Excel-documents? Pin
Christian Graus5-Oct-07 16:17
protectorChristian Graus5-Oct-07 16:17 
AnswerRe: How can I Read Excel-documents? Pin
Monte at Oaklawn8-Oct-07 4:03
Monte at Oaklawn8-Oct-07 4:03 
Here is one way, although there may be other/better ways:

Add a reference to the MS Excel object library.
In your code, you can use the Excel objects directly:

Dim xlApp As Excel.Application
Dim xlBook As Excel.Workbook
Dim xlBooks As Excel.Workbooks
Dim xlSheets As Excel.Sheets
Dim xlSheet As Excel.Worksheet

Once you create an instance of the Excel app,
xlApp = New Excel.Application

You can address any object in the spreadsheet
xlBooks = xlApp.Workbooks
xlBook = xlBooks.Open(strPath & "Sheetname.xls", True)
xlSheets = xlBook.Worksheets
xlSheet = xlSheets(1)

Values in cells can be accessed and modified by range
intListRow += 1
strRange = "A" & CStr(intListRow)
strSheetValue = xlSheet.Range(strRange).Value

Remember to close the app or there will be an Excel process still open on the machine.
xlBook.Close(True)
xlApp.Application.Quit()
xlApp = Nothing
QuestionSSL Signature Verification Pin
#realJSOP5-Oct-07 11:37
professional#realJSOP5-Oct-07 11:37 
QuestionAny issues????? Pin
Charith Jayasundara4-Oct-07 20:07
Charith Jayasundara4-Oct-07 20:07 
AnswerRe: Any issues????? Pin
Urs Enzler6-Oct-07 3:50
Urs Enzler6-Oct-07 3:50 
QuestionConditional Compiler Directives Pin
Vasudevan Deepak Kumar4-Oct-07 0:42
Vasudevan Deepak Kumar4-Oct-07 0:42 
AnswerRe: Conditional Compiler Directives Pin
Scott Dorman4-Oct-07 1:15
professionalScott Dorman4-Oct-07 1:15 
GeneralRe: Conditional Compiler Directives Pin
Vasudevan Deepak Kumar4-Oct-07 6:05
Vasudevan Deepak Kumar4-Oct-07 6:05 
GeneralRe: Conditional Compiler Directives Pin
Scott Dorman4-Oct-07 11:33
professionalScott Dorman4-Oct-07 11:33 
GeneralRe: Conditional Compiler Directives Pin
Luc Pattyn4-Oct-07 12:23
sitebuilderLuc Pattyn4-Oct-07 12:23 
GeneralRe: Conditional Compiler Directives Pin
Scott Dorman5-Oct-07 3:42
professionalScott Dorman5-Oct-07 3:42 
AnswerRe: Conditional Compiler Directives Pin
PIEBALDconsult4-Oct-07 4:24
mvePIEBALDconsult4-Oct-07 4:24 
GeneralRe: Conditional Compiler Directives Pin
Vasudevan Deepak Kumar4-Oct-07 6:06
Vasudevan Deepak Kumar4-Oct-07 6:06 
QuestionWCF not passing its Data Contract :( Pin
twista3-Oct-07 16:29
twista3-Oct-07 16:29 
QuestionTabPage (rant) Pin
PIEBALDconsult3-Oct-07 11:01
mvePIEBALDconsult3-Oct-07 11:01 
AnswerRe: TabPage (rant) Pin
Scott Dorman3-Oct-07 12:16
professionalScott Dorman3-Oct-07 12:16 
GeneralRe: TabPage (rant) Pin
PIEBALDconsult3-Oct-07 15:45
mvePIEBALDconsult3-Oct-07 15:45 
GeneralRe: TabPage (rant) Pin
Scott Dorman3-Oct-07 16:49
professionalScott Dorman3-Oct-07 16:49 
GeneralRe: TabPage (rant) Pin
PIEBALDconsult3-Oct-07 17:54
mvePIEBALDconsult3-Oct-07 17:54 

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.