I am creating a maths programs that draws graphs for the user. so far i have placed 22 values into an array and now i need to import them to excel, draw the graph and import the graph back into the program to display them.[code]...
View 4 RepliesIs it possible to create a plot from List(Of Decimal) values in Excel with VB? I would like to avoid dumping data directly into a table, then creating the chart from that. Here is what I have so far, but I am getting a data type mismatch when I try to assign .XValues and .Values to the list. Is there some sort of conversion that needs to happen to turn a list into a series?
Dim Series As Excel.Series
Dim xVals As New List(Of Decimal)(New Decimal() {1, 3, 4, 5})
Dim yVals As New List(Of Decimal)(New Decimal() {2, 2, 2, 2})
[code].....
how to export textbox values to excel.
View 1 RepliesI'm trying to import excel file into sql sever and then get some values that I decide.I read several posts but anyway I don't succed to proceding.First:
mypath=textbox1.text
Excelconnection = New OleDbConnection("provider=Microsoft.Jet.OLEDB.4.0; data source=" + myPath + "; Extended Properties='Excel 8.0;HDR=Yes;IMEX=1'")
Excelconnection.Open()
[Code]...
How do I effectively declare a Global Array which I can access the values of that array from any procedure? I have a Userform from which I will call various sub procedures depending on the actions performed on the useform. I have one procedure (Procedure1) where I have set up a multidimensional array and input values to it. I have another procedure (Prodedure2) where I want to access the values in the array - I DO NOT want to pass the array values directly from Procedure1 to Procedure2.
View 5 RepliesI am using Visual Basic express edition 2008.I am trying to know if a value in a single dimensional array is repeated in the array. If yes, then multiply one of them by 100. For example:
MyArray (14) = 12, 15, 18, 15, 18, 11, 15, 18, 16, 14, 18, 8, 12, 17, 10
In the above example:
MyArray (1) = MyArray (3) = MyArray (6) = 15
MyArray (2) = MyArray (4) = MyArray (7) = MyArray (10) = 18
MyArray (0) = MyArray (12) = 12
[Code]...
I have an array of 10 x 10 as shown below. In addition to -1, it consists of numbers from 1 to 9.[code]...
View 6 Repliescast integer values to an array of enum values?
View 2 RepliesI have created an application that can store employees details, that part is not a problem and frankly is sorted, I have used a sql database to save my data, all information is displayed in TextBox controls on my main form.
The part I am struggling with is creating 2 buttons.
The first button I want to be able to import data from an excel file into my data set
The second button I want to create is a back-up button, which exports all the data from my dataset into an excel file
I have to import a tab delimited file into Excel and export it back out to correct a formatting issue caused by FoxPro. I need to pad a column with 10, Zeros and that is good with this here: objxl.columns("B:B").numberformat="0000000000". However I have 2 cells in the sheet, row 1B and 2B that I want to exclude from the number format above. Because it is a date field and it writes to that same column so it pads my date. I do have a need to Pad that date field with mmddyyyy so I have to pad it 8 - zeros.
View 5 RepliesIm trying to add an export import method in visual basic. Export from Access database to Excel Worksheet or .csv. And Import From Excel worksheet or .csv to Access database
View 3 RepliesI'm creating a small application that will export the record from database to excel format (.xls) and import the record from excel as well. i have this code below i dont if this the right approach but im getting the error. Im using emulator btw. error :"The process can not access the file 'My Documents est1.xls' because it is being used by another process." Code: I'm still figuring out about import function any ideas?
View 2 Repliesis excel Import and export format supported in windos mobile development? because i cannot find it in add reference..
View 1 RepliesI have a program that reads in lottery results from the past 6 months (from the national lottery site) from a text file
31-Mar-2010,29,18,38,44,14,43,13,3,GUINEVERE
27-Mar-2010,32,38,11,15,42,6,24,2,GUINEVERE
24-Mar-2010,3,49,28,5,23,42,41,4,GUINEVERE
and stores it in an array (n-1,6) where n is the number of lottery lines, so the array looks like
0 1 2 3 4 5 6
0 29 18 38 44 14 43 13
1 32 38 11 15 42 6 24
then, in a 1D array I store the player's numbers, simply as
0 23
1 16
2 19
[code]....
I want it to take each number from the player's number array individually and compare them to each row individually in the lotto results array i.e. the first six cells in each row in the results array will be compared with each user number to find any matches, if a value matches then a count is incremented. if the count is greater than 2 but i'm getting no where with it :( i've been trying to use the For To loops but keep getting index out of range, or else nothing is happening at all!
I currently have a DataGridView that grabs SQL data and exports it to a csv file. The problem I'm encountering is when my data already contains commas.
In the datagrid and csv file some of the values already contain commas such as:
0456,4546,05566873035,65465687
I'm trying to make the csv look like: "0456,4546","05566873035","65465687"
so that my users can open it in Excel properly and if a comma was put in, it doesn't shift data over to a new column. The current code will separate data based on commas, rather than based on the column. Is there a way to encapsulate my columns with double quotes using the code below?
Private Sub btnExport_Click(sender As System.Object, e As System.EventArgs) Handles btnExport.Click
Dim headers = (From header As DataGridViewColumn In DataGridView1.Columns.Cast(Of
[code].....
I have been struggling to export an array from VB into an excel doc. I have no idea what I'm doing wrong.
The code below is the data that I am attempting to capture from a device.
Can anyone supply me with code to be able to capture the array and save the array in an excel doc?
[Code]...
im currently importing an text file from .net into excel using the following code :
Dim oExcel As Excel.Application
Dim oWorkBook As Excel.Workbook
[code].....
Per this UserControl that can be added to a blank form, I would like to use the HorizUnits array below to map custom grid x coordinate from a mouse x position.For a given input value 13, what syntax would I use to obtain a value of 2 where 13 lies between Value 10 and 16 for which 2 (Name) would be the custom grid's displayed coordinate position?
View 1 RepliesI have an array of people stored in a custom structure array... how can i copy this array to a temp array so that the temp array has all the same values as the original custom array?
View 4 RepliesI am writing a pizza order program for class and have gotten everything put together, even got my array setup and displaying but when i go to calculate it will not calculate the values coming from the array in any of the calculations.
[highlight="vb"]Option Strict On Public Class Form1 'declare structure and module-level variables Structure PizzaSale Dim SizaString As String Dim StyleString As Stri]
A c# class's single dimension byte array contains socket level instrument sensor data as per:
public static byte[] frameData
As per this illustration, I'm trying to increase the size of an existing array from 111 to 114 to be consistent with existing code. I need topreserve the existing values and add 3 new items to the end of the existing array of booleans,
View 3 RepliesRow1
;W910 RF3500AA ;Increase volume by 40 db ;(c) summer ;(p) horse +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row2
;W910 RF350011 ;Increase backlight by 50% ;(c) winter ;(p) vistar +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row3
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
Row4 (Duplicate of Row3)
;W910 RF350022 ;Increase backlight by 100% ;(c) spring ;(p) spaceman +1000000 F5 000000 5555 44 555555 904938291 8676859 00
if label1 = RF350022
label2 = Increase
label3 = spring
label4 = 100%
only if it contains all of these words it should return the first instance (row3) then end or null the rest (row4).how can i get row 3 to show in message box now it has been found?
I feel quite silly asking this, but I couldn't find a definite answer anywhere. in vb.net, how are the array elements defined (if they are defined) for, for example:
Dim myarray(5) as int
does, at this point in time, myarray(3) for example have a defined value? If so, what is it?
I am getting some values in arrayIDs if some particular condtion match i am assinging values to array.Here i am getting problem when this condition not match i am getting values zero in all array indexes,here how to check if array contains zero values in array indexs
Dim
selects As ListView.SelectedIndexCollection
selects =[code].....
i have a requirement like i need to filter out the distinct values from an array to another array.
Dim str As String
For Each str In all
If (Not all2.contains(str)) Then
all2.Add(str)
End If
Next
i tried the above logic to get the distinct list but it is telling contains and Add are not the members of system.array?
I'm trying to import my xls files to sql server, but i saw some values become null even though data in excel values are exist.
below is my connection string :
Code:
Dim cnstr As String = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=" & txtfName.Text & ";" & _
"Extended Properties =""Excel 8.0;HDR=YES;IMEX=1"""[code].....
This error occurs while i'm importing the alphanumeric values into text, but previous values are numeric (but string datatyped).
I'm trying to export a set of values to excel. The data is being taken through a DAQ card and is displayed in two textboxes on the form. So far I can export 1 data point to A1 and B1 of the spreadsheet. here is what I have so far.
Private Sub Timer1_Tick(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Timer1.Tick
Dim acquiredData() As Double = DaqTaskComponent1.Read
[Code].....
If a use the NPV() function in Excel (2010) with a discount rate of 5% and 10 cells that each contain 505,000 the resulting NPV function call "=NPV(5%,C2:C11)" returns the value of 3,899,496.
If I use the Financial.NPV() method in the Microsoft.VisualBasic namespace (in my C# application) and pass in a discount rate of 5% (as a double) and an array of 10 doubles with a value of 505,000 each, the VB function returns the much lower value of 100,999.99 (plus a few more decimals).
I have a Excel sheet which containes time. 2 cells are being compared in a formula. Sometimes a value is missing in one of the cells, this will cause a negative date. Negative dates in Excel is shown as ####. how i can set this value to zero? Ex: Value A is compared with value B. If value b is missing, theres a negative time.
20:05:20..space..20:31:5300:26:33
20:43:43 ..space..empty cell..####