i have a sql sintax and when i press to button ( mouse click ) i want to export the results to excel.
Private Sub LIST() Handles Button2.MouseClick
Dim sql As String = "select ST03001, ST03017, sum(ST03020), SUM (ST03020*(ST03021*100/(100+ST03022))) from ST030100 where ST03001 = SL01001 and ST03001 = '411.1001'
[code].....
I'm exporting an ASP.NET gridview to Excel using the following function. The formatting is working really well, except I need to freeze the header row in Excel on the export. I'm really trying to avoid using a 3rd party Excel plugin for this, but unless there's some archaic excel markup in my AddExcelStyling function.[code]
View 2 RepliesData exported to Excel in Two sheet for successful code without Error?
Dim ComDset As New
DataSet
Dim ComDset1 As New
DataSet
[code].....
Following code below. I will explane what it does and it needs to do.
Its a query that fills a gridview. Everything thats in the gridview needs to be exported to a excelsheet.
I've got it working that when i fill it, it will fil the sheet with only the same line. Im not a prof VS developer.
Code:
Now the problem is the following.
Code:
It need to pick up each line but it only picks up the first line and duplicate's it.
I left the qeury line out for privacy reasons.
I decided to to convert my excel macro in a exe file using visual studio 2010. In excel macro method find is present like this:
[Code]...
I'm trying to write some documentation for a webservice that has been provided by one of our vendors for an application we're integrating. A bunch of the interface is custom objects defined in the web service itself. The vendor has put up significant resistance to providing any documentation for this application and so I've taken it upon myself to do their job for them [against my better judgement]. The documentation they have provided frankly is embarrassing and I'm trying to make as short work of this as I possibly can to put some good quality docs together.
I know that as I don't have access to their source, I can't just run it through nDoc/Sandcastle to spit out an API doc, but I was wondering if (as a half way house) there was an easy way to export the intellisense to a text file without me having to write a utility to specifically iterate through each of the object types defined and reflect the members out to text? If I could do this, it would at least make sure that I have a good quality document structure where I can just fill in the blanks. Having to skip back and forth to Visual Studio to check the intellisense for every class member is a very laborious way of doing this.
Is it possible to restrict renaming a exported file in vb.net?
View 1 RepliesIs it possible to restrict renaming a exported file in vb.net?
View 2 RepliesI created this code
[Code]...
I'm writing a program which has to perform several operations on data exported from a CAD software.The amount of data to be processed is huge and even by simplifying the program at maximum it will still take about 10-15 minutes for average models.
The operations are performed on an array from the first to the last element. Let's say for a list of 10 elements (as example) that I start from element 1 and I finish when element 10 has been computed. I thus thought that since I'm working on a 8 processor machine would be convenient to make use of multi-threading. My idea is, for the case of 10 elements, to make thread1 working from 1 to 5 and make thread2 working from 6 to 10.I already wrote a working code for a 2 thread process which is working, but I want to extend the number of threads and eventually decide in function of the threads available. The basic structure is given below:
[Code]...
GetProcAddress Function Retrieves the address of an exported function or variable from the specified dynamic-link library (DLL).Lets say I have something like this:
Dim moduleHandle As Integer = LoadLibrary("C:myDLL.dll")
Dim methodName As String = ""
GetProcAddress(moduleHandle, methodName)
DLL should be win32 standard dll or .net dll.
How can I run the exported function if I have the address of it through GetProcAddress().If someone could supply some code it would be great.
[Code]...
I am trying to use a spreadsheet with VBA macros that I wrote in Excel 2007 in Excel 2010.When the macros run in 2010, I get the error message "Can't find project or library" on functions like UCase and Date.I've set the macro settings to "Enable all macros" and selected "Trust access to the VBA project object model."What do I need to do to get these macros to run in 2010?
View 2 RepliesI need to import a .csv file so that it formats it all nice-nice so I can easily get the information from a column or row, then I need to grab certain rows, then reorganize it and save it into a different Excel spreadsheet for the program to then use. The original .csv does not contain the information in a way that we need it to be.
What I found so far: I saw this code snippet online
'-----------------------------------------------------------------------
' CONVERT CSV FILE TO XLS AND PROCESS XLS ROWS AND COLUMNS
' Opens Excel, imports .cvs file into xls format
' Iterates xRows and xCols from xls format
[Code].....
I am creating an Excel Add-In using Visual Studio 2010. My intention was to add a context menu to a cell and perform some action on the selected cell or cells. Here is the code I have got as of now
[Code]...
Basics Details:
VS 2010
Making an Addin for Excel 2010
Win 7
Problem:I am not getting the cursor (4 arrowheads) for moving the form.I am using the Panel1_MouseHover to display the cursor. Right now if I choose any other cursor then it is working but the same cursor also displays when I hover the mouse over any other control. I want the cursor to show only in the areas of the Panel where there are no controls.How do I show Tooltips for the images? The play,stop,next, previous,playlist,Hideme(with the smiley),volume are all images and not buttons?
i have my database in VB2010 and i want to push 2 tables from that database to MS Excel 2010. I came across [URL] but even after following the steps i'm getting an error: Type 'Excel.Application' is not defined.
Imports Microsoft.Office.Core
Imports Microsoft.Office.Interop.Excel
Imports System.Data
[Code].....
with VB.net 2010, i would like to export a text file (with ; separator and variable length lines) to excel 2010
View 3 RepliesIn my application, users can establish connections to one or more databases in order to pull in data, thus a read-only connection is sufficient. I use the following connection string syntax when connecting to an Excel 2010 database:
[Code]...
I'm trying to sort a range in excel 2007, copy it and export it to another workbook. I can get as far as selecting the range but, I get lost after that...I have searched a lot of threads but, just can't seem to find one that give me an exact answer.
View 4 RepliesVB.Net 2010 program .exe on PC with Excel 2007 gives error when cannot find Excel version 14, which is Excel 2010 I have developed a program in VB.Net 2010 which reads from an Excel spreadsheet. It works fine in the IDE on my computer. I built an .msi and executed it on my computer. I get "Error: 53 - Could not load file or assembly 'Microsoft.Office.Interop.Excel, Version=14.0.0.0, Culture=neutral,PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannot find the file specified."
The only version of Excel on my computer is 2007, which is version 12.0.6557.5000. The version the error says it needs, version 14, is actually the version of Excel 2010.I have put in MsgBox statements to find where the error occurs.
[Code]...
I need to access the current instance of MS Excel. To do that, I wrote the following code:
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.Diagnostics
Private _ExcelApp As Excel.Application
[Code].....
The code runs nice, but it has a problem: After the user close the Excel application (click button X - note: no other instance of Excel exists), if you open the Windows's task manager, its possible to see the process Excel.exe.
If I open and close the Excel application, there is no process Excel.exe, but if I run my code with the Excel application openned, after the user close the Excel application, the process Excel.exe isn't finished.
I want to make a program combined with excel. can some1 explain to me the basic commands or refer me
View 9 RepliesI'm trying to convert some of my code from EXCEL VBA code to VB.net. However I've been encountering some errors and can't seem to get to display the output correctly.Below is my sample text data:
Date Time SYSID LPARBSY MVSBSY INRDYMX INRDYAVG INRDYQ(%) AVG_PROCS
---------- -------- ----- ------- ------ ------- -------- --------- ---------
03/18/2012 09.00.00 CP1A 11.97 12.03 3 1.1 99.0 2.0
03/18/2012 09.00.00 CP1B 8.86 9.12 3 1.1 99.3 2.0
[code].....
I want to create an application which generates random questions. So, initially, I have a form where I choose some options. They're all "Yes" or "No". According to my answers, I want my application to generate 10 random questions which are written in a Excel file.
It's like:
Option 1: Yes (Generate 3 questions / Excel file: Questions 1 to 6)
Option 2: No (Generate 2 questions / Excel file: Questions 7 to 14)
It is very well written in books to use the classes, created in VS2010, in Excel. I want to create a control (a class with user interface) in VS2010 and use it in Excel 2007 or Excel 2010. Please suggest me any literature as a starting point.
View 2 RepliesI�m using a few workbooks in excel to calculate data and then I import them to access and finally I use it in visual basic front end.
Now the workbooks can get quite heavy and it takes some time for the computer to open and save and so on, so I�ve put a progress bar on my form to show the user that something is happening.
However I would like to use excels own progressbar, so that when the workbook is being saved, my app actually shows the progress of that particular save. Can I do that? The instance of excel that handles the workbooks is hidden.
I have had this headache for a few days now. Thought I had sorted it but haven't.I have copied worksheets from an excel workbook into a dataset, with each a datatable for each worksheet.
I then use a DataGridView to Display and edit the datatable.DataGridview.DataSource = MydataSet.DataTable(0) sort thing.But for some reason I just cant figure out how to write the datatable back to the excel worksheet.I have this but Im probably barking up the wrong tree.
[Code]...
Okay I am trying to make a class library that takes information from an excel file and puts it into an access database, but I keep getting this dumb object reference error that always screws me over. Here is my
vb
Dim xlApp As Excel.Application Dim xlWbs As Excel.Workbooks Dim xlBook As Excel.Workbook Dim xlSheet As Excel.Worksheet Dim xlRange As Excel.Range Dim strExcelPath As New String("C:UsersAjDesktopTax_Research_Template_2010_-_Excel.xls") Dim accConn As String = "C:UsersAjDesktopTaxCert_be.accdb" Dim xlDT As New DataTable Dim xlDR As DataRow = xlDT.NewRow Public Sub XLMain()
[Code]...
I recently upgraded to Excel 2010 from 2007. My ActiveX files will not work. I used to use:
Dim xlApp As Microsoft.Office.Interop.Excel.Application
Dim xlBook As Microsoft.Office.Interop.Excel.Workbook
Dim xlSheet As Microsoft.Office.Interop.Excel.Worksheet
That does not work and most of the choices do not contain: Application, Workbook and Worksheet.
Im doing a project with .Net 4.0, Visual Studio 2010 and Visual Basic .Net.I needed to add a Chart (the new one included by default in .Net 4.0) that represents temperatures evolving with time, so I added the drawing points in the elapsed event of the timer every second.The graph is doing somewhat ok, but I need another functionality, and this is, every time I stop the timer, save the graph in an excel (.XLS or .XLSX) file. As by default the chart provides with a collection of the type "System.Windows.Forms.DataVisualization.Charting.DataPointCollection", I would like to know if there is a way to create an xml and put the info of those collections in the excel file.I have looked around but I didn't find any similar example, last thing im thinking about is to use an iterative way to manually write in the excel file, but maybe its too much time consuming as the iteration will be of several thousands seconds.
View 1 Replies