Simple Grid - Visual Basic .NET

Wayne

I need to make a simple grid in which the user can cut and paste the
contents of a region of cells from this simple grid to excel.

I thought about ganging a bunch of textboxes (1 textbox = 1 cell)
together which would work for me but I cannot cut and paste a
collection of cells to excel using this approach.

Any ideas where to go next? I know I can buy such a capability and
have done so in the past but I would like to write it in vb.net. I
don't need all the power that comes from commercial versions.

I have tried datagrid and I cannot cut and paste a collection of cells
to excel.

I have played with listview also and did not get what I want either.

I don't need scrolling or binding ... I just need cells that the user
can type in and then cut and paste to excel.

Thanks in advance.

Wayne

Nov 20 '05 #1

Subscribe Reply

4292

Crirus

You can write a routine that select all textboxes you want
A mouse move will give you the coordinates of the selection rectangle
You can check wich text boxes is inside the rectangle, you can change the
bgcolor of selected textboxes to reflect the ideea of selection. On cut, can
arrange the text of each textbox "selected", as you need to be pasted in
excel and fill the clipboard with it
"Wayne" <VB******@hotma il.com> wrote in message
news:5f******** *************** ***@posting.goo gle.com...

I need to make a simple grid in which the user can cut and paste the
contents of a region of cells from this simple grid to excel.

I thought about ganging a bunch of textboxes (1 textbox = 1 cell)
together which would work for me but I cannot cut and paste a
collection of cells to excel using this approach.

Any ideas where to go next? I know I can buy such a capability and
have done so in the past but I would like to write it in vb.net. I
don't need all the power that comes from commercial versions.

I have tried datagrid and I cannot cut and paste a collection of cells
to excel.

I have played with listview also and did not get what I want either.

I don't need scrolling or binding ... I just need cells that the user
can type in and then cut and paste to excel.

Thanks in advance.

Wayne

Nov 20 '05 #2

Stephen

Just add the Excel spreadsheet control to the project. Go to Add/Remove
items on the toolbar and go to COM. It will be under Microsoft Office
Spreadsheet x depending on your version. Its a fully featured control and
you can turn off the option to display the title bar to make it look more
integrated.

Stephen

"Wayne" <VB******@hotma il.com> wrote in message
news:5f******** *************** ***@posting.goo gle.com...

I need to make a simple grid in which the user can cut and paste the
contents of a region of cells from this simple grid to excel.

I thought about ganging a bunch of textboxes (1 textbox = 1 cell)
together which would work for me but I cannot cut and paste a
collection of cells to excel using this approach.

Any ideas where to go next? I know I can buy such a capability and
have done so in the past but I would like to write it in vb.net. I
don't need all the power that comes from commercial versions.

I have tried datagrid and I cannot cut and paste a collection of cells
to excel.

I have played with listview also and did not get what I want either.

I don't need scrolling or binding ... I just need cells that the user
can type in and then cut and paste to excel.

Thanks in advance.

Wayne

Nov 20 '05 #3

Wayne

Stephen,

I should add that I want to stay in managed code - hence I don't want
to use com objects.

What I want to do is build a grid using the tools that vb.net has
provided.

Wayne.

"Stephen" <gr******@bella tlantic.net> wrote in message news:<Oh******* *******@TK2MSFT NGP12.phx.gbl>. ..

Just add the Excel spreadsheet control to the project. Go to Add/Remove
items on the toolbar and go to COM. It will be under Microsoft Office
Spreadsheet x depending on your version. Its a fully featured control and
you can turn off the option to display the title bar to make it look more
integrated.

Stephen

"Wayne" <VB******@hotma il.com> wrote in message
news:5f******** *************** ***@posting.goo gle.com...
I need to make a simple grid in which the user can cut and paste the
contents of a region of cells from this simple grid to excel.

I thought about ganging a bunch of textboxes (1 textbox = 1 cell)
together which would work for me but I cannot cut and paste a
collection of cells to excel using this approach.

