Loading data of a excel sheet or excel sheet format in Rich TextBox Control

natrajsr

Hi,

I want to load the data of a excel sheet or in the exact excel
sheet format into a Rich TextBox control.

I have already worked with loading WORD into a Rich TextBox. It is
working fine.; But it is taking long time for our need. So we thoguht,
we can find another better solution rather than that.

Can anyone help me to find out how to load a excel sheet or in the
exact format data into a RIch TextBox control ?

Can u please give me another good solution for my requirement ?

Thanks in Advance !
Natraj.

Sep 11 '06 #1

Subscribe Post Reply

4394

Ignacio Machin $ .NET/ C# MVP $

hi

you can use OleDb to read an excel sheet. I can send you the code if you
need it but it should be trivial to find.

How you want to have it displayed in the RTB?
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

<na******@gmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...

Hi,

I want to load the data of a excel sheet or in the exact excel
sheet format into a Rich TextBox control.

I have already worked with loading WORD into a Rich TextBox. It is
working fine.; But it is taking long time for our need. So we thoguht,
we can find another better solution rather than that.

Can anyone help me to find out how to load a excel sheet or in the
exact format data into a RIch TextBox control ?

Can u please give me another good solution for my requirement ?

Thanks in Advance !
Natraj.

Sep 11 '06 #2

natrajsr

Hi Machin,

Thanks for your reply !

I have the data in a DataTable. I have done already using creatng
Word table and loaded into RTB. But this is raising a performance
issue. So that i want to move to a better solution.

I can convert to excel sheet and read that..But my problem is how to
load the excel data in RTB (as Table format - in visual) ?

Thanks again !
Natraj

