472,359 Members | 1,604 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,359 software developers and data experts.

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

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

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

Similar topics

9
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...
3
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....
11
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, ...
4
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...
1
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. ...
7
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...
2
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...
7
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...
2
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 : ...
2
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...
0
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...
0
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...
1
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...
0
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...
0
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...
0
hi
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...
0
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...
0
BLUEPANDA
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...

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.