629 Topics
 | |
| | I need to move a chart from one sheet to another in an Excel workbook, and I am having issues with different versions of Windows and Excel. Here is the code I am currently using: (excelApp is declared correctly) [code]excelApp.Workbooks("Book 1").Sheets("Sheet 1").ChartObjects(1).Chart.Location(2, "Chart 2")[/code] This works perfectly and consistently with … |
| | I've recently downloaded the package that allows you to work an excel file using python at: [url]http://www.python-excel.org/[/url] I'm new at installing things from a programmer perspective... can anyone tell me how I'm able to determine if I have installed the programs correctly?  |
| | So this is the scenario. I provide a link to an Excel file. All the users are intranet user, so security is not a concern here. When the user clicks the link, it will pop up dialog to open/save with Microsoft Excel. Users are currently able to open file correctly. …  |
| | I have a spreadsheet (roughly 200x200 in size) that is a matrix of 0's and 1's that define rules. These rules cannot be expressed in procedural logic because they need to be easily accessible for change by a user for modification. The first row are header value strings and the … |
| | Hi, My code opens Excel 97-2003 version Excel file correctly, but gives error when the Excel file is in 2007 (*.xlsx) format. How to solve this? - Mahesh |
| | Hello, i am working with vs2008 (web application) and I want to copy some content from an excel sheet and and using the clipboard i want to copy the contents in a gridview I have tried using Clipboard.GetDataObject() but no matter what ever i do it is always returning null … |
| | I am using the .Net 4.0 and excel 2003 How can i use an oledb connection to retrieve the cell format of an excel spreadsheet... I specifically want to find out if a cell column (or cell itself) is in a numeric percentage format. I cannot seem to find this … |
| | hi there, i have an excel sheet and i need to get values from the excel sheet to the mdf file in the visual studio 2008 database. the value i want to get from the excel file is a accounting value witch is displayed like this $ 67,300.34. how can … |
| | Dears [INDENT]This is an electricity billing Site link [url]http://www.mepco.com.pk/ls/defftree.asp[/url][/INDENT] I click on each link and SELECT and COPY/PASTE , It takes 3 hours minimum each day to save all pages in Excel. I want to get all pages automatically using PHP or Query. Because higher management demand reports each day. |
| | I have MS Office Pro on a work computer that we just tasked to a new job that requires MS Access. All of the other programs in MS Office open and work fine, but when I try to open Access (either by clicking directly on a file or by just … |
| | Hi all. I attached a code creating file from datatable. I have a problem saving Excel file in c# using Microsoft.Office.Interop.Excel. When I'm saving the file as Exsel 2003 (xls) format the file is OK. When I'm saving the file as Excel 2007 (xlsx) format I get error massage from … |
| | Hi, my Outlook will not open after downloading and running the latest service packs yesterday. Outlook opens into a tiny window, first it said Microsoft SEtup Bootstrapper is not working, now it only opens in a tiny window and then closes saying, cant open Outlook. Tried uninstallating service packs through … |
| | I want to get rid of all my paper documents. (that I'm able to) These include recepts, invoice copies, bills, college work, sketches, etc. What software is best to use for this? I'm running Windows XP and have a scanner. My main concern is document organisation after I have scanned … |
| | hey guys, this is me once again moving around data access. my problem now hide in the import process of an excel file that would be inserted into sql db. the problem is the excel file may be updated or changed and i have to periodically import it and perform …  |
| | Im just learning and have made some userforms with text box's and comand butttons and i am trying to make them create a new excel workbook and save it. I have try'd all sorts of different code that i have found on the net but carn't get any to work. |
| | hallo there everyone.. i got an array from my database [CODE]$save=split("[|;]",$listOfItems);[/CODE] and what i want i s after making some changes to the attributes on the array above to export them on an csv or excel format but directly as a message to the browser .. i dont want it … |
| | I have an excel sheet which i have not open for almost 6 months and I have forgotten the password. Is there a way i can retrieve password. I have searches on internet but not getting a perfect cracker.  |
| | Please help! I have the following code in the head section of my web page: <script> ..... var serverLoc = "http://www.mydomain.com/mypath/"; var serverFile = serverLoc+"myexcel.xls"; var ehandle = new ActiveXObject("Excel.Application"); //error occurs var eWBhandle = ehandle.Workbooks.Open(serverFile); var eShandle = eWBhandle.ActiveSheet; var cell1 = eShandle.Cells(1,1).Value; // get more data ..... </script> … |
| | I've used the following code to open Excel. It works but generates a browser error warning the visitor that the web page is trying to run an add-on with an unknown name, and control with an unknown name. Is there a better way to open Excel (read only) in order … |
| | Oracle 10g I have been trying to import an excel .xls spreadsheet into oracle. I can import everything fine but whenever I need to import a sheet that includes dates it does not work. Is there a special formatting I need to do with excel(THE DATE COLUMN??)(I have tried just …  |
| | Hi, I am extracting data from datagridview to Excel. But for columns with so many numbers Excel turns the format to 6,45646E+11 Is there a way that I can prevent this. I tried to use worksheets but I could not even save the data by using that. Here is my … |
| | I have been trying to inset an excel spreadsheet into oracle. I can import everything fine but whenever I need to import dates it does not work. is there a special formatting I need to do with excel? I have tried every step that I can possibly think of. whenever … |
| | I have installed Microsoft Office Home and Student 2007 on windows 7, and it is installed good, but when i try to open Word or Excel it gives me a message saying "Microsoft Office word (excel) has not been installed for the current user. Please run setup to install the …  |
| | I particularly like the Publish facility within VS 2008 (VB). What I actually want to do is use the same facility for a Spreadsheet. I.E. I have a Spreadsheet with a chunk of VBA code behind it. Is there anyway to incorporate the spreadsheet into a VS 2008 VB project … |
| | I have an excel spreadsheet that has 2 used columns. Using Python I have to read the data in those to columns. So far I have a code that lists the item in column A and B on Python GUI. Once that is done I have to write code so … |
| | Hi, my first programming query: well three queries. All I hope are trivial :) I thought I would have a go at trying to retrieve a value from an existing excel sheet. To do this I have used Project...Add reference to add - Microsoft Excel 12.0 Object library - Microsoft …  |
| | I want to build a simple app, text box and command button to open a excel file with a specific worksheet. lets say i have 20 excel files with 20 worksheets each all with various names, I'm trying to make it so i can enter the worksheet name in my … |
 | Im trying to customize the Contact Card that appears on the Office Communicator 2007. The default information about the pesron that appears on the Contact Card is not enough and would like to include some more information. I've downloaded the API and also looked into adding custom tabs using an … |
| | Hi, I'm trying to connect to a web service using excel. I have currently no issues logging into the web service and also fetching data using one of the methods. But the two other methods, I get the error that states that it had run into an error restoring data. … |
| | I'm battling with an Excel VBA problem. I'm working in a spreadsheet in a folder called "Master". On the spreadsheet, I have, amongst other data:- Cell c5 the SalesRep Cell c6 the Customer cell c7 the QuoteNo. I then run a macro to do some calculations. After the calculations, I …  |
The End.