472,804 Members | 945 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,804 software developers and data experts.

Accessing Cells in Excel Spreadsheet

How can I retrieve value from cells in excel spreadsheet using vb.net

thanks
Jul 21 '05 #1
2 2016
Open up a reference to the Excel library and use
Application.WorkBook.Worksheets.Cells

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:E2**********************************@microsof t.com...
How can I retrieve value from cells in excel spreadsheet using vb.net

thanks

Jul 21 '05 #2
hi Ryan

I could not figure out how to open excel file. I am using Excel 11.0 Obect
Library. Is there any link which provides details about classes, methods and
properties exposed by Excel Object Librart?

Thanks

"W.G. Ryan eMVP" wrote:
Open up a reference to the Excel library and use
Application.WorkBook.Worksheets.Cells

--
W.G. Ryan MVP (Windows Embedded)

TiBA Solutions
www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Job Lot" <Jo****@discussions.microsoft.com> wrote in message
news:E2**********************************@microsof t.com...
How can I retrieve value from cells in excel spreadsheet using vb.net

thanks


Jul 21 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Ronny Sigo | last post by:
Hello all, Could anybody help me referencing individual cells in excel? I don't know what I do wrong here (but I'm not familiar with excel vba) (Microsoft Excel 10.0 Object library is referenced)...
0
by: DMolter | last post by:
I'm trying to define a math problem in excel, so for example a 4 cell block where A1 contians nothing, B1 contains the number 2, A2 contains the '+' sign and B2 contains the number 3, forming a...
1
by: Sunny K | last post by:
Hi, I need to display certain cells from an Excel spreadsheet to a webpage. For example; across the A,B,C columns I will have locations named (Eg London, Leeds etc) and across the 1,2,3 rows...
1
by: Howard Weiss | last post by:
I would like to set a particular cell in an Excel Spreadsheet to a specific value Visual Basic Equivalent would be Cells(row, column) = x where row and column locate the cell and x is the...
3
by: Mike Fellows | last post by:
i have some code that pulls a large amount of data from a database and puts it into an excel spreadsheet, some excel formulas are inserted and the whole lot gets printed out (excel in invisble...
2
by: Job Lot | last post by:
How can I retrieve value from cells in excel spreadsheet using vb.net thanks
3
by: Andrei | last post by:
Hi guys, I got a CSV file with more than 300000 raws so I couldn't open it in Excel. I decided to use Access but I can't access the data using standard way such as Workbooks(Name).Cells(i,...
8
by: Edgar | last post by:
Tools: SQL Server 2K, Excel 2000 Hi, I have an Excel report worksheet with formatted headings. What I want to do is to export data from the SQL server into a specific cell of the excel file....
0
by: sradoff | last post by:
I wish to use XPath to access data from within an Excel generated XML Spreadsheet (generated with MS Excel 2003). I am using an asp Web page (not .NET, not at this time). I instantiate...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 2 August 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
2
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Sept 2023 starting at 18:00 UK time (6PM UTC+1) and finishing at about 19:15 (7.15PM) The start time is equivalent to 19:00 (7PM) in Central...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
0
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
0
by: lllomh | last post by:
How does React native implement an English player?
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.