i need to do a macro. this is what my excel looks like
1 2 3 4
seq1 name name seq2
abcde vv1 abcdddd
abcxy vv2 abcdlmn
[code]....
Using VB.NET i want find a specific string that occurs in column B of an Excelsheet and copy that entire row and paste it in a new worksheet. This string occurs a couple of times in this B column.I know how to open up an excel sheet in VB but I'm having difficulties searching for the string and then copying that entire row and do it multiple times (loop until the end of the column)
View 4 RepliesI want to create a class (I think) that has properties that correspond to column names in a database table, such that they come up in Intellisense when I type the dot after the class name. Is this possible to do?
View 5 Repliesi'm trying to get my program to look up a string and find a match in an access database in column "PhoneNumber" and return the value from column "FullName" on the same row to a different string
so it would go like this: (i really don't know much about accessing databases)
Dim PhoneNumber As String
Dim FullName As String
PhoneNumber = TextBox1.Text
FullName =
I use an OLEDB connection to read from an excel database, and this loop to read in all of the data from each of the columns
While reader.Read()
For i As Integer = 0 To reader.FieldCount - 1
temp = reader(i).ToString + ControlChars.Tab
output_file.Write(temp)
[code]....
Some of the columns contain date information, which are read in fine (usually as a string "2/20/2011" or so), but the headers of those columns are read in as a blank "". The headers for all the other columns read in fine, but not for the date containing columns.
How to add a checkbox column at first column of datagridview including column header?After adding, how to code to "check all" or "uncheck all"?
View 27 RepliesI've tried to use the DMAX Function in my VB windows application to find the highest value in a column in one of my tables, however it doesn't seem to work. After doing some research, I think that the function is only relevant to VBA, although I could be wrong.
'show me the maximum HCCID - DMAX
'Dim HCCNUM As Int32
'HCCNUM = DMAX("[HCCID]", "tblHCC")
How to find the maximum value in a column in one of the tables in my database?
We have a DataGridView with 3 columns: InvoicedOn, PaidOn and Amount
On the MouseDown event is this line of code which needs to be fixed:
MsgBox(DataGridViewPayments.Item("Amount", DataGridViewPayments.CurrentRow.Index), "")
We are trying to find out what the value in the Amount column of the curent row.
We also get this error message:
Conversion from string "" to type 'Integer' is not valid.
how to fix the MsgBox so it will show the value?
I'm connected to an access database using VB 2008.. there is information already located in the tables. But what I am looking to do, is find the "SUM" of all the data in a certain column.
View 35 RepliesWhat I need to do is find a string that can be any value, and is placed between ">" and "</" with a minimun length of 5 and a maximum length of 7 and contains exactly 2 dots.
So if I have a text file like this:
<a href="www.site.com">a site</a>
text<br />
More test<br />
[Code]....
I want it to find only the 5.0.77. And no, the number isn't always between h2 tags, and the number isn't even always the same. The only thing that is static about it is that is is between ">" and "</" and that it is between 5 and 7 characters and contains 2 dots.
In WPF, I have a Uniform Grid and would like to be able to find the row and column based on the index of a child element.
I know there is a mathematical way of doing this and would rather not use a normal Grid.
If it helps, I can get the total number of rows and columns by using:
Math.Sqrt([*uniformgrid*].Children.Count)
I am using an oleDb connection to connect to an excel spreadsheet (.xlsx) file and load the information into a datagridview. From there I hope to have it edited by a person and programmatically at runtime. However, I noticed that when I import a file that has integers in a column, it will not import any of the string values in that column. Also, It will not allow me to manually enter strings into that column at runtime - it results in an error stating: [Code]
View 16 RepliesI have two text files, the first text file has two columns separated by a space (" ") and the second text file only has one column.
The column 1 in text file 1 and text file 2 match albeit in different order, what I'm trying to achieve is for every field in column 1 text file 2 I want to search for column 1 in text file 1 and display the matching column 2 field in column 2 text file 2.
Dim*OpenTextFile*As*String*= IO.Path.Combine("C:Test1.txt")
Dim*OpenTextFile2*As*String*= IO.Path.Combine("C:Test2.txt")
Dim*SaveTextFile*As*String*= IO.Path.Combine("C:Test2.txt")
[code]....
Add persistence to multible DataGridView in terms of Hide/Show column and column width
View 1 RepliesVB GridView control will not allow code in the vb code file to access a data column that has its visible property set to false. When it is set to true, the data column can be accessed with no problem. Any suggestions as to how to correct this? I have looked through the documentation, text books, and I have not found anything that gave me any clue as to what the problem could be. I thought that the property was just applied to the column, not that it would remove the column from being accessible.
[Code]...
I am trying to placed several check boxes (15) in a group box or on a form. I receive the following error message in Visual Studio:
Cannot set column, "The value violates the MaxLength limit of this column".
I have been trying to find out how to resize listview column width to the largest widthor either column header or item in c#
[URL]
I have a listview and i want to make one column's font smaller than the other column to fit form design. How will i do that?
View 1 RepliesIt seems that on clicking datagridview column header, the column will be automatically sorted based on the column type. I have a column showing some numbers. If column type is string, it sorts "1","20","3" into "1","20","3". If column type is double, it sorts into "1","3","20" which is the result that I want. However, there might be some erros in the numbers and error messages(text) will show in the cell instead of numbers. So I cannot set the column type as double. I want to ignore these error messages and sort all the numbers. How can I do this?
Also, I need to add some background colors to different rows in datagridview. So in the column header click event, I call the bkgColor Sub to achieve this. My question is that how can I override the sorting method in this event?
Private Sub DataGridView1_ColumnHeaderMouseClick(sender As Object, e As System.Windows.Forms.DataGridViewCellMouseEventArgs) Handles DataGridView1.ColumnHeaderMouseClick
Try
[code]....
i have one gridview with additional column (the additional column is not attach to database) but i want to import it to excel, but i used the common export to excel coding like below:
Code:
Response.Clear()
Response.AddHeader("content-disposition", "attachment;filename=search.xls")
Response.Charset = ""
[Code]....
and when i export, the data cannot be copy/read and cannot be export to excel. other than that, i have it set to be in xls format but it changed to xml format.
I've been putzing around with this for awhile but I need to delete column B (minus the header) when ever it is empty.
If xlWorkSheet.Range("B2:B65565").Value = "" Then
Dim rg As Excel.Range = xlWorkSheet.Columns("B")
rg.Select()
rg.Delete()
End If
I am reading an Excel file into VB.NET. There are 4 columns containing dollar figures of varying amounts. Here is what I need to do is identify the columns with the highest $ figure, the next highest, etc. and mark them so that .NET can identify them (e.g. col3 is highest so rank1 variable is "col3" and so on).So I am dealing with Excel Ojects which is new to me and sorting which is new to me. If it helps, here is how I am reading in the Excel file:
xlsWorkBook = xlsApp.Workbooks.Open(folders(f).ToString & "" & fileInFolder.ToString)
xlsWorkSheet = xlsWorkBook.Worksheets("Sheet1")
Dim ColumnNumber As Integer = xlsWorkSheet.Cells(1, StartColumn).Column
[code].....
Im designing a form that connects to excel file as its backend. Im trying to design the form to add a new column to the excel file base on the name enter on the form. But Im having problems developing the code that will allow me to do so. I believe the code is base around using the "Alter" in my "sql" but Im not too sure how I execute the whole thing. Can someone please help me to add a column to an excel file using vb.ent?
The way I have my code right now, is...
Public
Shared
Function functionName (ByVal
titleEnter As
[code]....
I'm using the following code to search an excel document for the highest value within a range. What I need is to get the column letter that corresponds with that MAX value.
xlTemp.Workbooks.Open("http://somesite/" & String.Format("{0:yyyyMMdd}", DateTime.Today.AddDays(7)) & ".csv")
xlTemp.Visible = False
[Code].....
I have a datagrid that I am unable to change the width setting, it always reverts back to the original setting.
To change this setting:
1. select the datagrid view tasks
2. Edit columns bound column properties
3. Select Width property
4. Width property will always revert back to the original setting.
I have check the properties settings without any luck.
i have a datagridview with three columns. i set the first column to visible=false, so the user can only see two columns.when the user presses the tab key in the first visible column -- column(1), i want to ignore column(2) so that the user only tabs through the rows in column(1)i can't get it to work. it will always tabs through the rows in column(2) even if i use the column name.
[code]...
I want to disable column in datagridview so the column will not receive focus,
when user press tab to move from cell to cell this column will be skipped and the focus move to the next cell or column.
I have a program and I get time data from a sqldb and display it in a column in a listbox. What are the proper steps for adding the time as I iterate through the data in the column? I figure I will need to do some conversions on the time to be able to add it and display it as a total.
View 9 RepliesI have many files at work that need to be copied from one directory to another. However, I do not need to copy all the files at once.
I get excel sheets with the list of files that need to be copied once a week. So, in the main directory there is about 150.000 files and I only need to copy about 800 at a time.
I am thinking of having a textbox and an open dialog so I can pick the directory the main files are at - another one where I can choose where they will be copied to.
The problem is the list will be in excel sheet (column A). How do I have vb.net (2008) see the file names in column A and find them and move them?
Right now, I have macros in excel doing the job, however, I have so many things in this excel I need to transfer this part out and into vb.net.
The macro in excel doing the job is:
Code:
Sub CopyFiles()
Dim objFSO As FileSystemObject
Dim strSourceFolder As String
[Code]....
Looking at deleting columns in excel and have found several threads that show how to delete an entire column which I have tested and done successfully. These columns were all identified by "A", "B", "C" and so on...
I was wondering if it was possible to do the same thing using the column headers. When deleting the columns in excel, one has to keep in mind that columns deleted from the left will shift the entire sheet to the left and if one is not careful, the next column[code]...
Let's say a user wants to delete the 'Middle' column (assume as column B in excel) and then delete the 'Suffix' column (assums as column D in excel). If they don't know to work from right to left when deleting columns, they would write code that would delete Column B and then repeat that code for Column D. However, once column B is deleted, all columns will shift left, which will result in the 'Phone' column (formerly column E now column D) being deleted instead of the 'Suffix' column (formerly column D now column C).
If there was a way to delete the columns by their headers (i.e. Middle, Suffix...) this would eliminate the problem; to me it seems a bit more intuitive as well.