473,500 Members | 1,967 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Manipulating an Excel File in VB.net

I am able to write to an existing excel file with data.
I am wondering how do I outline my rows while in I am writing data to the
excel file while in code?

Thank you for any help that you may provide
E-Cube
Nov 21 '05 #1
2 2155
what do you mean by outline, do u mean highlight ??
"E-Cube" <EC***@discussions.microsoft.com> wrote in message
news:72**********************************@microsof t.com...
I am able to write to an existing excel file with data.
I am wondering how do I outline my rows while in I am writing data to the
excel file while in code?

Thank you for any help that you may provide
E-Cube

Nov 21 '05 #2
Im not sure what you mean either, but you can go into Excel and Record
a Macro. Then you can outline some rows, look at the code and put that
into your vb.net code. That seems to work fine when I have a question
about how to do something in Excel.

hth

Nov 21 '05 #3

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

Similar topics

1
2254
by: caroundw5h | last post by:
I would like to manipulate my excel file as if it were a text file with python (check for duplicates, uppercase etc.). I would like to know: 1) how do convert it first to a CSV file and...
3
20270
by: Otie | last post by:
I found the following under the GetObject help notes and in the example for GetObject: "This example uses the GetObject function to get a reference to a specific Microsoft Excel worksheet...
6
1645
by: Jim | last post by:
I have a Web application that needs to update a Microsoft Excel spreadsheet for complex calculations, whereby I read the results into a dataset for display. I am accessing my spreadsheet using OLE...
1
7611
by: Robin Tucker | last post by:
Heres and interesting problem: I have a VB.NET program that creates reports via. Word Automation. This all works fine. What I want to do as part of this report generation process is to embed a...
1
6464
by: xavierrangel | last post by:
hey guys I'm trying to change the backcolor of a cell in excel using vb6.0 . at first I changed the size like this obj1.Columns(3).ColumnWidth = 15 but now I need to change the color thanks...
4
5723
by: spirit | last post by:
Hi, I have C++ code to write data to a .csv file thereby resulting in an excel spreadsheet. I was just wondering whether it wud be possible for us to further manipulate the csv file like for...
2
2029
by: Paulo | last post by:
using Excel; Excel.Application ExcelApp = new Excel.ApplicationClass(); string workbookPath = Server.MapPath("excel\\produto1.xls"); Excel.Workbook excelWorkbook =...
0
1743
by: Ed from AZ | last post by:
I'm using Word 2003. I use a proprietary Java program that takes all the information in the various forms and generates an XML file. There are times I need to move information between files. I...
0
781
by: Tzesho | last post by:
A director of my company insists on using an Excel database to store his data. I have been tasked to come up with a new GUI in .NET C# that accesses and manipulates the data in his Excel database. ...
0
7018
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...
0
7182
Oralloy
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,...
0
7232
jinu1996
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...
0
7397
tracyyun
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...
0
5490
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
4923
isladogs
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...
0
3110
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...
0
3106
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
0
1430
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 ...

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.