473,320 Members | 1,838 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

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

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 1203
GS
I believe you don't need neither for excel. even the express version will do
with com interface..

"ElPresidente" <ch*************@gmail.comwrote in message
news:d9**********************************@m73g2000 hsh.googlegroups.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"ElPresidente" <ch*************@gmail.comwrote in messagenews:d9**********************************@m 73g2000hsh.googlegroups.com...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>Microsoft Office System 2003 Primary Interop AssembliesMicrosoft Office System Runtime>Thanks
Sep 3 '08 #3
On Sep 3, 2:12*pm, ElPresidente <chickenparme...@gmail.comwrote:
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.spaces.live.com/blog/cns!A68482B9628A842A!176.entry
using the EnterpriseLibrary.Data

...
"ElPresidente" <ch*************@gmail.comwrote in message
news:d9**********************************@m73g2000 hsh.googlegroups.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
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...
8
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...
2
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...
2
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...
2
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,...
3
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...
1
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...
16
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...
0
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...
1
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.