excel

Excel Automation

Hi All, Does everyone know how to create custom button in the excel that display simple window form in csharp language? For example: A button called "Show" in the excel toolbar that show messagebox pop up. ...

How can I get Yahoo realtime stock quotes in Perl?

There's a fairly easy way of retrieving 15-minute delayed quotes off of Yahoo! Finance web site ("quotes.csv" API). However, so far I was unable to find any info on how to access real-time quotes. The hang-ups with real-time quotes are: Only available to logged-in user No API Non-obvious how to scrape the info - I'm somewhat convince...

Retrieving Data from SQL Server within Excel 2007

I have the following requirements I have relational content stored in a SQL Server 2005 database. I want to retrieve this data, transform it and display it in an Excel 2007 document. I would like this to be pulled from within Excel at the click of a button. As far as I can tell I have the following options... Create a view in...

Read/Write Excel Files Directly To/From Memory

Several people have asked, in a roundabout way, but I have yet to see a workable solution. Is there any way to open an excel file directly from memory (like a byte[]) ? Likewise is there a way to write a file directly to memory? I am looking for solutions that will not involve the hard disk or juggling temporary files. Thanks in adva...

Reading Excel spreadsheets with Delphi

I need to read from and write to Excel spreadsheets using Delphi 2010. Nothing fancy. Just reading and writing values from specific cells and ranges on different sheets. Needs to work without having Excel installed and support Excel 2007. Some things I've looked at: I've tried using ADO, which works OK for selecting everything in a...

Nested IF statements in Excel [Over the 7 allowed limit]

hey guys, i am trying to create a spreadsheet which automagically gives a grade to a student based on their marks they got. I've apparently hit excels nested IF statement limit which is 7. here's my if statement: =IF(O5>0.895,"A+",IF(O5>0.845,"A",IF(O5>0.795,"A-",IF(O5>0.745,"B+",IF(O5>0.695,"B",IF(O5>0.645,"B-",IF(O5>0.595,"C+",IF(O5...

using excel formulas in .NET

Hello How do i use excel formula AUTOSUM for a range of columns in .NET for ex: i need something like this. Item Quantity ---------- A 10 B 20 ---------- Total 30 Thanks in advance ...

Spreadsheet_Excel_Writer path problem

Hi, I have tried the following program for writing the contents into Spreadsheet. I downloaded the Spreadsheet_Excel_Writer package also. <?php ini_set('include_path','/xhome/rekha/public_html/PHP_FORUM/PHP/open_office/Spreadsheet_Excel_Writer-0.9.2/Spreadsheet/Excel/Writer.php'); $workbook = new Spreadsheet_Excel_Writer(); $workbook-...

Talking to printer from Python CGI

I have a Python CGI. I want to print the data in the page. There will be a print button and when the user clicks teh button, I need to do some processing and send the data to the printer. I similarly want to implement 'Export to excel'. Please let me know how to do these ...

Problem when extracting excel data using POI in JAVA?

I have just Extracted the cells from the excel sheet using POI, everything is working fine. But whenever there is an empty cell, the very next right cell data is what I get as a output. But, if exists a value in the latter, the desired output is coming. This is the logic i've written. Iterator<Row> rowIterator=sheet.rowIterator(); ...

summing up excel files in matlab

Is there a easy good way to sum up various excel files in matlab? what i really want is similar to dos command type file*.xls> sumfile.xls I have from 10-100 excel files with similar file name formats excet the date XXXXX_2010_03_03.xls, XXXXX_2010_03_03.xls and so on..... Is there a command to copy the files one after other...

How to change the range of a chart in Excel using VBA?

Hi guys, I'm using an Excel sheet to keep track of a particular time series (my daily weight, if you must know). I created a macro that inserts a row, automatically adds today's date and calculates a moving average based on my input. There is also a chart to visualize my progress. I have tried recording a macro that updates the time s...

Copy rows in excel and increment a column

I am trying to create an excel macro that will take a spreadsheet that has n number of rows in it and copy each row as many times as a number located within one of the cells. Also it would increment one of the numbers within a cell. For example I have a layout like the following: Column1 Column2 Column3 Column4, etc.. Data-a ...

Update access table rst with named cell values from excel

I have got a table in access that I loop through using a DAO recordset. For every recordset I take a bunch of data to an excel spreadsheet and run it through a model in excel. This produces a bunch of results in excel which are calculated in named cells. I want to be able to update the current recordset in access with these results but ...

Best way reading from dirty excel sheets

I have to manipulate some Excel documents with C#. It's a batch process with no user interaction. It's going to parse data into a database, then output nice reports. The data is very dirty and cannot be ready using ADO. The data is nowhere near a nice table format. Best is defined as the most stable(updates less likely to break)/ ...

How to select a names from a column MS Excel 2007

Hey guys, I have an Excel document which has a list of students and their group names. I have another sheet within the the same excel document which is called comments. In this sheet, I would like to have a list of individual team names listed. There are 65 students and 14 defined groups. Is there a way to select the 14 group names, w...

Count Clicks in excel

Hi, Can some one recommend any free program which counts the number of clicks Clicked inside a cell. For Example Imagine something like Spreadsheet I click on A1 cell the value shows 1 Then I click A1 cell again the value shows 2 and so on If I click A3 cell somewhere in between the click count on Cell A3 shows 1 and so on If someth...

VBA - Create ADODB.Recordset from the contents of a spreadsheet

Hello, I am working on an Excel application that queries a SQL database. The queries can take a long time to run (20-40 min). If I've miss-coded something it can take a long time to error or reach a break point. I can save the results to a sheet fine, it's when I am working with the record sets that things can blow up. Is there a way ...

Writing Text data File using C# to excel

Hello, New at C# using visual studio 2008 and trying to load an excel sheet with a text file. My current program puts the complete file in one cell. Is there a way to put each data point in its own cell. Having issues interfacing with excel to accomplish this task. Thanks Joe ...

VBA How to find last insert id?

I have this code: With shtControleblad Dim strsql_basis As String strsql_basis = "INSERT INTO is_calculatie (offerte_id) VALUES ('" & Sheets("controleblad").Range("D1").Value & "')" rs.Open strsql_basis, oConn, adOpenDynamic, adLockOptimistic Dim last_id As String last_id = "select last_insert_id()"...