For instance: //omitted vector<_bstr_t> cellData; Excel::_WorksheetPtr pSheet = application->ActiveSheet; Excel::RangePtr pRange = application->Cells; _bstr_t cellValue = pRange->Item[1][1]; //single cell cellData.push_back(cellValue); //omitted Without: MFC ATL Question: How to copy, multiple cells, for instance A1:B1, ...
Hi, I have an Excel spreadsheet which is being used to specify filesystem build information for our Unix team. This worksheet would have different information depending on the system to be built. For example, a production system would have many filesystems, whereas a development system only one or two. So based on user input, we woul...
This is something I ran into last year, and SO seems like a good place to document it :) Q: When automating Excel (/Word/...) from Delphi, how can I check if an Excel function returned the variant Nothing (as it's called in VBA)? ...
I'm looking to have a form generated automatically. The form would show two text boxes per account, and the account name would have to be displayed as well. The main problem is that there are a variable number of accounts to show, and that I would like a button to click to then copy the data in those text boxes to the worksheet once the ...
Is it possible to open a worksheet in excel from matlab and edit the formulas? The idea is to automate an uncertainty analysis by creating a second sheet with the uncertainty in each cell for the value from the previous cell. Essentially, I want to treat the cells as variables and do SQRT(SUM(Partials(xi)^2)) for each cell. Matlab sho...
I am trying to locate a set of source code that would allow me to open and read the contents of an Excel file on Linux from within a C program. I dont really want to link it to OpenOffice SDK if I can find something that just does these two things. carl ...
Hi, At the time of exporting to excel using ASP. After converting a column in text format single quote is visible in the excel file. how to hide this automatically ? ...
I'd like to have the value of a cell change if a specific set of grouped cells are hidden or not. Is there a worksheet change action for grouping and ungrouping cells? I can't seem to generate one with Macro Recorder; it doesn't seem to care if cells are hidden or unhidden in a group. Then, I can have a macro change the value of the cell...
In Excel 2003, when I change Series.Interior.ColorIndex to a value I need, it has no effect. It has an effect only when I first manually change color and then run the macro. Apparently this triggers some update mechanism. Does anyone have an explanation for this? Is there a way to somehow trigger this in the chart?.. I.e. make sure that ...
Hi I have a Reporting service report. I am using grouping on the report. My report looks great in HTML rendering, but in excel version the first and the last columns are having extra lines, where that lines are not in html version. Could anyone please give me a hint , why its so. Thanks, Suni ...
Is anyone familiar with a library or tool that can determine which format an excel file is in? Or, failing that, documentation on the different formats that would allow me to write my own? ...
Is there a way to convert Excel 2003 XML file to Excel 2003 XLS format with Java? Or at least any open source framework that can do this? Thanks, Matthew Huang ...
I've never used spreadsheets for anything more than a quick graph. I'd like to learn how to use spreadsheets to their full extent and have been playing around on Google Spreadsheets. There do not seem to be any thorough tutorials on Google Spreadsheets and even Google's documentation often makes references to Excel functionality withou...
I'm trying to add comments to cells in an Excel 2007 spreadsheet. I'm using the OpenXml SDK 2.0 to do so. My use case is this: I've created a template Excel file that I copy and use that as my starting point, rather than create an OpenXML document from scratch. My template file has a comment in cell A1 so that Excel has already crea...
Hello We are interested in trying to import an Excel spreadsheet into our Blog. A sample of the Excel spreadsheet that we generate each day and want to export into our Blog is located at: http://www.wallstreetsignals.com/WhatsWorking.html Our Blog is located at: http://whatsworkinginthestockmarket.blogspot.com/ We are interested in...
I want to do the moral equivalent of the following VBA code: For Each col In Worksheets("Sheet1").Columns # do stuff Next col I have generated MFC wrappers for the Excel type library that get me this far (the generated types all derive from COleDispatchDriver: CApplication app; app.CreateDispatch( clsid, e ); CWorkbooks wbks( a...
How do I programmatically add a toolbar (with buttons on it) to Excel (2002 or later)? When the button is clicked I want a handler to create my COM object and call a method on it? ...
Hello, In a macro, I'm applying the same treatment in each Worksheets of the file. I want to determine wich column contains a specfic text (might be different in each WS). For Each Cell_version In Ws.Range("1:1") If Ws.Range(convertir(Cell_version.Column) & "1") = "ICI" Then Column_version = convertir(Cell_version.Column) ...
Alright I know this isn't 100% related to programming (the Excel book in question doesn't use VBA at all) but I'm hoping someone can help me out with this or point me in the right direction. My boss got a spreadsheet from a vendor that has a combobox/dropdown list with various part numbers; when you select one it populates the rest of t...
Seems a common enough problem this, but most solutions refer to concatenating multiple SQL commands, something which I believe can't be done with ADO/VBA (I'll be glad to be shown wrong in this regard however). I currently insert my new record then run a select query using (I hope) enough fields to guarantee that only the newly inserted...