VB.net and excel spreadsheet - Visual Basic .NET

john andrew

--
hello

In VB.net can I import an excel spreadsheet into a formand display it. Also
edit/save cells also on the form.

I want to use code in VB.net form that also effect the spreadsheet.
Can I do this or something like this in VB.net

Nov 21 '05 #1

Subscribe Post Reply

6386

David Gacek

take a look at this
http://www.dotnet247.com/247referenc...25/127375.aspx

http://www.codeguru.com/forum/showth...45#post1053045

hope that helps

"john andrew" <jo********@discussions.microsoft.com> wrote in message
news:E0**********************************@microsof t.com...

--
hello

In VB.net can I import an excel spreadsheet into a formand display it. Also edit/save cells also on the form.

I want to use code in VB.net form that also effect the spreadsheet.
Can I do this or something like this in VB.net

Nov 21 '05 #2

john andrew

This does help.
All of these examples read a spreadsheet into database and you can then
manipulate it. In VB6 you had OLE link and you could put Excel straight onto
a form.

Whats happened to OLE in VB.net Has it gone the way of just read data in a
database and populate a grid?

"David Gacek" wrote:

take a look at this
http://www.dotnet247.com/247referenc...25/127375.aspx

http://www.codeguru.com/forum/showth...45#post1053045

hope that helps

"john andrew" <jo********@discussions.microsoft.com> wrote in message
news:E0**********************************@microsof t.com...

--
hello

In VB.net can I import an excel spreadsheet into a formand display it.

Also
edit/save cells also on the form.

I want to use code in VB.net form that also effect the spreadsheet.
Can I do this or something like this in VB.net

Nov 21 '05 #3

Cor Ligthert

John,

Some other links

Office
http://support.microsoft.com/default...b;EN-US;311452

http://msdn.microsoft.com/office/

Pia Download
http://www.microsoft.com/downloads/d...displaylang=en

Excel object model
http://msdn.microsoft.com/library/de...l/ExcelObj.asp

HOW TO: Call a Visual Basic .NET Class Library from Visual Basic for
Applications in Microsoft Office
http://support.microsoft.com/?kbid=317535

I hope this helps a little bit?

Cor

"john andrew" <jo********@discussions.microsoft.com>
..

This does help.
All of these examples read a spreadsheet into database and you can then
manipulate it. In VB6 you had OLE link and you could put Excel straight
onto
a form.

Whats happened to OLE in VB.net Has it gone the way of just read data in a
database and populate a grid?

"David Gacek" wrote:
take a look at this
http://www.dotnet247.com/247referenc...25/127375.aspx

http://www.codeguru.com/forum/showth...45#post1053045

hope that helps

"john andrew" <jo********@discussions.microsoft.com> wrote in message
news:E0**********************************@microsof t.com...
>
> --
> hello
>
> In VB.net can I import an excel spreadsheet into a formand display it.

Also
> edit/save cells also on the form.
>
> I want to use code in VB.net form that also effect the spreadsheet.
> Can I do this or something like this in VB.net

Nov 21 '05 #4

Herfried K. Wagner [MVP]

"john andrew" <jo********@discussions.microsoft.com> schrieb:

In VB.net can I import an excel spreadsheet into a formand display it.
Also
edit/save cells also on the form.

HOWTO: Use the WebBrowser Control to Open an Office Document in Visual Basic
..NET
<URL:http://support.microsoft.com/?scid=kb;EN-US;304643>

--
M S Herfried K. Wagner
M V P <URL:http://dotnet.mvps.org/>
V B <URL:http://dotnet.mvps.org/dotnet/faqs/>

Nov 21 '05 #5

Similar topics

Parsing Excel spreadsheet to db

by: Phil Powell | last post by:

What would one best recommend to parse an existing Excel spreadsheet (was done in Excel 97 or 2000 not sure to be honest)? I am looking for the most practical way of parsing an existing...

PHP

DTS Package using Excel Spreadsheets

by: Jeff | last post by:

I will start off by giving you a background of the process I am taking. The nature of my DTS package is that I recieve an Excel Spreadsheet, run it through the DTS Package applying validation to...

ASP / Active Server Pages

Generating XML from Excel / Trapping saved Excel file using FileSystemWatcher

by: Rich Wallace | last post by:

Hello all, Looking for suggestions and tips if possible. I have an application running on a file server that utilizes the FileSystemWatcher to trap when any Excel files are saved by a user. I...

Visual Basic .NET

Problem reading text/numeric data from Excel

by: Scott M. Lyon | last post by:

I've just discovered a bug in some code I wrote a little while ago, and I need you guys' help to fix it. My program imports data from a standard Excel Spreadsheet (just with specific column...

Visual Basic .NET

Export from VB.NET 2003 to an Excel spreadsheet

by: Scott M. Lyon | last post by:

I'm trying to figure out a way to export data (actually the result of a Stored Procedure call from SQL Server) into a specified Excel spreadsheet format. Currently, I have the data read into a...

Visual Basic .NET

Switching between Access and Excel using code

by: garry.oxnard | last post by:

Can anyone help me to solve a problem which involves switching from Access to Excel (then back to Access) programatically please? I have an Excel template which, on open, also opens an Access...

Microsoft Access / VBA

255 Character Limit for Linked Excel data

by: Grip | last post by:

Hi, I have gone throught the group and Microsoft's online help and have seen many suggestions but I am still seeking clarity: 1. I have an excel spreadsheet. Column A contains text that may...

Microsoft Access / VBA

MySQL database to excel spreadsheet report

by: Sport Girl | last post by:

Hi everybody , i have the task of developing in Perl a script that retrieves data from 3 tables ( bugs, profiles, products) from a MySQL database called bugs and display them in an excel sheet...

Perl

Excel .CSV problem with save

by: S_K | last post by:

Hi, I have a problem when I try to save a .CSV file from an ASP.NET web page and the client has Excel open already. The symptoms are: 1) The web page is currently displaying the Excel...

ASP.NET

Viewing Excel worksheet in Webbrowser

by: jwmaiden | last post by:

Have an application that opens up a webbrowser control to display data in an Excel spreadsheet (using VB.NET in VS 2005). No problem with opening the spreadsheet or displaying the data, but I'm...

.NET Framework

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

Is that possible of reading the .csv file in column wise and the column have different lengths ?

by: Sonnysonu | last post by:

This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...

C / C++

What is ONU?

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,...

General

Changing the language in Windows 10

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...

Windows Server

Problem With Comparison Operator <=> in G++

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,...

C / C++

The easy way to turn off automatic updates for Windows 10/11

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...

Windows Server

AI Job Threat for Devs

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,...

Career Advice

Couldn’t get equations in html when convert word .docx file to html file in C#.

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...

C# / C Sharp

Trying to create a lan-to-lan vpn between two differents networks

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...

Networking - Hardware / Configuration