I am loading data from an Excel File to a dataset and performing some computation. The problem arises after the application is closed, the Excel file is locked for some reason and can only be read.
View 2 Replies
I am using the Microsoft.Office.Interop.Excel library in VB.Net on an excel sheet that is protected. All of the protected settings are working fine except that I cannot set Select Locked Cells which shows when you are using the Excel protect sheet interface but I cannot see how to set this to false using the library. I have tried all of the different values in the protect method but none of them toggle the value.Excel protected sheet menu Below is the code snippet I am using to get my workSheet, populate some values, and then protect the sheet. GetWorkSheet is an internal method which will return a WorkSheet object, and invoiceData is a datatable which has the data which is being added to the spreadsheet.
Dim newSheet As Worksheet = getWorkSheet(newSheetName)
' Make the current Work Sheet active so that it will be accepting the data.
newSheet.Activate()
newSheet.Unprotect(sheetPassword)
[code]...
I have written an application that monitors a log file. The Log file is locked by the writing application so I read it asynchronously:
Dim LicenseLog As New System.IO.FileStream("\serverLOGlicense.log", IO.FileMode.Open, IO.FileAccess.Read, IO.FileShare.ReadWrite)
I have been using VB2005 for many years on 2 PCs. Over the last month I have been getting an error when I try to run the project from the IDE:
Error 1 Unable to copy file "objx86DebugBackup.exe" to "binx86DebugBackup.exe". The process cannot access the file 'binx86DebugBackup.exe' because it is being used by another process.
C:WindowsMicrosoft.NETFrameworkv2.0.50727Microsoft.Common.targets 2324 9 Backup
My questions:
1. What has changed?
2. One thread I found suggested that it is a bug, but if true is this something that has been introduced recently (I'm not aware up updating VB2005 unless it happened as part of the general updates).
3. How do I get it back to where it was?
The file is actually locked by my own process, no other application can be using it. I've even tried it with a few line noddy program. I always have to come right out of the IDE, wait a couple of minutes and then go back in - a total productivity killer.
is there a way to unlock file that is locked by IIS without doing a IIS reset? If yes, how can I do that in VB
View 1 RepliesI am wondering how I can replace a file locked by another application. I am using VB.NET from 2008.
View 4 RepliesI have developed a program that allows drag and drop pictures using the followng [code] this will display the image in the pictruebox and saves the location of the image to a database. at this time i can rename the image in windows using the file.rename() function.now if i exit and come back into the section of the program with the image.i query the database for the image location and use the same type of code aka ploc [code]Now when i try to do a rename of the file i get an error that says access denied. I have even tried changing images, but as long as i am in the program i get access denied.I also can not change or delete these file from windows as long as my application is runningfile.rename() Is there a way to force my program to stop using this picture so i cand rename or delte it?
View 2 RepliesQuote:
System.Exception: Transaction (Process ID xx) was deadlocked on lock resources with another process and has been chosen as the deadlock victim.
I suspect this
Dim webc As New WebClient
webc.DownloadFile(remotexml, targetxml)
webc.Dispose()
Then i am using the targetxml right after that:
Dim xmldoc As New XmlDocument
xmldoc.Load(targetxml)
etc.
It seems that xml file is locked by the first process (WebClient).
In my application, i am downloading file from DMS system to my server. Once the file gets downloaded, on some environment, the iis keeps lock of the file and when the application tries to redownload the file and put the file on same location, an error is generated that file is being used by another process. Following is the code :
[Code]...
My program writes to a .txt file (and this is the ONLY program that writes to it) in a thread (with lowest priority), but every now and then it gets an error "The process cannot access the file because another process has locked a portion of the file" when it executes this code: swLog.WriteLine(sPacket).Other program reads from the file, not write to it, why do I get this error, and how can I get around it, or what shall I do when I get this error since I can't write to the file ?
Class
clsFile
Private swLogOrig As StreamWriter
[code].....
I followed the link [URL] And I want to put code
IF EXIST $(TargetPath).LOCKED (del $(TargetPath).LOCKED) ELSE (IF EXIST $(TargetPath) (move $(TargetPath) $(TargetPath).LOCKED))
For the case
Unable to copy file "objDebugxyz.dll" to "binDebugxyz.dll".How to write it correctly?
I am using asp.net oledb to export information to excel file. I encounter problems when the information to export becomes too big, in this case the code I have given below, the excel file generated becomes an empty spreadsheet.If I changed the loop to 1123 for insertion of the rows. The generated excel file is fine, 1125 rows, and 4 columns shown.A test program in windows form is also working fine regardless of how many rows.[code]I couldn't find a solution to my problem as well. What I did eventually was to run the process using another separate windows service. The code works perfectly fine running from a windows form or service program, but not asp.net, not sure why.
View 1 RepliesI have this issue that occurs with me and driving me crazy i have a report that contains thousands of records and i need to export it to excel , but the excel normal extension .xls
is showing missing records at the end of the file , so i save my file as an .xlsx extension it saves correctly but when i open the file it generates an error
"Excel cannot open the file '<var>filename</var>.xlsx' because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file."but when i test the file i drag it and open it in an empty notepad all the records shows up correctly
I'm trying to upgrade a VB6 app to VB 2008. I have read the article in the tutors corner about automating Excel from VB but I cannot get it to work. Heres what I have done:
1) set a reference to the Microsoft Excel 12.0 Object Library
2) Added "Imports Excel = Microsoft.Office.Interop.Excel" to the top of the module
3) in a routine I have added: Dim X As New Excel.Application Here's where I get an error: Error 75 'Application' is ambiguous in the namespace 'Microsoft.Office.Interop.Excel'.
I'm working with vb.net 2008. My application generates 1 excel file (with login details etc). The application will store user results for various sections into csv files. I'm trying to combine the csv files into the excel file. I'm trying to get this to work with one csv file initially ...but I am ending up with a blank Excel file. This is what I've tried so far:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim oExcel As Object
[code].....
I'm working with vb.net 2008. My application generates 1 excel file (with login details etc). The application will store user results for various sections into csv files. I'm trying to combine the csv files into the excel file. I'm trying to get this to work with one csv file initially ...but I am ending up with a blank Excel file. This is what I've tried so far:
Private Sub Button2_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button2.Click
Dim oExcel As Object
[code].....
I use the following code snippet
Dim exlapp As New Microsoft.Office.Interop.Excel.Application
Dim xlWorkBook_new As Microsoft.Office.Interop.Excel.Workbook
Dim strOriginal As String
strOriginal = Server.MapPath(Request.ApplicationPath & "/Attachments/") & "abc.xls"
xlWorkBook_new = exlapp.Workbooks.Open(strOriginal)
The code hangs in the last line. It works fine in the development environment. i deployed in windows server 2000 ,where I get this issue. the browser goes half way and throws the below exception after some time
[Code]...
I have set the identity impersonate to true in web config. This should be mostly an access rights issue.I have even provided access rights for the "everyone " user in the excel file and as well for the interop component. Please post ur valuable comments.
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 have an application the contains several excel files bundled with it. I'm not opening the files and processing them within my application. These files contain a data-connection to reload all of the pivot-tables within each excel file. I have a 'link' on my form, that when clicked, it determines which file to open and calls a sub using filename and executing Process.Start(filename) for any excel file I want to open. I have no problems opening any one of the files and then exiting excel.
The problem is when I 'close' a file, but don't exit Excel; then try to open another file(clicking link on form)... it creates a new instance of Excel.
I know from experimenting that the fileopendialog form will 'reuse' an existing Excel instance, IF it does not already have a file open.
How can I do the same thing without using the fileopendialog?
I don't want the end-user to have access to the folders where these files live. That's why I have multiple 'links' on my form, one for each xls that already exists. I just want them to be able to click on a link and the xls file opens AND if they choose to merely 'close' a file and not exit... Don't create a new instance of Excel, but re-use the existing one.
I took oledbconnection with excel file, after disposing this connection i m still unable to open that excel manually,It shows some access error.
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]....
I need to create an excel file from the database records. I fetched and put the data in an excel file and tried to save that file as follows.
[Code]...
I 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.
Is there any way to insert an existing macro into a existing excel file without using the excel library ? I need this to set the excel to print whole work book .I cannot use excel library because it will be done online in the server where installation of excel is not possible. I can however use the c#.net coding . I am using NPOI to generate the excel.
the macro is given below
Private Sub Workbook_BeforePrint(Cancel As Boolean)
If printed = False Then
Cancel = True
[Code]....
How to print excel file form vb .net without opening excel?
View 9 Repliesi'm trying to save an excel file after I open my excel application. This is what I have so far:
'Opens the report
xlPeakDemand.Visible = True
xlPeakDemandWorkbook.SaveAs("C:Documents and
[Code].....
When saving as an xls it works fine but when saving as a htm its a disaster Just a bunch or symbols and stuff. BUT if I go into my xls document and Save As webpage from there, it works fine!
how can I create an excel file in excel 2003, open it, add workbook, write into it, save it and close it by visual basic 2008.
View 2 RepliesIs there a way in VB .NET to create an Excel file without having Excel installed?
View 7 RepliesIm 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 Replies
