|
Hi,
Consider the following line,
oWrite.WriteLine(strItem & vbTab & partNo)
The variable partNo is a string that pulls in a number as such, 00001567842. I am using the writeline method to send that string to an excel sheet. I need to have the values in strItem in column 1, and the values of partNo in column 2 including the leading zeros.
I have tried the {1,11}, partNo format or Format("###########", partNo). I have tried declairing partNo as a String as well as an Integer, but neither data types work.
I tried to create a csv file, and it does include the leading 0's but when I use vtab, I get the values of strItem, plus a square (which I assume is the vtab), then my partNo all in one cell.
Is it possible to accomplish what I want with just the WriteLine method?
Thanks in advance.
|
|
|
|
|
Change the Cell's property to Text. I think you need to create an object of Microsoft.Office.Interop.Excel.Style then use NuberFormat property. Just Google it. By default Excel cells are Number type.
--------------------------------
txtSignature
|
|
|
|
|
Could someone please point me to a really good example/tutorial for creating a user control? Specifically I need to create an object that I can place on a form and get mouse click events from. Thanks!
leiby
|
|
|
|
|
A basic user control, as created by the wizard, will, by definition, get mouse events. You just need to handle them in your code, so you can interact with them
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
hi frnd,
check out following link
http://www.startvbdotnet.com/extras/user.aspx[^]
regards,
koolprasad2003
If the message is useful for U then please Rate This message...
Be a good listener...Because Opprtunity knoughts softly...N-Joy
|
|
|
|
|
One of the columns in my datagridview is a combobox column. The datasource for the combobox is a datatable. When the user selects an item from the combobox he wants that item to be removed from the list so that when he navigates to a different line in the datagridview and picks an item from the combobox the previously selected item would appear in the list. How can this be done?
|
|
|
|
|
Remove the item from the datatable and it will remove itself from the combo box
Mike Lasseter
|
|
|
|
|
I've tried that already. If you remove the item that is selected in the combobox, VS displays an error that keeps coming back when you close down the error dialog box. It seems VS cannot display the item in the combobox if it is removed from the list.
|
|
|
|
|
You are not going to be able to use databinding for your combobox. You should be able to create your own combobox column and when it is activated you can load the allowed list of values in the drop down.
Mike Lasseter
|
|
|
|
|
or on selected item changed:
me.combobox1.items.remove(me.combobox1.selecteditem)
|
|
|
|
|
when adding data from a list box to a text box the data is add on after the other
eg. (123456789)
i would like to know if there is a way to make them appear one under another
eg.
1
2
3
4
5
6
|
|
|
|
|
Hi,
the magic value Environment.NewLine causes a string to span more than one line;
use it at your leisure, every time you want to start a new line in a file,
a textbox, etc. Like so: myTextBox.Text="1"+Environment.NewLine+(2).ToString();
BTW: some people use "\n" or '\n' ; on a Windows PC it would have a similar
effect; but other systems may not like it that much.
|
|
|
|
|
When your adding include chr(13) & chr(10) characters.
|
|
|
|
|
Better to use Environment.NewLine becuase it will return the correct value for the operating system in which you are running.
Upcoming events:
* Glasgow: Mock Objects, SQL Server CLR Integration, Reporting Services, db4o, Dependency Injection with Spring ...
"I wouldn't say boo to a goose. I'm not a coward, I just realise that it would be largely pointless."
My website
|
|
|
|
|
i create notepad
and i need with every move by arrows to know column number and line number
md_refay
|
|
|
|
|
What do you expect us to do? Your question is not clear I have no idea what you really need help with. Are you using notepad for something? It sounds like you are trying to catch keyboard entry. What are you trying to do?
Ben
|
|
|
|
|
md_refay wrote: i create notepad
I am afraid Bill has beaten you to that
If you mean you want to create a Notepad lookalike, maybe based on a (Rich)TextBox,
and (its getting a big if) your cursor moves in strange ways when hitting
arrow keys on a (R)TB that is holding jagged text, then I suggest you consider
using the RichTextBox class, not the TextBox, and read up on it; I trust
the RichTextBox.GetLineFromCharIndex() and GetPositionFromCharIndex() methods
would interest you.
|
|
|
|
|
i read text file to view it in printpreview control
i use stream reader to read line by line and i use e.graphices.drawstring to draw line but i must give it font & brush to draw lines so i give them static lines like arial and blue color except of taken this line font and color
this is my code
---------------------
Private Shared filePath As String = Windows.Forms.Application.StartupPath & "\MyDoc.txt"
Private myFont As Font = New Font("Arial", 10)
Private myBrush As Brush = Brushes.Black
While currentLine < linesPerPage
textLine = streamToPrint.ReadLine()
If textLine Is Nothing Then
Exit While
End If
verticalPosition = topMargin + currentLine * myFont.GetHeight(e.Graphics)
e.Graphics.DrawString(textLine, myFont, myBrush, horizontalPosition, verticalPosition)
currentLine += 1
End While
md_refay
|
|
|
|
|
Is there an opposite of Me.DataGridView1.FirstDisplayedScrollingColumnIndex - so that I can determine the maximum ScrollingColumnIndex?
|
|
|
|
|
How can I create an icon for my application in windows control panel using vb.net?
nomorequest
|
|
|
|
|
look at the propertys of you'r project
tabpage application you can set an Icon there
normmally it should display this icon in the control panel then
|
|
|
|
|
i mean, how user can run my config.exe from windows control panel?
|
|
|
|
|
I'm not sure I'm getting this right
are you trying to add a prog to the control panel that will configure another prog of yours??
or what are you excatly trying to do??
|
|
|
|
|
I have a configuration program, it sets sql connection, some parameters etc. of another program. And I want to run it from control panel.
|
|
|
|
|
I don't know how to place it on the control panel but the some maps in the control panel are accesable
for instance:
C:\Documents and Settings\All Users\Menu Start\Programma's\Systeembeheer (english=systemconfig (I think))
maybe you can put you'r prog in there
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
