If someone can help, I need some in properly defining some call parameters in an Access 2003 to Excel 2003 VBA problem. I'm trying to use the XIRR function in the ATP 2.0 Type Library from Access. I have referenced the ATP 2.0 Type Library in my Access project. Here is the relevant VBA code (with a little pseudocode) I'm using behind a f...
I managed to write some code to change the Excel application icon. See this post. As a follow up how can I change the icon that sits directly below the Excel application icon? I want to change the workbook icon as well. Any ideas? Thanks! ...
When I try to set a longish worksheet name using ruby and win32ole with the following code: require "win32ole" excel = WIN32OLE.new('Excel.Application') excel.Visible = 1 puts excel.version workbook = excel.Workbooks.Add worksheet1 = workbook.Worksheets.Add worksheet1.Name = "Pseudopseudohypoparathyroidism" #Length 30, fine worksheet2 =...
EDIT: Two additional token types added. Hi, I am trying to parse a line in a mmCIF Protein file into separate tokens using Excel 2000/2003. Worst case it COULD look something like this: token1 token2 "token's 1a',1b'" 'token4"5"' 12 23.2 ? . 'token' tok'en to"ken Which should become the following tokens: token1 token2 token's 1a',1b'...
I have a field in my Excel as follows €250 €240 Free .... In my SQL2005 Preview this looks as follows 250 240 (Blank) So it doesnt like Symbols and Text in this column altho it is going to a varchar column. Any Ideas ? ...
I recently upgraded to Office 2010 and I am using the Microsoft.Office.Interop.Excel version 14.0 in a c# project. My code opens one workbook and copies a sheet into a second workbook. This was working fine in the previous version but now when it copies it is missing all of the chart objects. Anyone have any ideas? Here is my code: publ...
I've set up my VSTO Excel add-in to use log4net for logging. Unfortunately I'm (seemingly) not able to make it configure itself from the app.config (which I deliver together with the add-in via ClickOnce). I have read http://www.darinhiggins.com/?p=13 which lists some ways to get the file name of the app.config and then configure log4ne...
I get an InvalidComObjectException after I close my application in the following piece of code: class MyExcelManager { myExelAppInstance = new Excel.Application(); // finalizer ~MyExcelManager() { myExelAppInstance.Quit(); // InvalidComObjectException thrown here myExelAppInstance = null; } } Why is that? Shouldn't ...
I have this function that export a datagridView in Excel sheet : public void ExportGridToExcel(DataGridView TheGrid, string FileName) { using (System.IO.StreamWriter fs = new System.IO.StreamWriter(FileName, false)) { fs.WriteLine("<?xml version=\"1.0\"?>"); fs.WriteLine("<?...
I am trying to prepare an Excel report using php. In the report I have a column called date. I am trying to format the date as date('d-M-Y',strtotime($row['MYDATE']));. So my problem is when displayed on the browser it is displaying in correct format (10-SEP-2010) but when on the excel sheet it is displaying as follows (9/10/2010). Wh...
I'm working on a small project regarding classic ASP and sql server. I have a drop down menu where the user can enter name, last name, etc. and it will create a query based on that and create a table displaying the result. What I want to add is the option to export to excel after the table is created. I've looked at other tutorials but...
Hi All, this is not the usedrange issue. For example in excel user selects a range (possibly empty) using mouse, let's say B4:C12. And let's say after this without deselecting the range user presses the macro, and macro should tell B4:C12. Can anyone show example? Thanks a lot in advance! the macro should be smth along the lines of the ...
I am pushing XML data into an Excel Table via C#, but when I do this, my ActiveX checkboxes lower on the page do not adjust their position. The spreadsheet rows move down, but the checkboxes do not. Also, at times it seems like even though the cells on the spreadsheet shift down, the row heights do not, messing up the formatting. I t...
Last time I checked, Apache POI did not support this feature. If you know any solution that does, either free or commercial, please suggest. ...
Hi, I have one excel workbook and, in one of the worksheets there is one cell where there is one embedded workbook. I want to read/write cells on that worksheet using interop. Please help me on how will I read/write on that workbook. The formula for that cell is =EMBED("Worksheet","") ...
Fairly simple; I've got the data I want out of the excel file, but can't seem to find anything inside the XLRD readme that explains how to go from this: xldate:40397.007905092592 number:10000.0 text:u'No' number:0.1203 number:0.096000000000000002 number:0.126 to their respective python datatypes. Any ideas? ...
I need a macro that will create a column called "Store". Then, the macro should fill all active rows below with the word "admin". Any ideas how to get this done? Thanks a million for helping! ...
hey all, i use old outsource application which create a DDE server, i've built a code that link to that DDE server and Lunch it to other server (worked fine). now, its can't connect to the DDE server any more, i've check with Excel file on the same Server and its worked fine, i didn't change anything in the code in the server transfer,...
In old excel visual basic it was easy to create and use a function. You create a function in Vb: public function testing() testing = "this is the result" end function Then in excel you put "=testing()" in your cell. In Visual Studio 2010 I am creating a new Excel Workbook project, putting the functions code into Sheet1.vb and saving...
Hi, I am dynamically creating an excel file with some list options using C#. There will be 3 or more columns with drop down list. Now the issue is that in some columns there will not be values in some rows. But the drop down list shows all the empty column values(empty) also. Is there a method by which I can filter the excel column wi...