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 Reply

4541

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.goog legroups.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.goog legroups.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.goo glegroups.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.mach in AT dot.state.fl.us
Florida Department Of Transportation

<na******@gmai l.comwrote in message
news:11******* *************** @e3g2000cwe.goo glegroups.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

Similar topics

4279

passing form data to an email address/Excel sheet on a local computer

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 connected to the internet, its a local computer. What i am trying to do is to make a PHP script which will send a simple form data to an excel sheet (or create a new Excel sheet) on another PC on a network.

PHP

25054

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. eg. this only transferes the first record in the area. ..Fields("Uge").Value = ws.Range("A98").Value Sub SelectMaster()

Microsoft Access / VBA

11277

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, The source of all data is a very large size (100*2000) excel spread sheet In which some data types are absulotely Irelevant to access data types in my DB there fore I changed It to a number of excel sheets

Microsoft Access / VBA

10101

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 = GetObject(sFilePath) --> Throws Macro warning window oExcel.Unprotect("password")

Visual Basic .NET

9411

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. In a DateTimePicker control I can set a custom format("MM/dd/yyyy"). So when I iterate through ds1 with currency manager (cma) I see the correct date format in a DateTimePicker control. Is it possible to set a custom date format like that for...

Visual Basic .NET

7069

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 changes according to what the user inputs. I know that Access does not allow you to draw on forms so I decided to put the output in an Excel file for the user but I am having trouble drawing the rectange from Access. Here is my simple code so far: ...

Microsoft Access / VBA

3820

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 the destination path. click some “Convert” button, then the XML data which is present in the text file should be exported to a new excel sheet and this excel should be stored in the destination path which the user already selected. Problem 1: The...

XML

13172

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 only." I have a button on the form which opens the Excel worksheet, which then basically serves as the input form for the Access database. What I need is to somehow get the primary key (EstimateID) of the current record on the Access form...

Microsoft Access / VBA

3209

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 : #!/usr/local/bin/perl use strict; use Spreadsheet::ParseExcel;

Perl

9340

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++

9103

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

9047

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

6646

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...

Microsoft Access / VBA

5967

Couldn’t get equations in html when convert word .docx file to html file in C#.

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 into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...

C# / C Sharp

4477

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

3175

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

2539

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

2118

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General