I have a windows form application that when it starts needs to see if the user has Excel installed on the computer and if not display a message informing user that part of functionality will be disabled.
Is their an easy way to perform this check?
Working in Visual Studio 2008 with VB.Net
That thing is installed by default. But is there an easy way to check whether an extension is installed or not?
I check that simplexml_load_string is available to me but how do simplexml is not listed on php.ini
I'm looking to automate this, and I would like to test the localhost to see if IIS 7 is installed. If it is not installed, then install it through code. Is there a way to do this? And if so, any pointers on how to get started figuring this out? I searched, but all that comes up are the manual way to install IIS.
View 3 RepliesI have read some of the other posts on this and seem to be a little different than my situation. Trying to print out some reports into an excel document on the clients machine - of course it works fine on my local (heard that before right). I went in and set my references Ms.Office.Core and Ms.Office.Interop.Excel to 'Copy Local' = True so the .dll are in the servers bin folder.
[Code]...
I have a project that has a need to display a Excel file in second window, but because other controls are needed, simply launching excel is not sufficient. Right now I do not know if the target machines have excel installed but I know with certainty that if they do it would be 2010, is there any method or library that allows you frame your own form around an excel window?
View 1 RepliesI am uploading an excel file to my app and want to read it. Do I need to have excel loaded to read this?I am getting an error of Object reference not set to an instance of an object.
Public Function GetExcelData(ByVal ExcelFilePath As String) As DataTable
Try
Dim OledbConnectionString As String = String.Empty
[code]....
With the following code I can list the display name of all software installed on a local machine.
'Declare the string to hold the list:
Dim Software As String = Nothing
'The registry key:
Dim SoftwareKey As String = "SOFTWAREMicrosoftWindowsCurrentVersionUninstall"
Using rk As RegistryKey = Registry.LocalMachine.OpenSubKey(SoftwareKey)
'Let's go through the registry keys and get the info we need:
For Each skName As String In rk.GetSubKeyNames()
Using sk As RegistryKey = rk.OpenSubKey(skName)
[Code] .....
What I need is to get the FileName
to be used to start the application like notepad.exe and not just the displayname
Dim p As New System.Diagnostics.Process
p.StartInfo.FileName = filename & ".exe"
instead of all listed in the registry key, "Microsoft Digital Image Library 9" doesn't even show in installed programs list. [Code]
View 2 RepliesI have a project in vb.net2008. I use tools of vb6 and excel in it. Now I want to publish my project and use it in other computer that not installed vb6, vb.net2008 and excel programs. What must I do?
View 1 RepliesI tried to read excel file using the method i found here [URL] But i get an error on ADODB.Connection saying "Type 'ADODB.Connection' is not defined" in the following code:
Code:
Private Function GetExcelConnection(ByVal Path As String, _
Optional ByVal Headers As Boolean = True) As Connection
Dim strConn As String
[Code]....
Its was used in VB6... do i need to do something special in Visual Studio 2010?
I need to export Chart(image) and grid (tabular) row data into excel file. I can not use automation because Office tools are not installed in my server. I've found a bunch of free/proprietary tools like:
NPOI
MyXLS
ExcelWriter (softartisans)
JetCell (DevTrio)
Aspose.Cells (Aspose)
But I do not know which one is better for my needs. I need to export not only grid row data but also Chart (image), thats why I am thinking about.
I'm using vb10 express.When I give copies of my exe file to friends to test will they have to install anything on there computers to get it to work? Do I need to include other files with the exe?
View 3 RepliesI am creating a project with VB2008 Express Edition. The end result will be a CD containing tech manuals in pdf format which will be accessed via various buttons on a form. I am going to include Acrobat Reader Redisributable on the CD which the user can install by pressing a button on the form if required. What I want to do is this:- When the user inserts the CD into the PC, the form will load.When the form loads, I want to search the users PC to determine if Acrobat Reader is installed.If the Acrobat Reader program is not found on the system, then display a MessageBox to inform the user to install the reader from the CD.Would this involve searching the users registry? I would need to insert in my Form1_Load sectionTarget systems would be Windows XP/ Vista with programs on the C: drive as default.
View 4 Repliesi have a audio program that will play some mp3 files from a folder. but the audio files together take up about 1 gb. it is possible to let my program download the files from the internet after it is installed on a computer. to a specific folder..?
View 3 RepliesI have a central server and I need to write a bit of vb.net which will see if I can telnet to a specified server on a specified port.Is there anyway this can be done in VB.net? I thought about sending command prompts to the remote server to execute telnet, then output the logs of netsh and read those and send the information back to the central server for review.
Its a very messy way of doing it, so I was just wondering if there was an easier way
Is there a way in VB .NET to create an Excel file without having Excel installed?
View 7 RepliesI have a WinForm program developed in VB.Net with Visual Studio 2005. The program needs Microsoft Office Runtime installed atleast on the computer to allow the application to run without any errors.
Is their a way to check the computer to see if the minimum of the Runtime or Microsoft Office is installed on the computer? If either isn't I would like to display a message to the user on the startup of the application that states to atleast go to Microsot's site (I have full link to Runtime Download) and download the runtime for free.
Or is their a way to include the runtime as a component with my install for the application so if it isn't installed on the computer already it will install when the application is installed?
Im looking into learning OLEdb to run with Excel, Where do i start? has anyone got the full default sample code? and how do i need to set up the Excel test file. Sounds daft but im looking at the system namespace for it and its just looking bafling. What not to put on an Employee evaluation: This employee has hit rock bottom and shows signs of starting to dig.
View 8 RepliesI have read about Network.Downloadfile and I think I understand it! I want to know if there is an easy way to test a files date modified before downloading it. I have a lot of files in the folder. I really want to "sync" the folder. I don't want to copy every file every time I want to only download the file if I don't have the file in the destination location or if I have an Old copy.
View 4 RepliesI am using VS .net 2003 and developing a program that calls Excel. The development computer only has Excel 2003, and the target machine only has Excel 2007. Would it be possible to install Excel 12 Object Library in the development computer without installing Excel 2007?
View 4 RepliesI have a function in my application which exports data to excel. It works fine when it is installed in a pc where office is installed. How can I run in a pc where Office is not installed? Do I need to install full Office in user computer? Are there any redistributables which makes my work done??
[Code]...
open and read and write and save to Excel and word documents in a program if the machine that is being run on does not have either of thies apps installed. Are there files that I can include in my application that it could be worked on in my application and not need word or excel?
View 3 RepliesI am looking for a way that on the form I am designing , there will be a section that displays an excel type spreadsheet that stores rows of similar information as show below.
length(mtr) width(mtr) height(mtr) cubic weight(kg) physical weight(kg)
eg. 0.15m 0.25m 0.35m 3.38kg 5kg I need the spreadsheet to allow the user to select rows and the form can have command buttons to allow then to delete selected row, etc. But I dont want to have it that the system this program eventually runs on to need to have excel actually installed on the system.
I am building a windows form application using visual basic (visual studio 2008). The idea is to query a MySQL DB and export the results to an excel document. I managed to do this using this code (I will just show the export to excel part):
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.IO
Imports System.Data
Imports MySql.Data.MySqlClient
Imports System.Configuration
Imports System.Runtime.InteropServices
[Code] .....
And it works fine on my laptop (which has office 2003 installed), but when I create the setup package and install it on the server where I am going to use it (which does not have office installed), I get this error:
"Retrieving the COM class factory for component with CLSID {00024500-0000-0000-C000-000000000046} failed due to the following error: 80040154."
And for the record, I need the excel file, not a CSV.
I need to be able to detect which version of Excel I have installed in my machine from some .NET code I'm developing. I'm currently using Application.Version for that, but it doesn't give me information about Service Packs.
View 4 RepliesI am building a windows form application using visual basic (visual studio 2008).The idea is to query a MySQL DB and export the results to an excel document.I managed to do this using this code (I will just show the export to excel part):
Imports Excel = Microsoft.Office.Interop.Excel
Imports System.IO
Imports System.Data
[code].....
I have designed and published my small created app with WINDOWS FORMS using VB 2010 EXP on Windows 7. I can only install the app on the machine that I used to develop the app.I want to install the app on another computer but I cannot. I usually have error reports.
Example:Unable to install or run this application. This application requires Microsoft Common Language Runtime 4.0.3 to be installed on your computer.
what can I do to be able to install the app on a different computer which does not have .Net and does not have visual basic 2010 installed.
I have a software that writes data to Excel sheet. I'm using Microsoft Excel 11.0 Object Library for this. Everything is working fine so far, but apparently the drivers require Microsoft Office installed onto the computer.
Is there a way to write data to Excel format without having Microsoft Office installed?
I'm facing a problem reading .csv file into datatable. The machine on which i install my window service ( which reads the csv ) is Windows Server 2008 R2.The error i get is : The 'Microsoft.Jet.Oledb.4.0' provider is not registered on the local machine
Below is the code i use to fill the dataset from .csv file :
string connstr = "Provider=Microsoft.Jet.Oledb.4.0;Data Source=" + System.IO.Path.GetDirectoryName(arrFilesName[iCount].ToString()) + ";Extended Properties = 'text;HDR=YES;FMT=Delimited'";
OleDbConnection conn = new OleDbConnection(connstr);
[code]....
I also looked at the other option i.e. Micorosft.Office.Interop.Excel but that also needs Excel installed.So, I would like to know that, is there a way to read a .csv file without having Microsoft Excel install on the machine.
I have a windows form and I am attempting to create an excel file from a datatable that has already been created and i'm hitting a snag - the error is: The ':' character, hexadecimal value 0x3A, cannot be included in a name."I have a button to start the Export process, here's the
'here's all my imports for the form
Imports DocumentFormat.OpenXml.Packaging
Imports System.Text
[code]....
