[excel] Forum Topics

Hi all, Can someone please help... I have a small youth football web site and would like to display the league table on a web page. What is the best way to display this information, so that it is not to manual when i come to update the results weekly. …

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.

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 …

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 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 …

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 …

Hi, i need to export a listbox data to an xls file, how i can do this? thanks

Okay, I know this is really really simple, but for the life of me, my brother and I cannot get this to work properly. [LIST] [*]We have a number in Cell D4(and down). [*]In E5 is the binary conversion of D4. [*][*]In F2-N2 we want to have the individual numbers …

I had a problem at work which I solved, but that raised me another question. I wanted to export a page to excel, so I used this: [CODE] response.setContentType("application/vnd.ms-excel;charset=iso-8859-7"); [/CODE] It worked but while I was searching for an answer I found 3 possible content types for the excel: > …

Hello All, I need some help to convert the macro I recorded in Excel into a working Vb.Net application. It involves attaching a file into a Excel cell. The file is a Word document named "File.doc". Here's the recorded macro: Sub DemoAttachFile() Workbooks("Book1").Activate Sheets("Sheet1").Select Range("B2").Select ActiveSheet.OLEObjects.Add(Filename:= _ "C:\Documents and Settings\File.doc", …