We're exporting a set of data using .net interop to Excel and our template file contains some images. Depending on the amount of columns we're exporting we want to position the image X pixels left of the last column depending on the image size/width. Using the record a macro function moving the Image around is a 'no op'. Setting the Shape.Left position also won't work.
[Code]...
I want to encapsulate the use of Excel Interop to make it easier to use somehow in a reuseable library.So far, I have written some tests that work good altogether, except that between each test, I force Excel to quite so that it does have handle on the test file no more in order to be able to delete.Once I quit the application instance between after each of my tests, Excel seems to be no longer responding, causing Windows to display "Excel has stopped working and is looking for a solution"
message. This message lasts a few seconds, meanwhile Excel is closing, causing the hang on the file to occur and my tests to throw an exception like "Cannot access file because it is being used by another process..."
[Code]...
I have been doing a lot of reading on this topic and most folks seem to agree that having Excel is required to use the COM Interop libraries. However they are never specific as to where that should be installed. Does it need to be installed on the machine I am developing on or does it need to be on every machine that I deploy to?
Edit: I should mention that this is desktop development/deployment targeted for all Windows machines.
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]...
Currently in our VB.Net windows application, C libraries are present under the 'bin' directory but we want to store it under application root directory where other forms and classes are present...How can we do this in Vb.Net 2008?
View 1 RepliesI'm using Microsoft.Office.Interop.Excel in VB.Net in order to export an .xls file as a .pdf file. This was the only method I could find without relying on third party software to be installed on the running machine or using an expensive add-on to Visual Studio. This method requires opening excel and saving a file through the code.
My problem is that I only have a trial version of Microsoft office as I never actually use it. Well the limitation of times I can open it is up as I have run the program enough times for debugging purposes and now I can't continue development on this application. Is there a development kit for visual studio that provides the API I need for this functionality without actually having Office installed? I don't need Microsoft Office so I don't want to have to buy a full version just to develop and test an application.
I've looked at some options like this, but there is very specific formatting that needs to remain intact in the .xls for the conversion to .pdf that doesn't seem to work if I use an intermediary format. I've also read a little bit about the openOffice API, but is that compatible with .Net? If so, can someone point me to a tutorial that explains how to use the API with .Net? Specifically VB if possible, but I can work with C# code.
[Code]....
How could I move my VB.NET application to a folder using VB.NET in the same file? Essentially, I want to be able to move my VB.NET application to the Start folder when it is executed (within the same application). Also, I want to be able to move it to the same folder on any computer, for there is no set path to the Start folder on different computers. Or I would like to just create a shortcut for my application in the start folder?
View 2 Replieshow to move a single file to a new location. Can you move the contents of an entire folder to a new location (Lets say... inside another folder)?
Here is my code for moving a file to a new location. As you might see, this is how it works. You first select a file. Then you type in the driver (C, D, E) where your 'TEST' folder is located. Then you click another button and bam! File is loaded into the TEST folder.
Public Class Form1
Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
[Code].....
I was moving files to a new folder when I realized some of the files were in the same folder and thought "Wouldn't it be grand to be able to just move the contents of this folder into the new without doing it one file at a time?"
I'm making a small program in which i want to move labels from one position to another , I used the following statementLabel1.Location.Y = 10 ' Error - Expression is a value and cannot be the target of an assignment
View 3 RepliesI've just started using user settings. This works ok however I'm having problems with the location of user.config.
When I run the project in Studio, user.config seems to be stored in a different place than when I build the project.
In fact every time I build it the location seems to change - users therefore lose their settings every time the project is built, which seems pretty useless.
The GUID & Assembly names etc do not change.
can I use Excel APi (Interop.Excel) without installing MS Excel.
View 2 RepliesMy application is a service application, and it needs to load a set of configuration that the user can change. I was using the System.Configuration classes to set up the app.config file, and then I was going to give the user the option of editing this file to change configuration.
Can I move this file to a custom directory, something like C:settingsapp.config? Or is it forced to reside in the app directory?
I am using splitContainer1 to split two parts of the panel. I can move the splitterbar from the left to the right. I want to know how i can block the splitterbar from being moving when reaction to the location point 202?
View 3 RepliesAnyone have code to set margins(top,left,right,bottom) using excel interop and vb.net. I think it must be part of the worksheet object but maybe the workbook object. Having a tough time finding an example.
View 2 RepliesI 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 am using Interop to read and write to excel but I'm having some problems writing to excel... When I enter the information I need to be written on the excel in an inputbox, this pops up "COM object that has been separated from its underlying RCW cannot be used."Heres the Code:
Code:
Private Sub editmodelbtn_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles editmodelbtn.Click
[code].....
I'm kinda new to using VB.NET and certainly with the Excel Interop.I have the impression that I'm doing something wrong in these simple procedures. I keep getting errors on them:
[Code]...
The first procedure fills a combobox with all the worksheet names of the workbook.The second procedure copies all cells in the selected worksheet to an array.The error is the following: System.NullReferenceException: Object reference not set to an instance of an object.I think the error is in the cleanup part, when I set the objects to nothing and close everything. Can someone confirm if this is good or wrong code and maybe point me in the right direction?
I Programe a COM Library in VS2008 to use in Excel , but I'm stuck with an error that I don't understand.
I use this two classes , that compile and register OK. One Class QBitems return a nongeneric collection of QBItem but when I tried to use the Add and/or Remove Method, I receive the following error in Excel VBA :
Run-time Error '438': Object doesn't support this property or method.
I added a class (SImpleClass) in the library and I called from VBA it returned the QItems collection without problem.
NEW: When I replace the QBItem object with a string in the Collection QBItems everytthing works OK. It looks like interface doesn't like to pass an object like QBitem class
Excel/VBA:
Sub Pru()
Dim obj As New CollectionCOMClass.SimpleClass
Dim Itms As New CollectionCOMClass.QBItems
[Code]....
I am creating a report in my asp.net application. The report outputs to excel using the excel interop. Some calculations in the report cause excel to display "Inf" or "NaN" I want to force these calculations to zero so that the report displays zero and NOT "Inf" or "NaN"
View 1 RepliesThe Current Setup:So, I can use the following code to save a file as an XLS:
_myWorkbook.SaveAs("FileName.xls", Excel.XlFileFormat.xlWorkbookNormal)
I can also use the following code to save a file as an XLSX (Since I use Office 2010):
_myWorkbook.SaveAs("FileName.xlsx", Excel.XlFileFormat.xlWorkbookDefault)
I have tried (unsuccessfully) to save the file as an XLSX using the following code:
_myWorkbook.SaveAs("FileName.xlsx", Excel.XlFileFormat.xlExcel12)Why does this not work? Last I checked, Excel 12 was Excel 2007 (a version that supports XLSX). Am I missing something?
I get a This extension can not be used with the selected file type error)
I've developed a vb.net app which works great on my dev machine, both within the IDE and as a compiled executable. But when I deploy it to a user workstation, I receive the following:
Unhandled exception has occurred in your application. If you click Continue, the application will ignore this error and attempt to continue. If you click Quit, the application will close immediately.
Could not load file or assembly Microsoft Office Interop.Excel, Version=11.0.0.0,Culture=neutral, PublicKeyToken=71e9bce111e9429c' or one of its dependencies. The system cannon find the file specified.
I am trying to Import an XML file into Excel and then Export the data to CSV. I did the Import Data steps manually in Excel while recording a Macro. I am basically using those commands in VB.NET.
Try
xlWBook.XmlImport(filename,, True, xlRange.Cells(1, 1))
xlWBook.SaveAs(outFile, xlCSV, False)
[code].....
I'm working on the Inventory section of the project I'm working on. This particular form holds a tab control, by default it has 2 tabs one named General, and the other named "New..". When the user clicks the New tab an input box opens to collect the name for the new Department, it then changes the name of the current "New.." tab, and then adds another tab and names it "New..". This process continues until they reach their limit of departments. The problem is that when the tab gets renamed, a listview control needs to be added into the tab. Adding the new control is simple, but setting it's position as the one in the previous tab has seemed to elude me. This is what I've tried.
Private Sub TabControl1_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles TabControl1.Click
Dim SD As TabPage
SD = TabControl1.SelectedTab
[code]....
I have a second form that loads when the main form loads. It sits behind the main form, is mainly transparent and does not allow interaction from the User.
Its as if the form is on the desktop, which is what I'm going for.
I set the location of the form to be in the top right hand corner of the desktop. On my PC, which is a 23" monitor, it works and looks great. But when I use my application on a notebook or a smaller screen, the form gets cut off. Why is obvious, because of the screen size differences.
What I want to know is how I might set the form to a more... definitive position. Rather, relative to the size of the screen.
I haven't searched much yet, but maybe there is a way to set the location of the form to a specific location of the desktop, not relative to the size of the screen.
I am having issues using interop with office excel in .net. I have tried a lot of things to close the excel application, workbook and worksheets i create to use in my program but i always notice the excel.exe still in memory. I have even tried forcing the garbage collector,
[Code]...
I am developing a fairly comprehensive Excel add-in, applying a lot of ops. Take a workbook, save under new name, apply actions (add names, change formulae, etc). Generally it works fine, but from time to time .Net throws an InvalidCastException on virtually any of my CTypes. When I acknowledge the error and run the code again (without quitting Excel) on the exact same Excel workbook, no error occurs. The InvalidCastException occurs maybe in 40% of all tries, otherwise the add-in succeeds.
[Code]....
I want a combined Ranges. How do I combine two ranges into one?
Dim range1 as Excel.Range = osheetTemperatureData.Range("A7:"A10")
Dim range2 as Excel.Range = osheetTemperatureData.Range("C7:"C10")
Dim range3 as Excel.Range = range1 + range2 '????
I am loading a KJV.rtf file at program startup into RichTextBoxDisplay. When I want to select, lets say, Matthew Chapter 1, I want the program to take me to Matthew Chapter 1. I know I could just load a seperate file into the rtbDisplay, but do you know how many chapters and books are in the Bible..
View 2 RepliesI'm having trouble setting a form's location in the load event.
config_set = File.ReadDatabaseKey(Public_Variables.settings_radar, _
"Window Position X", Public_Variables.config, Public_Variables.config_path, 5)
If Misc.GetContainsOnlyNumbers(config_set) Then
Me.Location.X = CInt(config_set)
End If
In my Windows application I have 2 forms, Form1 & Form2 in Form1 there is a Button so now I want to place the form2 exactly bottom of the Button when I click.
View 3 Replies