Ignacio Machin ( .NET/ C# MVP ) wrote:

hi

you can use OleDb to read an excel sheet. I can send you the code if you
need it but it should be trivial to find.

How you want to have it displayed in the RTB?
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

<na******@gmail.comwrote in message
news:11**********************@e3g2000cwe.googlegro ups.com...
Hi,

I want to load the data of a excel sheet or in the exact excel
sheet format into a Rich TextBox control.

I have already worked with loading WORD into a Rich TextBox. It is
working fine.; But it is taking long time for our need. So we thoguht,
we can find another better solution rather than that.

Can anyone help me to find out how to load a excel sheet or in the
exact format data into a RIch TextBox control ?

Can u please give me another good solution for my requirement ?

Thanks in Advance !
Natraj.

Sep 11 '06 #3

Ignacio Machin $ .NET/ C# MVP $

Hi,

Humm, I don't think that the RTB is the best control for this, what about
using a ListView in details mode or even a datagrid?
It would be trivial using a datagrid and bind it at runtime to the dataset,
you will have the columns generated for you.
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation
<na******@gmail.comwrote in message
news:11**********************@d34g2000cwd.googlegr oups.com...

Hi Machin,

Thanks for your reply !

I have the data in a DataTable. I have done already using creatng
Word table and loaded into RTB. But this is raising a performance
issue. So that i want to move to a better solution.

I can convert to excel sheet and read that..But my problem is how to
load the excel data in RTB (as Table format - in visual) ?

Thanks again !
Natraj

Ignacio Machin ( .NET/ C# MVP ) wrote:

>hi

you can use OleDb to read an excel sheet. I can send you the code if you
need it but it should be trivial to find.

How you want to have it displayed in the RTB?
--
--
Ignacio Machin,
ignacio.machin AT dot.state.fl.us
Florida Department Of Transportation

<na******@gmail.comwrote in message
news:11**********************@e3g2000cwe.googlegr oups.com...
Hi,

I want to load the data of a excel sheet or in the exact excel
sheet format into a Rich TextBox control.

I have already worked with loading WORD into a Rich TextBox. It is
working fine.; But it is taking long time for our need. So we thoguht,
we can find another better solution rather than that.

Can anyone help me to find out how to load a excel sheet or in the
exact format data into a RIch TextBox control ?

Can u please give me another good solution for my requirement ?

Thanks in Advance !
Natraj.

Sep 11 '06 #4

by: sifar | last post by:

Hi, I am right now learning PHP & want to know if there is a way to send web form data to an Excel sheet located on a network. My windows xp PC doesnot have a copy of Excel. Also i am not...

PHP

VBA code help Export Excel data to Access table

by: Mads Petersen | last post by:

I'm stuck in this code. Hope you can and will help me. I launch it from excel. I have made the following code work, but not as i whant. I need the ranges to be working with something like xlDown....

Microsoft Access / VBA

How to insert bulk data into an existing data base?

by: Hi5 | last post by:

Hi, I am new to access I usedto work in Oracle and Mysql. I am after a way that enables me to populate a database I designed in access with lots of data which can be sorted in excel sheets, ...

Microsoft Access / VBA

Disable Excel Macro warning?

by: Rich Wallace | last post by:

Is there a way to open an Excel file and either respond to or supress the Macro warning window via VB.NET? Dim oExcel As Excel.Workbook Dim sFilePath As String = "C:\DailyReport.xls" oExcel...

Visual Basic .NET

set custom date format for bound textbox?

by: Rich | last post by:

Hello, I have some datefields in a dataset (ds1). I bind some textbox controls on a windows form to these date fields in ds1, but I only want to see 01/01/2004 instead of 1/1/2004 8:00:00 AM. ...

Visual Basic .NET

Access Drawing Rectangles in Excel

by: ddecoste | last post by:

I have a need to add a visual representation to some data in Access. I need to draw a matix of squares inside another square. I have all the data that I need in a record in Access. The data...

Microsoft Access / VBA

Export XML data from text file to Excel file

by: pulavarthipraveen | last post by:

Overview: We have a requirement in the c#.NET 1.0 windows application. There will be some input text file in the user’s machine. The user should browse and select the input text file and also select...

XML

Get data from Access form into Excel using ADO

by: kpresidente | last post by:

Hello all, I'm trying to transfer the value of a control on an Access form to an Excel worksheet using VBA. The Access form is a single form with all the controls disabled, so that data is "read...

Microsoft Access / VBA

How to print the header only once in the new Excel

by: ravir81 | last post by:

Hi, I am working on excel reporting using Perl. I am facing problem with writing the header part only once for all the excels created using Perl. Here is the code : ...

Perl

Benefits of Blockchain App Development for Enterprise Businesses

by: Kemmylinns12 | last post by:

Blockchain technology has emerged as a transformative force in the business world, offering unprecedented opportunities for innovation and efficiency. While initially associated with cryptocurrencies...

General

Basic concepts of WebLogic Admin training?

by: Naresh1 | last post by:

What is WebLogic Admin Training? WebLogic Admin Training is a specialized program designed to equip individuals with the skills and knowledge required to effectively administer and manage Oracle...

Oracle Database

Hyperconverged All-in-One Streaming Engine, ushering in new age for distributed database

by: antdb | last post by:

Ⅰ. Advantage of AntDB: hyper-convergence + streaming processing engine In the overall architecture, a new "hyper-convergence" concept was proposed, which integrated multiple engines and...

General

How to layout php header location with a variable as the location?

by: Matthew3360 | last post by:

Hi there. I have been struggling to find out how to use a variable as my location in my header redirect function. Here is my code. header("Location:".$urlback); Is this the right layout the...

PHP

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computer

by: AndyPSV | last post by:

HOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and on my computerHOW CAN I CREATE AN AI with an .executable file that would suck all files in the folder and...

General

How do I view Redshift db tables in Alteryx

by: Arjunsri | last post by:

I have a Redshift database that I need to use as an import data source. I have configured the DSN connection using the server, port, database, and credentials and received a successful connection...

General

by: WisdomUfot | last post by:

It's an interesting question you've got about how Gmail hides the HTTP referrer when a link in an email is clicked. While I don't have the specific technical details, Gmail likely implements measures...

General

One of the easiest ways to set the background color of Excel documents in Java

by: Carina712 | last post by:

Setting background colors for Excel documents can help to improve the visual appeal of the document and make it easier to read and understand. Background colors can be used to highlight important...

General

Join our open community on Discord to learn programming, SEO, and marketing

by: BLUEPANDA | last post by:

At BluePanda Dev, we're passionate about building high-quality software and sharing our knowledge with the community. That's why we've created a SaaS starter kit that's not only easy to use but also...

General

Loading data of a excel sheet or excel sheet format in Rich TextBox Control

Similar topics