How to Export data from textfile to Excel sheet in VB.NET

Mamatha

Hi

I want to export data from textfile to Excel sheet in
VB.NET application.When i copy the text file into Excel
sheet the data of text file are copied to only one cell of
the Sheet.
Now i want like this: Each item of the textfile will be
displayed into different cell of the sheet(one item
corresponds to one cell horizontally).How can write code
for this in VB.NET.

Mamatha

Nov 21 '05 #1

Subscribe Post Reply

2799

Paul Clement

On Sun, 21 Nov 2004 21:51:16 -0800, "Mamatha" <ma***********@yahoo.com> wrote:

¤ Hi
¤
¤ I want to export data from textfile to Excel sheet in
¤ VB.NET application.When i copy the text file into Excel
¤ sheet the data of text file are copied to only one cell of
¤ the Sheet.
¤ Now i want like this: Each item of the textfile will be
¤ displayed into different cell of the sheet(one item
¤ corresponds to one cell horizontally).How can write code
¤ for this in VB.NET.

Could you post a few lines of your text file?
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Nov 21 '05 #2

by: Steven Stewart | last post by:

I have a user who has been using Excel for a while to keep statistics and print reports. She finds using it cumbersome because of long formulas and a lot of copying and pasting. I have designed...

Microsoft Access / VBA

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 data into Excel sheet from VB.NET

by: Mamatha | last post by:

Hi When i clicked a button, i want to insert data from listview in VB.NET to Excel sheet. If you know the solution either above or below is ok for me. I know how to insert from a textfile,but...

Visual Basic .NET

Export Data to Excel

by: Elena | last post by:

I'm trying to export data to an Excel worksheet. I can export the data in the cell values perfectly. I need the code to change a header and footer for the worksheet, not for the columns. Is...

Visual Basic .NET

Export To Excel

by: Jiro Hidaka | last post by:

Hello, I would like to know of a fast way to export data source data into an Excel sheet. I found a way from C# Corner(Query Tool to Excel using C# and .NET) which is a neat little way of...

C# / C Sharp

Export to Excel (Default File Type - Excel)

by: Hemant Sipahimalani | last post by:

The following piece of code is being used to export HTML to excel. HttpContext.Current.Response.ContentType = "application/vnd.ms-excel"...

ASP.NET

Export data to Excel

by: Vanessa | last post by:

hi Everyone, I have two questions on exporting data to Excel using ASP (w/o converting formatted excel file into web page and then plug in the dynamic data): 1. Can we export data into...

ASP / Active Server Pages

How To Export Your Displayed Data To Excel

by: Merlin1857 | last post by:

Its great producing data for users to look at in your web pages and generally that is sufficient for their needs but sometimes you may want to supply your user with the data in a form they can...

ASP / Active Server Pages

Export to excel mutiple sheet

by: hemantbasva | last post by:

Note We need to have a template on server for generating report in multiple sheet as we do not had msoffice on server moreover this require a batch job to delete excel file created by the...

.NET Framework

How to turn on java script in a villaon keypad mobile phone

by: Charles Arthur | last post by:

How do i turn on java script on a villaon, callus and itel keypad mobile phone

Java

Batch import of multiple excel files into the database

by: ryjfgjl | last post by:

If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...

Data Management

Merging data from multiple Excel files

by: ryjfgjl | last post by:

In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...

Data Management

Migrating Website to Cloud - Emmanuel Katto

by: emmanuelkatto | last post by:

Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel

General

Looking to do Android software development, any suggestions? Is flutter better?

by: nemocccc | last post by:

hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

General

How to build RAID in BIOS?

by: Hystou | last post by:

There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

Computer Hardware

Changing the language in Windows 10

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

Windows Server

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,...

C / C++

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

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

Online Marketing

How to Export data from textfile to Excel sheet in VB.NET

Similar topics