Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing design in excel from VB.NET
Hi,
Please help me with this. I'm exporting data to excel file and I want to customize its apperance (i.e. bold columns name, auto size colums width, freeze some columns). Is it possible? Thanks in advance, Tomek |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
changing design in excel from VB.NET
I find that recording a macro with the proposed formatting changes is a good way to start. This identifies all the issues that you need to consider.
You will need to "tidy up" the code considerably. Be careful when using functions like Ctrl End because Excel may insert a defined range in the code. You will find ActiveCell.SpecialCells(xlTypeLastCell).Row useful to identify the last row on a spreadsheet page. I assume that .Net will be similar to VBA Automation in that you will need to instantiate an Excel object in .Net and the use the methods and properties that you inherit to "manipulate" the formatting i.e. implementing the code that you have created in the first step above. Hope this helps Trevor "Tomek" wrote: Hi, Please help me with this. I'm exporting data to excel file and I want to customize its apperance (i.e. bold columns name, auto size colums width, freeze some columns). Is it possible? Thanks in advance, Tomek |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
What is Design Mode in Excel? | Excel Discussion (Misc queries) | |||
Automatic design for Excel | Excel Discussion (Misc queries) | |||
Using Excel for Design of Experiments( DOE) | Excel Discussion (Misc queries) | |||
How do I design a little game by excel? | New Users to Excel | |||
Enter Excel Design Mode and Exit Design Mode | Excel Programming |