I'm generating an excel spreadsheet using the PEAR extension, Spreadsheet_Excel_Writer. I need to add an array formula to one of the cells, but all the info I've read about them only discusses them as if you're in the Excel program itself: it says you have to type in the formula as normal and then press Ctrl+Shift+Enter to switch it to a...
I've used the Open XML Format SDK 2.0 to create a simple excel document. Opening the document in Excel first requires Excel to open it. I've narrowed this down to the CellFormats within the Stylesheet. The contents of which are below: <x:styleSheet xmlns:x="http://schemas.openxmlformats.org/spreadsheetml/2006/main"> <x:numFmts coun...
Greetings all, I have the following bit of code that I have used in the past to export a DataSet generated from the Stored Procedure 'HISTORICAL_COSTS' to Excel. Dim c As Long = 1 For Each dc As DataColumn In Me.WOCostDataSet. & _ HISTORICAL_COSTS.Columns .Cells(1, c).Value = dc.ColumnName.ToString ...
What is the best way to check is access form is open and get the value of textbox using Excel VBA. I mean is there a way to check if MS Access application is running and if it is then check certain form is open then get the value from this form's textbox field. Something like If MSAccess.([Application name]).Forms("FormName").isOpen...
I am trying to select the ChartArea using the Select method through reflection in C#. This is the line of code I am using: oChartArea.GetType().InvokeMember("Select", BindingFlags.InvokeMethod, null, oChartArea, null); Here, oChartArea is the ChartArea object. This works perfectly fine in Vista/Office 2007 but throws exception in XP...
Is there anyway to problematically take a MS Word file and convert to excel. (Obviously, word would to guess where to put stuff). Any language would be fine ...
I would like to export a GridView to excel, which is easy enough. But above the grid, in Excel, I would like some other information for identification. Can I somehow export things other than gridviews while then putting in the gridview below? Edit: For some reason when the GridView1 is visible and I try to export, the entire page export...
The format function in vba is changing the date. e.g for format("3/12/2009","DD/MM/YYYY"), the function returns 12/03/2009 where "3/12/2009" is what excel vba reads from a cell that has the value 12-Mar-2009 and the format as "dd-mmm-yyyy" ...
I need to get rid of an XLA (excel add-in) from a spreadsheet, but everything on the web seems to point to renaming/deleting the xla file. This is not an option as the xla file is used by many other spreadsheets and is on a shared drive. Are there any other alternatives? ...
Assume all traces of Office 2003 will be removed from the computer. UPDATE: I understand that I will still be able to use .xls files. I'm asking about automating Excel through the COM interop from outside Excel. When I add a reference to Excel to a VB project, it gives me a different version of the dll for different versions of Excel. ...
I can already populate the data into the spreadsheet, create the chart based on the range I select. However, when it comes to formatting the actual chart I feel a bit lost as their are so many options!! It is an xlCylinderBarStacked type chart. I simply need to make the color of the bars a nice light orange and make the background a lig...
Is there any way to convert PDF to excel? I'm looking for a free component but cant find one. Thanks in advance. ...
Hi there, I've developed an Excel 2003 addin in C#, using VSTO and VS 2008. The addin works just fine on my machine (HP NC6320 laptop, 3gb RAM T5600 1.8ghz Core2 cpu), however when it is tested on another users machine (HP nc6710b laptop 2gb RAM, T7200 2ghz Core2 cpu), it is substantially slower. I've also tried it on another laptop the...
Here's one for Joel... I am looking for ways to demonstrate to an Excel user (with no programming experience) how learning some Excel VBA can make their life working with Excel a little easier. First thoughts are to use an example that replicates manual tweaking of a spreadsheet, such as one click conditional formatting of all the data...
Hi I have a problem with graphs in Excel (2003). I have several matrices : a b c d e f g h i j k l m n o p q r s t u v w x I want to plot the vector z = (a, b, c, d, e, f, g, h, i, j, k, l, m, n, o, p, q, r, s, t), so I pick one row at a time in "series" under graphs using Ctrl, but when the number of rows reach a certain limit, Ex...
I know what you're thinking, just download the data as a CSV and import into Excel. Unfortunately what we require is for a user to choose some data from a Rails app then easily (i.e. with as little user intervention as possible - ideally a single button press) export it, and open it in an existing Excel spreadsheet that contains various...
I'd like to be able to source control my Excel spreadsheet's VBA modules (currently using Excel 2003 SP3) so that I can share and manage the code used by a bunch of different spreadsheets - and therefore I'd like to re-load them from files when the spreadsheet is opened. I've got a module called Loader.bas, that I use to do most of the ...
Is this possible in Excel? I have a workbook with multiple worksheets. I wrote some vba code in a code module to shell to an exe and pass it cell values as arguments. What I want to be able to do is select a cell or row in any of my worksheets and then call my Shell Sub while passing the values from a couple cells to the Sub. A hot-key...
A project I am working on requires values from a C# application to update 6 values in an Excel sheet. This excel sheet then populates a named range of items and prices, driven by a number of VLOOKUP formulas and worksheets within the same Excel File. The two columns in the range are named 'Item' & 'Price'. 'Item' is a column of items ...
I can't for the life of me figure out why certain cells are shaded in a spreadsheet template I downloaded. I confirmed that the cell's shading property is set to no color. The cell has a simple formula: =SUM(J8:K8). If the background color is being set by code in another cell, I'm not sure how to find it. Searching for the cell name (e...