473,569 Members | 2,406 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Opening Excel files- Standard or Professional?

To open and read data from Excel files, do I need to purchase VS2008
Standard or Professional? I was looking at the product comparison and
it says Standard does not include

Microsoft Office System 2003 Primary Interop Assemblies
Microsoft Office System Runtime

Thanks
Sep 3 '08 #1
4 1208
GS
I believe you don't need neither for excel. even the express version will do
with com interface..

"ElPresiden te" <ch************ *@gmail.comwrot e in message
news:d9******** *************** ***********@m73 g2000hsh.google groups.com...
To open and read data from Excel files, do I need to purchase VS2008
Standard or Professional? I was looking at the product comparison and
it says Standard does not include

Microsoft Office System 2003 Primary Interop Assemblies
Microsoft Office System Runtime

Thanks

Sep 3 '08 #2
if you want to open excel 2007 files all you need is the Oen Xml Sdk
here is the link
http://www.microsoft.com/downloads/d...playlang=enthe interop assemblies are also available as a separate download"ElPres idente" <ch************ *@gmail.comwrot e in messagenews:d9* *************** *************** ***@m73g2000hsh .googlegroups.c om...To open and read data from Excel files, do I need to purchase VS2008Standard or Professional? I was looking at the product comparison andit says Standard does not include>Microso ft Office System 2003 Primary Interop AssembliesMicro soft Office System Runtime>Thanks
Sep 3 '08 #3
On Sep 3, 2:12*pm, ElPresidente <chickenparme.. .@gmail.comwrot e:
To open and read data from Excel files, do I need to purchase VS2008
Standard or Professional? I was looking at the product comparison and
it says Standard does not include

Microsoft Office System 2003 Primary Interop Assemblies
Microsoft Office System Runtime

Thanks
You can read data from Excel using OleDbCommands. These are available
in any version of Visual Studio.

Thanks,

Seth Rowe [MVP]
http://sethrowe.blogspot.com/
Sep 4 '08 #4
You should try to work with excel withOUT the interops if possible.

http://www.google.com/search?hl=en&q...lect+*+from+Sh

Do a google search for "Select * from Sheet1" to find ways to use OleDB
instead of the interops.

...

You can find a very very basic example (downloadable code) here as well.
http://sholliday.space s.live.com/blog/cns!A68482B9628 A842A!176.entry
using the EnterpriseLibra ry.Data

...
"ElPresiden te" <ch************ *@gmail.comwrot e in message
news:d9******** *************** ***********@m73 g2000hsh.google groups.com...
To open and read data from Excel files, do I need to purchase VS2008
Standard or Professional? I was looking at the product comparison and
it says Standard does not include

Microsoft Office System 2003 Primary Interop Assemblies
Microsoft Office System Runtime

Thanks

Sep 4 '08 #5

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

Similar topics

1
6925
by: Bob Murdoch | last post by:
I've got an intranet application that presents a list of files in sort of a 'central repository' web page. Each file is an href in the form <a href=file://server/share/path/filename.ext>. When the user clicks on an excel file, it is opening within the browser, which unforntuntely confuses the heck out of them because the usual Print/Print...
8
4595
by: Djim | last post by:
Hello, i am starting PHP, and after 2 days of search, i am posting. MY PURPOSE : opening a XLS files (in MS Excel) on the client side, the user can update anything, then it will be automaticly saved on the server again (when client use save button or close Excel). MY TESTS : I had coded that (in php) : echo "<FORM METHOD=post...
2
2685
by: Riddle | last post by:
Hi, I have found many tutorials showing how to access data in an Excel spreadsheet using a COM object in .net. But, as far as I can tell, this requires Excel to be installed. Is there anyway I can access the Excel file without the user needing Excel? Thanks, Chris Riddle
2
10342
by: Jacob.Bruxer | last post by:
Hi everyone, I'm having trouble opening space delimited textfiles in Excel from Visual Basic.net. I'm able to control, open and modify Excel files from Visual Basic, so my Excel reference seems to be working ok. I just don't know what I'm doing when I try to open a space delimited file and want to put the data into columns. I tried...
2
3112
by: Mad Scientist Jr | last post by:
>From an asp.net web page I want the user to open the results of a SQL query in Excel, as automatically as possible (ie not having to loop through columns, rows, in code). For this, dataset.writexml works great (got the code from http://forums.devx.com/archive/index.php/t-57273.html ) The only question I have is, when Excel opens up, it...
3
6772
by: blerina | last post by:
hi, i have a simple asp code that opens an excel file. it works fine with simple excel files that don't contain formula. i think the problem is that my excel file contains formulas and calculations. when opening this file with vb 6.0 code it works fine. here is a the simple code: Dim xlObject, xlBook,wks
1
6168
by: mohanprasadgutta | last post by:
Hi, I need help to open a password protected excel file in perl using Win32:OLE. when I tried to open file in normal way at the time of program execution it is prompting me to enter password. I am giving the script i used for opening excel file.. So i want to know how to provide password parameter while opening the file. use strict; use...
16
5159
by: Phil Stanton | last post by:
I have a form with a button which is supposed to open an Excel file (With lots of Macros /VBA) in it. The Excel file gets it's data from the Access program Here is the code Private Sub Storage_Click() On Error GoTo Err_Storage_Click
0
1329
by: shyshack | last post by:
Hi, I am quite new in C#. I am writing an application in which I have to open Excel file to import data from it. When opening small files everything works ok - the problem appears when I try to open larger one (14 MB) - the excel stops working while doing it. I tried to cope with it by changing last parameter in xlApp.Workbooks.Open()...
1
2427
navanova
by: navanova | last post by:
Greetings, I have a problem of opening ms word and excel files on my computer. The files are there for a long time. I use to open and modify them. Suddenly, when i try to open the word files, a dialog box appears that says "There was an error opening the file". when i try to open the excel files, a dialog box appears that says "File format not...
0
7703
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main...
0
7618
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language...
0
7926
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...
1
5514
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes...
0
5222
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...
0
3656
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in...
0
3644
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
1226
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
944
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

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.