Any ideas where to go next? I know I can buy such a capability and
have done so in the past but I would like to write it in vb.net. I
don't need all the power that comes from commercial versions.

I have tried datagrid and I cannot cut and paste a collection of cells
to excel.

I have played with listview also and did not get what I want either.

I don't need scrolling or binding ... I just need cells that the user
can type in and then cut and paste to excel.

Thanks in advance.

Wayne

Nov 20 '05 #4

Similar topics

2230

Simple grid question

by: Geoff Soper | last post by:

I would like to arrange some photos in a simple grid. Each photo is either x pixels by y pixels or y pixels by x pixels (i.e. all the same size, arranged either in the landscape or portrait direction). I want each row to be the same width and height, the largest dimension of x and y. I want this to be the case even if all the photos in a given row or column are arranged in the 'other' direction, the one which leaves two strips of empty...

HTML / CSS

2488

Simple server/client application

by: MBW | last post by:

The following code is for a simple server/client asplication that allows the user to toggle between serve and or client modes and send/recieve a message however i am getting an Attribute error on my entry widgets when I try and call get() to get the port and ip address from those fields, I'm sure it's something simple I haven't grasped... #START from Tkinter import * from socket import *

Python

3076

Simple grid/table display question.

by: Will | last post by:

I've got a simple form that collects data from a user and I want to display that data in a sortable grid or table. The nature of this data is rather temporary, so there's no need to persist it to a database. Searching through the Framework documentation, everything I've seen reggarding a grids and tables seems to require a connection to a database. My guess is I'm just missing something. What classes can I use to display sortable data in a...

C# / C Sharp

7569

A simple home-made StringGrid

by: Tal Sharfi | last post by:

Hi everyone I recently had the need for StringGrid object same as the one that Delphi has. An object that helps show lists of other objects in a simple grid. I searched the news groups and found none, so, I wrote one and decided to share it with you. It's a very simple one with few functions. I derived a DataGrid and added to it a DataTable to hold the data. The object itself is handling the synchronization between them, because...

C# / C Sharp

1860

Simple Question - Datagrid and Typed dataset

by: Saber | last post by:

I did a lot of searches and read something about datagrids. But I couldn't find the answer of my simple question, how can I show only my desired columns of a table? for example I wrote this sql query: OleDbDataAdapter1.SelectCommand.CommandText = & _ "Select illNameE From tblIllness" OleDbDataAdapter1.Fill(DsIllness1) But in my datagrid, I get (null) for other ccolumns instead

Visual Basic .NET

1224

Very Simple DataGrid Question

by: James | last post by:

I have a very simple datagrid, with an edit button that I added in PropertyBuilder. This fires the EditCommand event just fine and I show a panel where the user can edit certain fields. I have a button to save the changes. Within that button, I refer to dataGrid1.EditItemIndex and it's returning -1. Isn't this property set when I click on the edit button within the grid?

Visual Basic .NET

1087

Simple grid edition question ?

by: serge calderara | last post by:

Dear all, I have an application which collect information from a database and display them in a dagrid. I have apply to the grid a DataView object to get filtered information and bind the grid to that dataview. Then if my user click on a <ADD> button I would like to get the grid in an edition mode and my user can fill up information directly in.

ASP.NET

1253

simple oop question (hopefully)

by: Eric_Dexter | last post by:

I am just trying to acess a function in wordgrid (savefile) to a button that is defined in TestFrame. I can't seem to make it work I either get an error that my variable isn't global or it makes other complaints. thanks in advance.. sorry for the simple question.. import wx import wx.grid as gridlib

Python

1466

simple oop question (I think) [solved]

by: eric dexter | last post by:

Python

9518

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10430

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, 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. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...

C / C++

10211

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...

Online Marketing

10159

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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

10000

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

5436

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 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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5560

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

4111

transfer the data from one system to another through ip address

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 we have to send another system

C# / C Sharp

3719

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP