I need to populate a Combo Box with sheet names in an Excel File. I Have an openfiledialog that i search for the excel file and put the dirPath to a textbox, now i need to populate the ComboBox with the sheets in that file, the idea is so when i select sheet3 in the ComboBox, i can pass that sheet name to the string for processing.
View 4 Replies
I am trying to get excel sheet name here is my code but it throws an exception "Index was out of range. Must be non-negative and less than the size of the collection. Parameter name: index"
[Code]...
I have a datagrid which i manually entered value into. is there a way to get the value of the datagrid to a datatable or dataset
View 3 RepliesI want the files names in a specific folder to show in a combox box. How can I accomplish this?
View 1 RepliesHow do I find out the hidden excel sheet name using ADO(OLEDB) in C#? In My Excel workbook there are a lot of sheets. Only one Excel sheet is in hidden mode. I need to find out the names of hidden sheets. My code finds both hidden and visible sheets.This is my code to find excel sheet names for all sheets. Is it possible/can any one tell me how to find out hidden excel sheet names without using Interop services in C#?
[code]...
How to Display Excel Sheet names in ListView.
I however did for Access tables but Excel Sheet names don't know.
I have an excel sheet with image names in column A. I have a directory (with subfolders) on my network with all the images in there plus some.I need to copy only specific files from one location to another.
View 1 RepliesI am looking for a way to open and populate a new sheet while population the sheet from a file.xml. Any ideas?
View 2 RepliesI need to populate a combobox using the selected value in another combo. The coding that i use doesn't produce the required output. i have an excel sheet with columns called "BaseStation" & "SectorID". Combobox2 must display the related sector id with respect to the selected BaseStation[code]...
View 1 RepliesI'm creating an application that will export several datatables into a single Excelspreadsheet, but on different sheet names. How can I do that?
View 2 Repliesi Have this code which populates a number of combo boxes from an excel document, the problem is that it only populates the 1st three lines, does anyone know why this is??
[Code]...
Novice VB user, trying to create a pop up msgbox upon opening a file, whereby the user selects from a list (of available options), the choice then gets entered directly into a cell reference. I have seen this before and know that it's primitive programming but i'm still a learner.
View 1 Repliesim looking for the method how can i copy from original sheet to my new sheet.
View 3 Replies[code] objExcelAppDataSheet is the excel application's object and strTemplatePath is the path of the excel file.This excel file is like a template that i am using in my application. In this file some cells are merged. After copying to the new sheet the formatting of the sheet does not remain same. Columns sizes are changing. Why this problems occurs? Is this MS office versions issue??
View 2 RepliesI am getting an error when i try to populate some combo boxes with a value, the combo box has values in and the right amount the code is getting the right number.
the error msg is "Object reference not set to an instance of an object."
I have to provide an Excel file as an output. I have to color some of lines and make them bold.The input is based on a dynamic list (in memory) and it also could be based on CSV file that I'm already provide today (based on the same dynamic list).I'm wondering what would be the most efficient way (in terms of performance) in order to provide the colored Excel output?Should I export directly from dynamic list into Excel - or - Should I export from CSV into Excel ?
View 7 RepliesI am trying to create double and number format cells in excel using NPOI library. I used code like Dim cell As HSSFCell = row.CreateCell(j) cell.SetCellValue(Double.Parse(dr(col).ToString)) In excel numbers are aligning right but when I check format it is showing in "General" then I changed my code to like below
[Code]...
How to Eliminate duplicates in excel using macros and place it in another excel sheet The duplicate record must also be transferred.
View 2 RepliesSo I've got this Excel sheet of employees which have all the information about them. I'm trying to import this info into AD, but in order to do that I need to get the username for these users as well. And I would like vba code or vb.net code that basically takes the value of every row in column D and looks for it in AD and returns the username and adds it to column A. Would something like this be possible?
View 1 Repliesi need to generate an excel sheet from an excel template which contains drop down lists. I need to use the template and populate the with data from datbase and select the appropriate value from the drop down lists and generate the new excel sheet.
View 2 RepliesI want to print a fully decorated form having radio buttons,combo box,checkbox and so many other controls with vb 2008 in a A4 sheet, I dont want to use print form utility given in power pack since the print resolution are very low.
View 3 RepliesI want to populate my combobox with the list of banknames available in my database.. I tried doing so but I am getting a blank list. i.e.. shows no value in combobox!
Here is what I tried...
Private Sub ComboBox4_SelectedIndexChanged(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles ComboBox4.SelectedIndexChanged
Try
'MsgBox("Open")
cn = New OleDbConnection("Provider=microsoft.jet.oledb.4.0;Data Source=E:\Project-Hemtech\HemDatabase1.mdb;")
[Code] .....
I use the following code to populate a ComboBox with printer names.
Dim ps As PrinterSettings.StringCollection = PrinterSettings.InstalledPrinters
For i As Integer = 0 To ps.Count - 1
Me.CurrentPrinter.Items.Add(ps.Item(i))
Next
When the uses selects a printer from the ComboBox I then need to set a PrintDialog.PrintQueue to the PrintQueue that corresponds to the select name (which is a string). Here's the code I tried that's not working.
Dim dlg As New PrintDialog()
dlg.PrintQueue = GetPrintQueueFromCombo()
dlg.PrintVisual(canvas, "AlignPrinterSampleForm")
[Code].....
basically, i'm creating a program that is saving text files based on user input.
another screen is then needing to transfer the saved information into textboxes.
to do this i want the saved .txt files' titles to shows in a listbox, and when each selection is made, the textboxes are populated with the information in the .txt files.
I have been trying for days to populate a combobox with user names from our LDAP. I can not seem to get this to work however I am really new to LDAP also. Here is my code...
[Code]...
I have tested the code for the DataSet and DataAdaptor and both work fine, and as test was able to place the MaxRows variable into one of the text boxes on my form so I know thats all ok. But I am now trying to use the function below to copy the 1st cell of each row into a combo box to populate the options and comes up with a null exception error but cant get my head around it.
[Code]...
I'm trying to populate a combo box with some data from a xml document, but so far all i'm getting is this error message in the combo box[code]...
View 2 RepliesUsing vb.net 2008 to create an Excel ss. I am trying to add a new sheet and it does but it puts it out of order. It puts it as the first sheet. I need it as the last one ( furthest to the right).
Code:
With xlWorkBook
.Sheets("Sheet1").Select()
.Sheets("Sheet1").Name = "config"
[Code]....
I have created a connection to an excel file. This is the code i created to select the data in the excel. But i want to make the [sheet1$] to be dynamic, which means it will get the sheet name depending on what is in the excel workbook. This workbook has only one sheet. This is to make sure that there will be no error when the sheet names are different. [code]
View 10 RepliesI am new to Visual Basic and I'm trying to make a simple combo box that automatically populates from dataset. The table is from BaseMaterial with the column Material.
View 5 Replies
