473,487 Members | 2,448 Online
Bytes | Software Development & Data Engineering Community
Create Post

Home Posts Topics Members FAQ

read excel files

I would like to read an excel file on the nework and load the data to some combobox.
Nov 16 '05 #1
3 1490
freddy wrote:
I would like to read an excel file on the nework and load the data to some combobox.


How To Automate Microsoft Excel from Microsoft Visual C# .NET
http://support.microsoft.com/?id302084

Cheers

Arne Janning
Nov 16 '05 #2
I do not want to automate, I just want to readthe data from excel

"Arne Janning" wrote:
freddy wrote:
I would like to read an excel file on the nework and load the data to some combobox.


How To Automate Microsoft Excel from Microsoft Visual C# .NET
http://support.microsoft.com/?id302084

Cheers

Arne Janning

Nov 16 '05 #3
freddy wrote:
I do not want to automate, I just want to readthe data from excel


You can open and query an Excel Spreadsheet using the JET OLE DB Provider:
http://www.able-consulting.com/MDAC/...rosoftJetExcel
http://support.microsoft.com/?id=278973 (ADO-classic, but this doesn't
have an effect on connStrings and query syntax)

A C#-Example is here:
Query an Excel Worksheet Without using Interop
http://www.knowdotnet.com/articles/exceldatasource.html

Cheers

Arne Janning

Nov 16 '05 #4

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

Similar topics

10
25425
by: QQ | last post by:
I am trying to read data from Excel files I use the following codes, however, it didn't work Can anyone tell me what the format excel files have, what I should do to read it from C? Thanks a...
0
4674
by: Peter | last post by:
I am having a problem reading an Excel file that is XML based. The directory I am reading contains Excel files that can be of two types. Either generic Microsoft based or XML based. I am reading...
6
15965
by: Anand | last post by:
Hello, Can I get some help on how to read the excel files using python? from win32com.client import Dispatch xlApp = Dispatch("Excel.Application") xlWb = xlApp.Workbooks.Open("Read.xls")...
2
2578
by: polabear | last post by:
I'm converting a VB6/SQL Server application to a web application. I need to read data to and from Excel and Word. I'm not allowed to install Excel and Word on the server, only on the client. Is...
4
3064
by: Juliano.net | last post by:
How can I read an Excel 2003 XML Spreadsheet and save it as an Excel 97 file?
3
4833
by: sajithkahawatta | last post by:
is there any one used aspose.excel i used automation to read a exel doc .but we have to install ms excel to do that so i suppose to use aspose.excel can any one give me the 'Aspose.Excel.dll' and...
2
3078
by: wstsoi | last post by:
hi I have to read images from spreadsheet, is it possible to do with php?
7
3154
by: Wernerh | last post by:
Hi all, Have created a vb application that interacts with Excel for report purposes. Base application and excel file is on host pc on network. I require the clients to access the excel workbook for...
2
2153
by: Riak | last post by:
Hellow Helpers: I am doing data entry job manually and data is huge. Now I was told to write/get some sort of program/script which can do this job quickly, otherwise I will loose job. I am good...
0
6967
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...
0
7142
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,...
1
6847
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
5445
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4875
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...
0
3078
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...
0
3071
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1383
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...
1
618
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

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.