The following code is excerpted from a larger procedure (the surrounding code is not relevant). why I am unable to get the second ContainsKey line to return True? Hint: try this on a worksheet with just a few populated cells to reduce looping.
For Each ws As Excel.Worksheet In Wb.Worksheets
Dim dic As New Dictionary(Of Excel.Range, String)
rngUsed = ws.UsedRange
[code]....
I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel *and* define the Range using numbers.Alright, so I have objects being created depending on the file that the user opens. So there could be 100 objects or there could be none. Now each object has an array of values, and these arrays contain nearly 15000 elements. So here is what I want to do but I can't figure out how to escape using the LetterNumber:LetterNumber combination.
For every object I want a new column to be occupied and for every element in the objects array I want the row to be occupied. I figured the easiest way to do this was using a for loop but, again, I can't use numbers.
For columns = 0 to NumberOfObjects
For rows = 0 to NumberInArray
Cell(0,0).Value = myObjectsCollection(column).Array(rows)
Next
Next
I am using Excel interop in my VB.NET program. My problem is that I can't seem to figure out how to write to Excel and define the Range using numbers.
Alright, so I have objects being created depending on the file that the user opens. So there could be 100 objects or there could be none. Now each object has an array of values, and these arrays contain nearly 15000 elements. So here is what I want to do but I can't figure out how to escape using the LetterNumber:LetterNumber combination.
For every object I want a new column to be occupied and for every element in the objects array I want the row to be occupied. I figured the easiest way to do this was using a for loop but, again, I can't use numbers.
For columns = 0 to NumberOfObjects
For rows = 0 to NumberInArray
Cell(rows , columns).Value = myObjectsCollection(column).Array(rows)
Next
Next
How to get the first row index of a named range in excel sheet from vb.net code...for example I set the column 1 of row 2 to column 5 of row 4 a range named it "MYRange" ( it is set from excel sheet )
View 1 RepliesI'm working on pasting arrays into excel ranges. Suppose I have a range: A1:A5 and an array a = {1,2,3,4,5}. I can set up the problem like this:[code]So, I got curious about the Transpose method, and whether I could construct my array properly so that I didn't need it. I found that Transpose converts my array into a 2d 1-based array (so the first element is (1,1) not (0,0) as usual).Now I'd like to know: Is there a standard VB-way other than the worksheet transpose function that I can use to build a 1-based 2D array the way Transpose does?
View 4 RepliesI want a combined Ranges. How do I combine two ranges into one?
Dim range1 as Excel.Range = osheetTemperatureData.Range("A7:"A10")
Dim range2 as Excel.Range = osheetTemperatureData.Range("C7:"C10")
Dim range3 as Excel.Range = range1 + range2 '????
how to get list of all named ranges in an excel sheet.
View 5 RepliesI created an e-mail program in VB2008. I have an excel file with a list of all e-mail addresses and attachments to those e-mail addresses. What I want to do is import thethe e-mail addresses and attachments into my program. I want my program to then take each e-mail address (automatically) and insert them with their attachments into their respectable fields in the program. The primary objective is to insert 200 e-mail addresses and attachments. Each attachement is significant to each e-mail address.
[Code]...
I have to compare two columns in two different Excel sheets and delete the duplicates. I have come up with several strategies that work, but I am searching for the most efficient way to do this. At first, I was sorting the columns and looping through them in the manner of a sequential update and deleting when the cell values were equal. But I discovered here an article by Mike Rosenblum that explained that it is much more efficient to stick the columns into an array and iterate them from there. So I was able to do that. There was a complication in that once I had deleted a row, then the array and the spreadsheet were out of sync. So I had to compensate by incrementing a variable each time a row was deleted, and subtracting this variable from the array index to calculate the row to be deleted in the spreadsheet.
So now I am wondering whether there is a better strategy. I thought that if I could merely hide the rows to be deleted and then find a way to delete all hidden rows at once after the loop was over, then this would eliminate the problem of the array and the spreadsheet getting out of sync and would make the code easier to understand. I thought of putting the row numbers of the duplicates into another array and deleting the rows after the comparing loop. But this creates the same problem of having to compensate the row numbers in the array.
In a tic tac toe game I'm working on I have 2 dictionaries (plyrPairs and cmptrPairs) In the program there is a procedure that is used numerous times. The procedure varies with the dictionary that it calls. I'd like declare a variable in a sub procedure that will represent these two different dictionaries. Here is what I have:
Here are the two enumerations:
vb.net
' Assign values to player pairs enumeration
Private Enum plyrPairsList
empty = 0
[Code].....
I have created a service that updates dictionaries and outputs an xml file of the contents. It will do it fine first time round, but then I get the following exception when it tries to do it the second time
system.argumentexception an item with the same key has already been added
Is there anyway I can set it so that the dictionary contents are overwritten each time?
I have a problem detecting whether one of the arrow keys is pressed, all the other keys seem to be detected apart from the arrow keys??? I have set key preview to True........ It detects the arrrow keys BUT ONLY if I have NO other controls on the form??? example..
Me.Text = e.keycode
It works, but then if I add a button for example, it stops.
I have the following object:
countDictionary As Dictionary(of Category, Dictionary(of Date, Integer))
The Class has a Enumeration Property. For the purposes of demonstration, I'll call it MasterCategory.I have been trying to get out an object that looks like the following:
groupedCountDictionary As Dictionary(of MasterCategory, Dictionary(of Date, Integer)
The best result I could get was:
Lookup(of MasterCategory, Dictionary(of Date, Integer))
From:
countDictionary.ToLookup(Function(o) o.Key.MasterCategory, Function(o) o.Value)
Which results in a IEnumerable (Of Dictionary(of Date, Integer)) for each MasterCategory value.However, I need that IEnumerable of Dictionary flattened to one dictionary with all the integers summed (total counts) for each date. I then tried to use various selects and group bys (from numerous stackoverflow posts) to "flatten" it, but my efforts have fallen short.
Current Code
[Category Class]
- MasterCategory As Enum
- Name As String etc
[code]....
just wondering how i could give my auto typer hot keys, for example they press f1 to start the typer f2 to stop it.
[Code]...
I'm trying to create a shortcut which expands or collapses my treeview using the ctrl+alt+up-arrow or ctrl+alt+down-arrow:
If Keys.ControlKey And e.KeyCode = Keys.Alt And e.KeyCode = Keys.Down Then
mytreeview.ExpandAll()
End If
[code].....
How could I loop through a list of the keys that are available in the 'Keys' enumeration? It seems like it should be something easy to do, but I'm not having any luck finding a collection that I can loop through.
View 6 Replieshow to display the ranges here is the assinment Your homework assignment will create a project that uses an array to store the sales figures for 20 employees at a computer store. Declare a 20-element one-dimensional array named Sales .
[Code]...
I am creating a program that takes into account pay from a job. I will try to describe the problem I am having using some psuedo code - so dont take syntax too seriously.
I created a structure that has some of the following values:
Name as String
Amount as Double
FrequencyType as MyEnumerator
MyEnumerator looks like this:
EveryTwoWeeks = 1
TwiceAMonth = 2
Weekly = 3
Now my problem is how do I add the date ranges into my structure?If your pay is weekly or twice a week, then I just need a single date because all other paydays should increment in 1 or 2 week blocks. But if the pay is twice a month I need two dates. It seems like there has got to be a better way then just having two dates in my structure and knowing that you just need the 2nd date if the FrequencyType is = 2 (TwiceAMonth).I was thinking that instead of a Structure I should use a class and then I could create a function that returns the date or dates depending on the enumeration type that you pass into it.What would be the "correct" way of doing this? I think I need a type of enumerator that allows for more then just integer type values.
[code]...
I am developing a billing application to help out the billing lady who has been doing our billing by hand. I am essentially done�. Except for one class of customer I can�t wrap my head around. Nuts and Bolts:
1.Data comes from a table that shows Storage id, customer id, Billing Start date, Billing end date.
2.I am kicking the data back out to a table and I�ll build her a nice little crystal she can run.
Problem:We rent storage space. If multiple customers use the same storage then they will split the cost of the daily fee. If there is 3 customers they each pay a third etc. This seems simple but If Customer 1 starts on 1/1/12 and ends 1/10/12 she pays 10 days. If Customer 2 comes in 1/3/12-1/9/12 they will split 7 days. If Customer 3 comes in only on 1/9/12 then they will all pay a third on that day. Now imagine this across 600+ storage units and 1000+ customers and each customer using multiple storage at any given time.
My biggest issue is I don�t know how to express how we do that calculation by hand programmatically. By hand process and how I figure I am eating the elephant: Find every Customer that has used the Space in the billing period -Determine the unique storage numbers that were used during the billing cycle kick the results to a storage table on an access database. I am using a table because I figured it would be less of burden for the application then a list or array.
Determine where there is overlap - Use �FOR� to cycle through the orginal data table using the unigue. Here is where I am stuck. How do I compare the dates in a way to determine which customer is using it when compared to the others. Obviously i can determine the difference in dates between the start and end. It is getting the applicaiton to recognize the dates are with in the other dates. here is kind of what I was thinking obviosly this doesn't work I am just using the format so don't crush me too bad because I code like a caveman.
Dim CustomerDifference as time span
Dim UniqueStorage as Integer
Dim Customer as string
[code]....
What's up guys. Simple question today. How do you specify ranges of values for location? Basically i'm trying to write an if statement that will execute if a location matches a range of values, here is th snippet of my code im having trouble with:
If Player.Location = New Point(0 To 240, 240) Then code here
But that didn't work at all, there was no error, but the code just wouldn't execute when the "player" was in that range!
I have a collection as such
Private Shared ReadOnly thermoPaths As New ReadOnlyCollection(Of String) _
({
"thermometer_000_108x320.jpg",
"thermometer_010_108x320.jpg",
"thermometer_020_108x320.jpg",
"thermometer_030_108x320.jpg",
[Code]...
I am trying to make a program, where a user will input 'ranges' in a richtextbox, and then enter a value, which will be stored/categorized (in an array maybe) according to the 'range'.What I exactly mean is:
User specifies ranges by inputting this line in the richtextbox: <,10,20,30,> First range = < to 10 (no minimum boundary up to 10), second range = 10 to 20 , 3rd = 20 to 30 , 4th = 30 to > (30 to no maximum boundary) Then a user enters a number. For example "-1" would fall in the "< to 10" category, "23" in the "20 to 30" category, "125" in the "30 to >" category. I know there are other ways to do this, but I would like to see a solution (or some guidance) based on these requirements.
I'm performing some statistics on a txt file that has multiple columns using a collection list (vb.net 2008). My files can contain 100,000+ samples per file. How would I code my function to have it perform work on the first 3000 samples and continue the calculations on every 3000 samples thereafter?
Private Sub decimationButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles decimationButton.Click
Dim lines() As String = System.IO.File.ReadAllLines(inputFileName) '("TEXT_FILE")
Dim list As New List(Of Double())
[code]....
I have a variable called hour that will be used to display different text in a textbox based on what time it is. Basically, if the time falls between 12am and 3am, hour = 0, if the time is between 3am and 6am, the hour is 1, etc, breaking the day into 8 'hour's. How would I do this in vb?
View 7 RepliesThis is my first program and have absolutely no training in programming Visual Basic Studio 2008 so forgive me if I have missed something obvious.Form3 contains a StartDate(Date Time Picker1)and EndDate(Date Time Picker2) with a button1 which launches a Form4 containing a report( Microsoft Report Veiwer)
I have been able to generate a report but it gives me everything in the database instead of date range selected.I have tried generating queries,stored procedures and writing additional code but nothing seems to work.( Though I may of but them in the wrong place)
Is it possible in VB to reference named ranges in an excel spreadsheet and pull the correct data?
View 1 RepliesI need to calculate the location of intersections between multiple date ranges, and the number of overlapping intersections. Then I need to show which date/time ranges overlap each of those intersecting sections. It is slightly more complicated than that so I'll do my best to explain by providing an example. I am working in VB.Net, but C# examples are acceptable as well as I work in both.
We have several high risk tasks that involve the same system. Below I have three example jobs named HR1/2/3/4 with start and end date/times.
HR1 {1/6/2010 10:00 - 1/6/2010 15:00}
HR2 {1/6/2010 11:00 - 1/6/2010 18:00}
HR3 {1/6/2010 12:00 - 1/6/2010 14:00}
[Code]....
i am a beginner learning vb.net. I have an excercise to create a form and on clicking the totals buttons it should display the number of employees who have earnt a salary within the ranges below. Now this code works, but i want to substitute the Select Case Statement with a more efficient for..next statment to increment my counter. The code is:
[Code]....
So I found this little morpg. The game is fun but really repetitive. I would like to simplify some of the tasks in the game. I do not know how to start this project. How can I recored arrow keys and then tell the computer to enter the arrow keys? One of the objectives in the game is to run around a farm 2x and scare away any wolfs. So the commands would be "arrow key up" for 30sec and then "arrow key right" for 4 sec and repeat. I have worked with robots in real life for some time. We would fill arrays with such instructions. One of the most fun things to program! But I have no idea how to do this in VB.
View 12 RepliesI need to capture the left and right arrow keys in Form1.KeyDown event so I can use them as hot keys. Instead they seem to be assigned to tab order (move focus to previous/next control) and the KeyDown event never gets called. How can I remove the arrow keys from tab order and use them for my hot keys instead?
View 2 Replies