The workbook I am working on in Excel uses graphics with 3d properties which are set in VBA. I just changed an image in the workbook, and now Excel complains that it can't execute any of the following lines of code: Selection.ShapeRange.ThreeD.Depth = fsdoord Selection.ShapeRange.ThreeD.ExtrusionColor.RGB = carcol Selection.ShapeRange....
Hi all I have arrays of points that contain series data (x & y). Is there a quick way to output these arrays into an excel file? Thanks ...
The Excel Services and Excel Web Access ship with Microsoft Office SharePoint Server 2007. I'm wondering if Excel Services or any component of that technology could be used without running a Sharepoint Server. Thanks in advance! - phi ...
I've been asked to update some Excel 2003 macros, but the VBA projects are password protected, and it seems there's a lack of documentation... no-one knows the passwords. Is there a way of removing or cracking the password on a VBA project? ...
Hi, is is possible in Excel to have some sort of fixed function defined for a entire column? This function needs to persist when a row is deleted, and it needs to 'exist' when new row data is added... So in the example below, If I cut row 1 to row 3 (so the worksheet is empty), I want the 'new' row 1 to have the function in column D al...
I have an Excel sheet with some cols and i want to import those into the mysql table. The Problem is that there are more colums in the mysql table than in the sheet (which is absolutely fine). What would be the easiest way of getting the data in the right fields? My solution would be export to csv and put it in mysql via php, but there...
A rather complicated problem in data exchange between a database and a bookform: The organisation in which I work has a database in mysql for all social profit organisations in Brussels, Belgium. At the same time there is a booklet created in Indesign which was developed in a different time and with different people than the database an...
I am trying to insert new lines into an Excel XML document. The entity that I need to insert is but whenever I insert that into PHP DOM, it just converts it to a normal line break. This is what I am getting: <Cell><Data>text text2 </Data></Cell> This is what I want: <Cell><Data>text text2 </Data></Cell> I cannot figu...
I've been using Excel 2003's 'Web Services Toolkit' for some time to write spreadsheets that connect to external web services via VBA. (ie you install the Web Services Toolkit which adds a 'Web Service References...' item to the 'Tools' menu. You then set up a reference to an Web Service URL and the Toolkit writes the necessary proxy c...
i am using excel 2007... i have the following ranges... D E G H 5 1 2 1 1 6 2 2 1 1 now i select the range F8:G9 and write the following formula "=D5:E6*0.2+G5:H6*0.3" and press the CTRL+SHIFT+ENTER... i.e. doing matrix addition,... now i have the following result F G 8 0.5...
Hello everyone, I am using VSTS 2008 + C# + .Net 3.5 to read Excel file created by Excel 2007 (but saved as Excel 2003 xls format). Here is my code, when executing code adapter.Fill(cities), there is exception -- "OldDbException Could not find installable ISAM". Any ideas what is wrong? static void Main(string[] args) { string conn...
I'm trying to access a 2003 formatted Excel spreadsheet in .NET. I have the process completed, and it's pretty straight forward by accessing the sheet and process the data. It works perfectly. The only problem is that Office 2007 Excel is encrypting these documents. Now, it has some odd behaviors. It seems to be encrypting the documents...
How do I format cells in Excel with python? In particular I need to change the font of several subsequent rows to be regular instead of bold. Thnak you, Alex ...
Hi, I run a small golf eclectic with excel. One of the things we have is a points system. I would like to get the 5 highest points scored over the season and have them ranked from 1 (being the highest points scored) to 5. My knowledge of excel "sums" goes only a wee bit further than add and subtract. Thanks! ...
I am trying to find out how to distribute an excel file on the net in such a way that most users will be able to use it. I am aware of the Microsoft Excel Viewer (which can open Excel files without having Office installed), but it doesn't run VBA code, which is a necessity for this file. Moreover, there are some changes to the API in O...
I am trying to split a string in an excel formula, something like I can do in many programming languages, e.g. string words = "some text".split(' '); The problem is that I can't be sure that there is more than one word in the cell. If I try to use the FIND() or SEARCH() functions, they return #VALUE if there is not space. Is there a...
I am trying to take clipboard data copied from excel (i.e. tab seperated text) and parse it into a Collection of Dictionaries. The idea is that each row will be represented by a Dictionary which maps from headers to cell values. The first row in the copied data will contain the headers. Getting the text from the clipboard is easy enoug...
Hi, I have a pdf file embedded in an excel worksheet that is opened through and icon. This icon object will have a specific name (i.e., "ObectToPrint"). What I need to do is print this pdf file without actually opening it. Is this possible? Thanks! ...
I've got a CSV file full of contact information and I'm trying to load it into GMail contacts, but the e-mail addresses aren't all correctly formatted so GMail doesn't recognise it as an e-mail field. I can open the CSV file in Excel (Mac) but I don't know if there's a way of pattern matching in Excel. Also, some of the fields may contai...
Here's the scenario: I'm an SSIS virgin, but I found an excuse to start playing with it. I have a single Excel source dataset in the following format, with each row representing one month (the last day of the month): [Date] [Value] 4/30/2008 3.38 5/31/2008 3.65 6/30/2008 3.97 ... My destination is a table that has a ro...