The "previous version" interface on Google Docs is very primitive. It wouldn't even allow you to select two arbitrary versions for comparison (but correct me if I'm wrong.) How can I access the previous versions via the API? ...
I'm working on creating an Excel file from a large set of data by using the Open XML SDK. I've finally managed to get a functional Columns node, which specifies all of the columns which will actually be used in the file. There is a "BestFit" property that can be set to true, but this apparently does not do anything. Is there a way to aut...
I have a spreadsheet (in Google Docs, but can be any spreadsheet) with a list of users (one per row), including a username (and other columns). Lets say there are 'n' rows. I have another spreadsheet with less than 'n' rows. One column has a username, another column has some other piece of data (lets say car rego number). I want to move...
Hi, I am creating a small rails app for personal use and would like to be able to upload excel files to later be validated and added to the database. I had this working previously with csv files, but this has since become impractical. Does anyone know of a tutorial for using the roo or spreadsheet gem to upload the file, display the c...
I am looking for a .Net spreadsheet component that could also execute the VBA contained in Excel files. I found Spreadsheet Gears to be very nice for manipulating and allowing the user to edit Excel files, but on spreadsheets that use VBA for calculations, well, these don't work. So, apart from Excel itself, are there any other compone...
I want to add some VBA code when the value in a cell changes. I've already tried Worksheet_Change(), as described at http://www.contextures.com/xlfaqmac.html#WSChange However, this won't work: it only fires when the user changes the value. I want to fire it whenever the value changes, i.e. whenever the spreadsheet recalculates. Any id...
Spent a bunch of time looking at this.. It seems that what little info there was about accessing a Google-apps spreadsheet is not very well maintained.. At Google IO this year there was an announcement of enhanced Google-apps script. Including UI elements.. That got me to thinking of creating a widget based on data in Google spreadsheet...
Using Spreadsheet GEM, I am able to read xls files in development environement. As I move to production server, application is unable to read xls files. Please help what can be the likely changes I am missing on to make it work in production environment too. Thanks in advance ...
Hi there, I have an Excel Spreadsheeet. There is a cell containing a concatenated name and surname (don't ask why), for example: Cell A2 BLOGGSJOE On this cell, I would like to run the following SQL and output it to cell A3, A4 and A5 SELECT i.id, i.forename, i.surname FROM individual i WHERE UPPER(REPLACE('" & A2 & "', ' ', '')) =...
Just looking for a free spreadsheet read/write library that is not GPL or LGPL. ...
I am getting following error while reading from a spreadsheet file. I have searched alot on Google. I have seen posts with similar problems but no reply to the problems. Does anyone know how to resolve this error? C:/Ruby/lib/ruby/gems/1.8/gems/ruby-ole-1.2.8.2/lib/ole/storage/file_system.rb:125:in `dirent_from_path': No such file o...
Hi, I'm using jXLS to write out a report as a spreadsheet, and one of my bean's fields is a java.util.Date. The bean has methods to either get the raw date, or to return a formatted string. I want the date to appear as a Date field in the output spreadsheet, so that my users can sort them by date order. If I put ${myBean.getDate()} i...
Hi, I am using SpreadsheetFormatColumns() to format the columns in a spreadsheet to "text", but I don't know how to do this, all the formats in the livedocs are for numbers, currency or dates... is there something like SpreadsheetFormatColumns(mySpreadsheet, {dataFormat="text"}, "1-15") out there? this is really bugging me... Thanks ...
I have absolute values of time(as in stopwatch not date/time) in various cells and I would like to add them and keep them the same format(as an absolute value). I have formatted the cells using hh:mm:ss time format. But when I add two values like, 22:34:00 4:00:00 I get, 2:34:00 because of wrapping around the 24-hour tim...
The company I work for has a Window application that includes integrated word processing and spreadsheet components. We use TextControl and FarPoint for the implementation. We have been developing an OS X counterpart for this application. The word processing functionality is actually pretty easy--the standard multi-line text view make...
I am looking for an open source spreadsheet application to stick into my web page. The most important feature I am searching for is formulas. Specifically, I need to be able to put in a cell which calculates the total of the contents of other specified cells. I've found some basic examples like Nitobi and ExtJs Extender, but they don't ...
I normally use the method described in csv parser to read spreadsheet files. However, when reading a 64MB file which has around 40 columns and 250K rows of data, it takes about 4 minutes. In the original method, a CSVRow class is used to read the file row by row, and a private vector is used to store all the data in a row. Several thin...
Hi, I'm using multiple sheets within my Excel application and want to activate (set focus on) a particular sheet upon exit.. Basically I want to set ActiveSheet property on my workbook, but since the property is readonly, is there any other way to achieve this? Thanks, Sam ...
hi, i'm exporting data from my database into an excel file using php and pear extension libraries. it works fine when i download small quantity of data. but if the data is large then the excel sheet gets corrupted, (usually all url gets written in the same cell) the data i'm exporting is of type string, url or date. why is the excel she...
Hi, what are the Rails plugin/gem solutions for converting a .xls file into a .pdf file? Thanks a lot for any feedback! Tom ...