myService = new SpreadsheetService("openentry-catalog-1"); myService.setAuthSubToken(sessionToken, null); SpreadsheetEntry spreadsheet = (SpreadsheetEntry) spreadsheetEntry; WorksheetEntry worksheet = spreadsheet.getWorksheets().get(2); this.addNewProducts(worksheet, photos); private void addNewProducts(WorksheetEntry entry,...
I want to create an 'universal' XML spreadsheet compatible document... Something compatible both with Microsoft Excel and especially with the open source alternatives (OpenOffice Calc, Gnumeric, ..). There's an issue I encounter when I try to border some cells. This is how you do it in Excel: <Border ss:Position="Bottom" ss:Line...
I've been tasked with creating a report in MS-Access that looks exactly like a spreadsheet that a vendor supplies to us for my company to fill in. The number of records per page is about 40 and there are usually 3-6 pages that need to be prepared. Each month there is a new report sent out and I just got finished writing it all in manual...
Hello.... So I have a data frame in R that contains integers, NA's, and a random assortment of strings inside the cells. Only one data type per cell. What I'm wondering is how to change all of the cells that contain strings into NA. Any idea how I could do this? ...
I've been wanting to put together a simple little app that'll let me create simple spreadsheets; just entering data into a grid, maybe with a little basic font/cell/border formatting in there for good measure if possible. In other words, I want to just slap together the spreadsheet equivalent of Notepad. Looking around, I can't seem to...
Anyone doing this currently? What do you use? ...
I need to find how many rows in worksheet have been defined. How can I do this? ...
Hi there, I have no experience with developing macros but hope you may be able to help. We have 12 excel spreadsheets that monitor the distribution of documents. Each time a document is distributed, the date that document was distributed is entered into its relevant excel spreadsheet. What we would like to do is create a seperate exc...
Hello, I have a heap of Lotus 123 spreadsheets (not written by me) with Lotus Scripts in them doing an awful lot of leg work (moving data from one spreadsheet to another, and other things like that). I am making the consideration of moving it all away from Lotus 98 and going to something a little more open, like OpenOffice. I was wonde...
What's the best way to parse a file in SpreadsheetML format with Perl? I've tried Spreadsheet::ParseExcel, but it doesn't recognize the format. Here's the error I get when trying that module: No Excel data found in file It looks like CPAN doesn't have a module that can parse it as far as I can see. What's the easiest way to do it? ...
Hi all. I require help with a reasonably complicated VBA macro loop for a dataset I've been provided. The dataset exists as one long column one thousands of different entries. I've tried recording macros but I am at a loss at the best way to approach it. Any help would be greatly appreciated. In its simplest terms, I need to locate a ...
Hi! I have a problem in Excel 2007. I need to compare one value - letter "C" - to a range of cells that are on one row. The problem is that the values should be in every other cell. So if I have a row like this - C 434 C 324 C 3453 - it should say in a cell in the end - OK And if I have a row like this - C 22 B 665 C 8877 - it should ...
Do you know any ASP.Net controls like Spread for ASP.NET that can render Excel like pages that has built-in formula evaluation? ...
how i can convert days to year in google doc spreadsheet ...
Hi, I have a googlespreadsheet where I keep a list of bugs and whenever I fix a bug I change the status from "Not Started" to "Complete". I want to write a script for the Google Docs spreadsheet such that whenever I change the status to "Complete" the entire row gets highlighted in a certain color. I already know that Google Spreadshe...
I need to display a spreadsheet in a view. There's no need to edit the cells of the spreadsheet, and the spreadsheet will consistently have the same number of rows and columns. (The spreadsheet cells will be populated with financial figures generated by the user in a different view) How would I do this? A UITableView seems inadequate, ...
Hi all, I have a public google spreadsheet with some data in tables. I'm developing an android app which I want it to read these tables and then make a listview with the fields on the spreadsheet. Which will be the best way to do that? Thanks! ...
Specifically what I am trying to do is add new worksheets alongside ones already there. I've tried to use book.create_worksheet :name => 'new_sheet' but it overwrites the previous worksheet. I searched the site here and saw some people using a different gem that allowed "book.add_worksheet" (the Spreadsheet gem is supposed to have suppo...
I'm using Zend Gdata to connect users to a shared Google Docs spreadsheet that serves as a backend to a custom interface. I need to track which user most recently changed the value in a particular column. I'm not aware of a way to do this using Google Spreadsheets (but that would be an acceptable answer to my question). Is there a w...
Hi, I'm trying to finish off a Google script to reformat a field that I would ideally like to turn into a hyperlink. This is the common format of the text in the spreadsheet: tistaff: other sections: person: randomname This is how I would like it to appear: <li><a href="http://www.thisisstaffordshire.co.uk/topics/person/randomname"&...