I can show an excel workbook using a WebBrowser component but that only works if excel is installed on the target computer.Any other ways to display an excel sheet ? Just a viewer. No need to edit, scroll or tab between sheets.There's a lots of OCX components out there that do this but anyone know of a .net component ?Or any way to achieve it without needing Excel to be installed.
View 3 RepliesI was wondering if anyone already done this. And off course How?I'm working on a project to get several departments incoorperating the same budgetting systematic. Yeah hell is pretty near so far.
What I need is a way to create a preview in excell for the template they are defining in an application. As the end user will enter the data in an Excel sheet... YES this IS mandatory in this phase.
So I want the department manager to drag items into a treeview defining a template and generate a excel workbook and show a sheet with the result of his definitions.
Question? how can I show an Excel sheet within a vb.net application?
how to show ,edit, MS excel sheet in Visual Basic 2005?
View 3 RepliesI've got a problem since I have one form with some text boxes getting data from an Excel sheet and other text boxes getting data from other sheets from the same Excel file. And when I choose a product no I would like that all the text boxes retrieve data referring to the same product no.
View 4 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 want to connect a form with an excel datasheet.
View 15 RepliesI am working on an excel add-in. Currently I have a couple of forms that grabs info from excel, processes and pastes data back into excel.My problem occurs after my form closes (this leaves excel and one other MDI form still open). I need my excel sheet to come to the front for users to view and edit. My MDI form just stays on top even though I just edited the excel doc. I have tried everything I can think of using:
.visible
.activesheet etc.
Here is my latest:
[code]....
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'm trying to upgrade an Excel VBA workbook to a VSTO Excel Add-in in VB.NET using VS 2010. In the original (i.e.- VBA) version I have a modeless UserForm (called frmMain) that floats on top and is visible at all times while the user is still within the Excel application, but is not visible if the user moves to another window outside of Excel.
For example, within Excel the user can click on any worksheet tab, select any cell, etc. and the UserForm is still visible. This is exactly how I'd like it. The problem is, that in the new VSTO add-in, I can not get the Windows form to mimic this same behavior. I use frmMain.Show() to show the form as a modeless form, but the moment the user clicks an Excel worksheet (i.e.- activates a worksheet) the form becomes hidden behind the worksheet.
[Code]....
i 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 am busy with a Windows Forms application.The purpose of the application is to convert Excel documents to HTML format so that they can be published to a website.I have most of the code finished and the application is looking really good.I have although encountered a problem. On the Form I have created an Export, File and Edit button.With the edit button I would like the user to be able to select whether they would like to save the 1st,2nd,3rd sheet and so forth.
I would like to create a window/Form within the edit button that would say something like "select excel sheet" along with a save button where the required sheet number could be saved or selected as a standard save procedure everytime.I know that I need to do this with the settings.settings control. I have tried numerous ideas up until now but it continues to baffle me.
I have a Datarow array but now I need to show each row in a windows form so that the user can look through and find a suitable entry. Ideally the form would be like the DataView display with a BindingNavigator to go through the entries one by one. I have searched everywhere for some indication of how to do it but to no avail. [Code]
View 8 Repliesknow a vb.net image-control, that supports the Canon RAW-file format? (or some other way to show a cr2-file on a windows form).
View 2 Repliesi'm what you call a "noob" in visual basic, and i came up with an idea to make a program the i can monitor my server in a windows form application instead of the cmd. This picture will show what i mean[URL]...
View 5 RepliesMy mate & Myself are currently building a IRC Client, a problem we have come across is when opening a chatroom the form Freezes for example. We are currently using arrays so we can open multiple chat rooms and at this current time to open a chat room we use
[Code]...
I am working on a Windows service application and have followed few tutorials online and am able to install/uninstall start/stop service fine. I need to show a windows form to the user when service starts and am not sure how to show a form at OnStart() event.The form1.vb is added to the main project. ServiceProcessInstaller1 account is set to localSystem and nothing else is changed. [code]
View 10 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 RepliesCan anyone tell me how to add a Excel like form to a Windows form so I can add and remove rows/colloms and do simple calculation. It would be nice to have tabs along the top.
View 4 RepliesIn my vb.net windows form application i want make a button that when a user cliked the button, the Desktop should be showed, (Show Desktop Button) .Consider a form name as form1 and it got a button like "Show desktop", when user clicked, all the application should be minimized and it should show desktop, is there any Code for VB.NET Windows Form application.
View 2 Repliesi have a combobox that has 3 cases. case "0" opens a dialog saying, "Not a valid choice"but case "1" and case"2" open up there own separate forms. (FormMain and Form3)How do i make it so if Form3 is open FormMain Can not be opened, And a messagebox appear saying so. I do not just want the ".hide" function. I already have that set.I have tried a few differant things, none of which worked. And i tried them in the formload and in the combobox selected index
View 3 RepliesI am using VB 2008 to do some excel automation and I am stuck.I am trying to make the cell alignment to be left-top. When I programmatically insert a new worksheet, the alignment defaults to "left-bottom".
View 3 Repliesi have installed SQL server Express Edition 2005 by using my application i am saving data in tables which is created in SQL Server so that i have to copy in that data in to excel file
View 1 Replies[Code]...
comapre Two excel sheet using C#?
does anyone know how to transfer all the data's of datagrid to excel sheet? data's in my datagrid is not all come from my database/recordset... i have two columns of data's coming from textbox.
View 1 RepliesI have data exported from DataGridview to Excel Sheet but I have problem viewing the excel sheet until I log out of the Application completely. I have these code to release the link. What am I doing wrong?
'Save the workbook and quit Excel.
oBook.SaveAs(sSampleFolder & WrkSht)
oSheet = Nothing
[Code].....