How do I force refresh a Google Gadget that's embedded in another website to update automatically and instantly when the Google spreadsheet/form that it's linked to updates with new data? ...
We would like to provide a mechanism for the user to enter data in a excel sheet kind of an interface, so that users can create it online. What kind of solutions are available to acheive this? Would it be possible to use spreadsheets.google.com as an embedded widget so that users can manipulate the doc. Are there any other options availa...
I'm trying to generate some reporting from existing reports in CSV format. These CSV files don't contain just data, but report name, report date, multiple data sets- each line doesn't necessarily contain the same number of fields or consistent data per row. I was curious if there was some spreadsheet type library available, this is how...
I have a table in mysql like this: +-------+--------+-------------+ | child | parent | data | +-------+--------+-------------+ | 1 | 0 | house | | 2 | 0 | car | | 3 | 1 | door | | 4 | 2 | door | | 5 | 2 | windscreen | | 11 | 5 | wiper | +-----...
Hello Today I started using the spreadsheet gem to make my excel files, but one of my column is a date, and I want to format this column as a date. It looks like it is in there somewhere, with the date method in Spreadsheet::Excel::Row, but I can't make it work. Any hero out there? ...
Hi, Getting a weird problem when uploading a spreadsheet via C#. Here's an example of the spreadsheet I'm using: JournalISSN ----------- 1650327 223956 1651781 9254927 3064530 9209964 924977X <- this is causing an error 3768716 My upload code (snipped for brevity) string connectionString = "Provider=Microsoft.Jet.OleDb.4.0; Data So...
I have been using the Spreadsheet::ParseExcel to list the contents of spreadsheet. I've seen several examples on how to dump the entire spreadsheet. I really would like to see how to use this script more selectively. The example below from IBM basically dumps the content of all cells that have data. #!/usr/bin/perl -w use strict;...
Using the following code fails with a NullPointerException and the attached stacktrace. At this step I have successfully authenticated with google and try to access the following URL: https://spreadsheets.google.com/feeds/spreadsheets/private/full The call to getResponseCode fails (also the getInputStream call would fail) Any help appr...
I'm looking for a way to customize a column chart. Open office and Excel produce the following chart for a column with values 1, 2, 3, 3, 2. But, I'd like to generate a chart with the following properties. The chart should have five bars. All bars must be of the same height. The chart should color bars based on their values. In this ex...
Hello, Every month I process a vendor's MS Excel spreadsheet for my work. I have to remove columns, rename columns, re-format columns, and then email the resulting spreadsheet to colleagues. Is there a way, in Excel or Numbers or programmatically, to automate this extremely repetitive process? Thanks, Sergio ...
I have an Open Office Calc Sheet with a column full of data that has hyperlinks. I wish to trasnfer the hyperlinks to another column. How do I extract them? Thanks.,. ...
I am having a hard time getting started with some way to visualize some data consisting largely of congressional members and their political affiliations. As such it is mostly text data and doesn't lend itself immediately to something like ManyEyes, Google Charts etc. More to the point, I have spreadsheets of data on senators and repres...
Hi Guys, I have a column in excel which is exported from a sql database. The columns read like this: 'Payment Funds: (654321) Company charged Public - Payment of transfer. Charged from account xyz to abc (into autopac agent).' The reference number: 654321, account: xyz and abc; comment: (into autopac agent) - are different for all ...
How can i convert a lot of '97 excel file to '95. I look for other solution as File - Save As. ...
Our customers use 500+ applications and we would like to integrate these applications with our. What is the best way to do that? These applications are time registration applications and common for most of them is that they can export to csv or similar, some of them are actually home-brewed excel sheets where time is registered. The bes...
I want to generate an MS Excel file from PHP. I know one can do something like this: header ( "Content-type: application/vnd.ms-excel" ); header ( "Content-Disposition: attachment; filename=foo_bar.xls" ); But it will generate a file with just one Sheet. What I want is generating a file with multiple sheets. How can I do that? Maybe t...
I am trying to read an Excel spreadsheet file with Ruby, but it is not reading the content of the file. This is my script book = Spreadsheet.open 'myexcel.xls'; sheet1 = book.worksheet 0 sheet1.each do |row| puts row.inspect ; puts row.format 2; puts row[1]; exit; end It is giving me the following: [DEPRECATED] By requiri...
I am using Spreadsheet for ruby for creating excel files. Now I want that a excel must be created when it doesnt exist. So I wrote this -: require 'rubygems' require 'spreadsheet' include Spreadsheet workbook = Spreadsheet.open "data__#{$KEYWORD}.xlsx" rescue Excel.new("data__#{$KEYWORD}.xlsx") But Always keeps throwing this error - ...
I am using spreadsheet gem to generate excel file. Now the problem with it is that when we modify an existing file it wont allow to save it with same name http://spreadsheet.rubyforge.org/GUIDE_txt.html and in the running script I cant delete and recreate the file beacause it is still being used. Doing so throws permission denied error. ...
I have a spreadsheet that is currently formatted improperly for a mysql import. The data are organized by column rather than by row. So, the first column has the field names, the second column contains record 1, and so on. Is it possible for mysql to understand this data? If not, any ideas on how to import these data besides redoing the...