Here is the goal- I have a table of data that I am trying to populate. The spreadsheet is financial in nature and it tracks portfolio values as the user inputs them. It is a trailing 18 month data sheet. The most recent data is that the bottom of the list. I am trying to create a field where a user can enter a month/dollar value a...
I would like to have part of an excel formula be dynamic, other than a cell reference. For instance, suppose that in column A (cells A1:A99) I have a bunch of numbers, and I want to know how many of those numbers are greater than 50. If I wanted this calculation to be static, I could simply use one of the following: =COUNTIF($A$1:$A$9...
Daily, I export data from an application to an Excel spreadsheet. From that spreadsheet, I copy the data to a workbook on a tab called Daily. I then run a simply macro that reformats the data and sorts it. From that tab, I want to copy all the rows that match other tabs. So, in column B, the row will be flagged with the target tab na...
I have the following code: private DataSet GetDataSet(string tableName) { DbCommand cmd = GetConnection().CreateCommand(); cmd.CommandText = "SELECT data FROM " + tableName; DbDataAdapter da = GetDataAdapter(); da.SelectCommand = cmd; DataSet ds = new DataSet(); da.Fill(ds, "query"); DataTable dt = ds.Tables...
I have noticed that I get all sorts of annoying errors when: I have ActiveX comboboxes on a worksheet (not an excel form) The comboboxes have event code linked to them (eg, onchange events) I use their listfillrange or linkedcell properties (clearing these properties seems to alleviate a lot of problems) (Not sure if this is connected)...
I have this question because I am not familiar latest generation of MS VS product. But for work reason I may need to develop an Excel plugin for Excel 2003. I would like to study what are the alternative (other than using VBA) I have a VS C++ 2008 Exp Edition installed. From the available project types, I don't think I can create a xl...
I stumbled on a way to crash excel in Workbook_Open while making an .xla It's still a toy project, so I've been able to just delete it and start over (and now I'm coming back with version control and baby steps.) However, assuming I didn't have those options, how would I possibly edit the .xla remove the fatal code, since I have to loa...
I have a series of big excel files that work like a program, but I hate beeing tied up (stuck in VBA for excel 2003), so... Whats the best way to implement a gui over a excel vba program (office 2003)? (are there any tools for that... I want to move away from the office suite, but still have it in the background) Or what's the easiest ...
=LARGE((Sheet1!A1:Sheet2!A1:Sheet3!A1),2) ...
I have a massive file with 10 sheets recreated from scratch, 12 sheets updated, 5 sheets loaded with raw data, and 7 sheets that are used by the macros for the report. I have recently added a new sheet and am running into the Excel "Too many different cell formats" problem. I have read some of the google search results and they say I sh...
The Access 2007 app creates an Excel 2007 from a template file and saves as Excel 2007. xlWorkbook.SaveAs "C:\TestFile.xlsx", FileFormat:=51 'Excel 2007 without macros If Excel 2007 is installed, no problem. If both 2003 & 2007 are installed, the file is created as 2007, but the the computer is trying to create with 2003. A "Newer ver...
Hi all friend; I have an application using VB6 and I use Microsoft Word 11.0 object library and Microsoft Excel 11.0 object library to use for the report purpose. But there are some computer in my work place using Microsoft Office 2007, so they cannot generate the report (with excel chart) from my application. I try to use late bindin...
Hello, I want to create & fill a .xls file using ADO.NET or LINQ, but I do not want to have the columns names in the first row. I just want to insert rows starting in row no. 1. I know I have to insert colums first, but... is there a way to 'hide' those columns headers? The problem is that, in first row of my spreadsheet, I must have ...
I am working on a light weight Java client library for Android mobile platform that can read and write to Excel files in .xls(BIFF) and Office 2003 XML format. No sooner we decided to start than we got stuck with a basic question. How do we determine the format of the excel files in Java? Please help. Thanks. ...
I'd like to open EXCEL 2003 from a .NET 3.5 application and manipulate each cell in the Excel sheet. Any one does that? ...
I have an excel 2003 vsto workbook that I would like to make available via sharepoint for version control. Ideally it could be checked in/out by non-developers for tweaking excel equations, and I would be able to deploy the compiled dlls somewhere else when I need to update the managed VSTO code. I understand I may need to use some click...
I've written a control that runs from the Actions Pane in Excel 03. This control references a satellite .NET assembly. The control works fine but when I exit excel I get an exception. I've gone through and made sure that I'm properly disposing all of my objects. I called the dispose method on cldatapi object I created and set it to not...
say I want to make the first row of the excel ss something like this: .Rows("1:1").Select With Selection.Borders(xlEdgeLeft) .LineStyle = xlContinuous .Weight = xlMedium .ColorIndex = xlAutomatic End With ...
I have a report which I used the command subtotals. Aesthetically, I just want to make these subtotal rows (columns A to P) filled with color, be in Bold and have a surrounding border. There are hundreds of totals generated in my report. And they do not have a recurring row position. So basically in order for it to look good, I do it man...
Hi All, How to set cell/column value dynamically using PHPExcel library? I am fetching result set from MySQL database and I want to write data in excel format using PHPExcel library. Looking at example $objPHPExcel->getActiveSheet()->setCellValue('A1', 'cell value here'); indicates that we have to hard code cell/column reference As...