How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
Go Back  Xtreme Visual Basic Talk > > > How to: Complex tables and graphics like excell.


Reply
 
Thread Tools Display Modes
  #1  
Old 10-15-2012, 05:20 AM
BlitzMX BlitzMX is offline
Newcomer
 
Join Date: Oct 2012
Posts: 2
Default How to: Complex tables and graphics like excell.


Hello

I am looking for a way to import several excell reports to build a statistic form like the one bellow, how can i do this in Visual Basic.net 2010?
What function or component should i use to presente data the same way and more, with some colors and everything?



Best regards
Thank you
Attached Images
File Type: jpg print.JPG (147.2 KB, 21 views)

Last edited by Flyguy; 10-15-2012 at 05:30 AM. Reason: Replaced external link with internal link
Reply With Quote
  #2  
Old 10-15-2012, 09:29 AM
Gruff's Avatar
GruffHow to: Complex tables and graphics like excell. Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

Closest thing I can think of would be the DataGridView control. Formatting would not be copied, only data. You would have to write routines to do that and it could get ugly.

Further it would be for display only. It is not Excel and no automatic calculations would occur.

As the name suggests the control is meant to be the front end for a database query.
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
  #3  
Old 10-16-2012, 02:59 AM
BlitzMX BlitzMX is offline
Newcomer
 
Join Date: Oct 2012
Posts: 2
Default

Quote:
Originally Posted by Gruff View Post
Closest thing I can think of would be the DataGridView control. Formatting would not be copied, only data. You would have to write routines to do that and it could get ugly.

Further it would be for display only. It is not Excel and no automatic calculations would occur.

As the name suggests the control is meant to be the front end for a database query.
Thank you, what language would allow me to build such an interface? I am looking for a way to pre configure the data that is shown so that i only have to change the dates to filter, and add reports as they arrive from my superiors.

Could a C# or ASP webpage be a better solution for what i want? Could i implement them in a VB.net form that handles the data and then presents everything in ASP or C# inside a vb form?

Best regards

Last edited by BlitzMX; 10-16-2012 at 03:04 AM.
Reply With Quote
  #4  
Old 10-16-2012, 09:22 AM
Gruff's Avatar
GruffHow to: Complex tables and graphics like excell. Gruff is offline
Bald Mountain Survivor

Retired Moderator
* Expert *
 
Join Date: Aug 2003
Location: Oregon, USA - deceased
Posts: 6,440
Default

Language has nothing to do with it. You can build any kind of interface you like depending on how much work you want to put into it. The DataGridView can have colored cells and different fonts. There is no Cell merge however.

Dumb Question but if the visuals are so important to you why not keep your program in Excel in the first place?
__________________
Burn the land and boil the sea
You can't take the sky from me


~T
Reply With Quote
  #5  
Old 10-18-2012, 10:27 PM
hDC_0How to: Complex tables and graphics like excell. hDC_0 is offline
Contributor

* Expert *
 
Join Date: Feb 2004
Posts: 559
Default Building a virtual interface..

Quote:
Language has nothing to do with it. You can build any kind of interface you like depending on how much work you want to put into it.
Gruff is right, but to take it a step further you really don't need controls at all.

Looking at your screenshot from a graphics breakdown standpoint,
it consists of:
1.) A series of rectangles (boxes)
2.) Text placed at certain x, y positions within those rects
3.) Tabs

Each of these can be duplicated without using controls.

For rectangles drawing there is DrawRectangle.
Take a look at the attachment to this surfR2911 post.
To create either a grid of rects or a bunch of rectangles distributed through the interface,
you can use surfR2911's amtar approach as detailed in this "Dim Sprite as What?" thread (from post#4 onward).

For text you can use DrawString.

For the tabs you can either:
1.) Draw them using a graphicspath
(using AddArc and AddLine segments - see the DrawRndRect sub code in the fuzzy shadows attachment of this post).
2.) Make a sprite sheet of the different tabs (with different colors) and
just cut them out as passel does in some of the attachments to the Quick Space Invaders thread.

For drawing raster (picture/image) graphics on a form you can use either DrawImage or Texturebrush.

In either case drawn objects don't have any "event" attached to them unless
you perform a "hit test" against a Mouse event (MouseDown/MouseMove):
1.) A rectangle
2.) A graphics path
3.) A pixel or set of pixels

For hit test type #1 code see this thread.
For hit test type #2 code see the attachment to this post.
For hit test type #3 code see the attachment to this post
(and look at the PointIsOverPicture function code inside the attachment).

Last edited by hDC_0; 10-18-2012 at 10:33 PM.
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump

Advertisement:





Free Publications
The ASP.NET 2.0 Anthology
101 Essential Tips, Tricks & Hacks - Free 156 Page Preview. Learn the most practical features and best approaches for ASP.NET.
subscribe
Programmers Heaven C# School Book -Free 338 Page eBook
The Programmers Heaven C# School book covers the .NET framework and the C# language.
subscribe
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!
This comprehensive step-by-step guide will help get your database-driven ASP.NET web site up and running in no time..
subscribe
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell. How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
 
How to: Complex tables and graphics like excell.
How to: Complex tables and graphics like excell.
 
-->