spreadsheet

How to change column names from VBA

I am creating an Excel spreadsheet in Access vba code. I need to change the column names from A, B, C, etc to a meaningful name. I have looked high and low but cannot find a way. ...

Any function / method in Java to implement a "freeze panes"-like sheet?

We are using Java and Javascript to try to display a huge sheet with freeze panes, but it is being very difficult. Does someone know about a library, method, script or something, either free or commercial, to do this? Thanks. ...

Open Office org Calc (spreadsheet): limit of 64k rows?

I was using a not-so-up-to-date version of OOo.calc (Open Office Spreasheet component, version 2.04, default for RHEL 5), and bumped into a nasty surprise. When trying to import a csv file (with about 100k row), it said that there is a limitation of max 64k rows, and that remaining rows would just be discarded. I was planning to have use...

What are good methods to perform spreadsheet-like calculations in a programming language?

What's the best way to do spreadsheet-like calculations in a programming language? Example: A multi-user application needs to be available over the web that crunches columns and cells of numbers like a spread-sheet based on user submission. What are the best data structures/ database models/patterns to handle this type of work so that h...

How to automate a spreadsheet.

Hello. I am using microsoft excel 2002. What I am wanting to do is say I have some data in column A in sheet 1 and data in column A in sheet 2. What I want to do is when I add data to sheet 1 Column A (lets say some text), I want excel to automatically add a row in sheet 2 column A. So if I have 30 rows in both sheets and I add a strin...

(Rails) In-place editing of attributes via an "index" page.

Hi All, I'm looking to use "in_place_editor_field" on an "Index" page of items. Basically I want to mimic spreadsheet functionality for pre-existing line items in order to edit their attributes. However, none of the "in_place_editor" examples I've seen provide any useful real-world application of this nature. Also, a lot of the exi...

MS Excel 2003 - Anyone know how to delete rows that contain duplicate data?

I have an excel spreadsheet that has about 18k rows and three columns. I want to use this as a key in an Access database. So the three columns are [IDKeyNumber] [Name] [Category] The problem is in certain places the IDnumber is duplicated because the category has two category codes (typeA & typeB) All I really need to know how ...

search & replace on 3000 row, 25 column spreadsheet

I'm attempting to clean up data in this (old) spreadsheet and need to remove things like single and double quotes, HTML tags and so on. Trouble is, it's a 3000 row file with 25 columns and every spreadsheet app I've tried (NeoOffice, MS Excel, Apple Numbers) chokes on it. Hard. Any ideas on how else I can clean this thing up for import ...

What is the function to return the name/address of a cell or range (Spreadsheet)?

I could not find the function that returns the name of the cell referenced. For example, =SOMETHING(A5) that will return A5 as string. So that, I can write ="For more information, see " & SOMETHING(F50) & "." in a cell and the cell will read For more information, see F50., and then, when I move the F50 cell, the text will also change. ...

How can I modify an existing Excel workbook with Perl?

With Spreadsheet::WriteExcel, I can create a new workbook, but what if I want to open an existing book and modify certain columns? How would I accomplish that? I could parse all of the data out of the sheet using Spreadsheet::ParseExcel then write it back with new values in certain rows/columns using Spreadsheet::WriteExcel, however. Is...

Is it possible to populate a google form from a google spreadsheet?

I'd like to create a form that uses the data from the spreadsheet, so that it's dynamic. Is it possible to do this? I haven't been able to find anywhere that describes how, or any examples. All that seems possible is to populate a spreadsheet from a form, which I'll also use but its not the primary concern here. ...

Highlight all data in a HTML Table

Is there a way to do a selection highlight over all elements in a HTML Table? I want to be able to have data displayed in a tabular form, and the user to be able to click a button to select the relevant data to copy and paste into the spread-sheet of their choosing. ...

WPF toolkit datagrid spreadsheet

I would like to add excel spreadsheet functionality to the WPF toolkit datagrid, can this be done? I am building a wpf client-server application and I want client tohave wpf toolkit datagrid cells which would behave like excel spreadsheet cells would behave... Meaning they would have formulas and such... just like the spreadsheet woul...

what is baseuri field in gData

Hi All, I was trying to integrate google docs to a windows app. In the DocReq class there isa property called as baseUri. I have no clue what it is. Also, let me know if there are any examples for the google spread sheets in c# ...

Winforms hosting excel spreadsheet

Can I host an instance of excel application within a winforms application? Meaning, I want to use the excel as my datagrid in a winforms application. thank you for your input. ...

Excel: Set background colour of cell to rgb value of data in cell.

I have a column containing rgb values, eg 127,187,199 67,22,94 In Excel, is there any way I can use this to set the background colour of the cell? ...

Embed a spreadsheet/table in a PyGTK application?

Hi, In my application, we want to present the user with a typical spreadsheet/table (OO.O/Excel-style), and then pull out the values and do something with them internally. Is there a preexisting widget for PyGTK that does this? The PyGTK FAQ mentions GtkGrid, but the link is dead and I can't find a tarball anywhere. ...

JExcelApi currency format on formula cell - file error

Hi guys, I'm writing a spreadsheet with JExcelApi. I have two cells that I want to apply currency formatting to. From reading the API I discovered jxl.write.NumberFormat, which seems to do what I want. In my application I've written: NumberFormat currency = new NumberFormat(NumberFormat.CURRENCY_DOLLAR); WritableCellFormat currencyF...

Creating Excel or Excel compatible Spreadsheets on the server side in C#

I'd like to make server-side excel compatible spreadsheets that maybe use OpenXML or a structured data format. I've used Office Interop before to generate Excel spreadsheets, but those apps run on a PC that has office installed. For this web project I'm building, the server doesn't have office installed (and they don't want to buy it)....

Javascript Spreadsheet engine / library ? mapped to form fields

I'm looking into some sort of Javascript spreadsheet engine, that would allow me to define complex calculations in some sort of standard spreadsheet format (Excel, WKS or even some text based proprietary format) and then allow me to read it from this formatted file (on the server) into the Javascript spreadsheet engine and map it to par...