473,574 Members | 3,010 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Simple Grid

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
3 4272
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
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
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

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

Similar topics

4
2227
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...
3
2482
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... ...
5
3069
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...
0
7548
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...
13
1845
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...
2
1212
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...
0
1079
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...
1
1244
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
5
1458
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 import sys
0
7805
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
7726
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
8234
jinu1996
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...
1
7815
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...
0
6452
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
0
5300
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
3740
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
3749
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1060
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.