My clients produce lots of data in the form of ad hoc spreadsheets, which they want to upload to their web site and then be able to create online, reports that require joins and filtering of the results. These report should not require any custom coding but will be made with the help of the online platform - the users will be able to cho...
I have created my Excel sheet a.xls using Perl where I have field as: date name eid 13/jan/2010 asa 3175 When I will compile next time and if date will be more than previous date then it has to update like wise: date name eid 13/jan/2010 asa 3175 14/jan/2010 stone 3180 If the date will be of pr...
In an excel sheet, I have roughly 30 rows x 100 columns of data. Each row represents a different "client". For each client, I've create a summary sheet that is emailed to them and that also contains all the information from my main sheet My question is as follows, is there a way for excel to create a new sheet based on some template she...
I'm using http://spreadsheet.rubyforge.org to generate a spreadsheet and I'm having trouble with something. I'm opening an existing workbook and adding data to it. I have manged to get number formatting working to some extent, at least excel is seeing this data as a number, but (very un-excel like) the client would like the number align...
I have a friend who had been using a proprietary photo album product and reached a hard limit on the number of photos. He managed to export the data to spreadsheet format (including image filenames) plus he of course saved the image files themselves. He says there doesn't seem to be any other product that can import this format. Is th...
Hi, We are displaying in an XML spreadsheet data exported from an SQL server DB and if th euser clicks save without changing the format the file size is over 6 time the size of the same data in native .xls Does anyone know a way to force the save as .xls? ...
I have got an Excel document that is used as patient database for a practice. In the first table there is a complete list of all patients with the date of their first appointment and (if applicable) the date of their final appointment. In the second table, I would like to have a list of all current patients (no final appointment). In th...
I found javascript solution for removing gridlines on Google docs spreadsheets (using "download as HTML" and then past javascript in Web Address Bar): works great !! javascript:var v="none",e="defaultView",o="border",m="Color",w=function(a,b){if(document[e]){if(document[e].getComputedStyle(a,null)[o+b+m]=="rgb(204, 204, 204)")a.style[o+...
Hi All, In OOCalc I want to use the CONCATENATE function to add quotes to each string in column A. So in cell B1 I want to do: =CONCATENATE("\"",A1,"\"") OOCalc does not like this, or without the escaping backslash. Does anyone know how to do this, or what an alternative method might be? Thanks ...
Basically I'm trying to get a bit of regex to do the following... I have some data I need to split, the sample data looks like this: Brand Name - Product Name Another Brand - Shoe Laces Heinz - Bakes Beans I want to be able to select the brand name or the product name but I can't seem to do it without catching the " - " part in the re...
Hello I have an excel file and I wanna look for the duplicate values in a certain field like a list of email accounts. Like making them to be formatted the same or something like that. Do you know how to that ? ...
The spreadsheet is Excel 97-2003 compatible and permissions 777 use strict; use Spreadsheet::ParseExcel; print "Content-type: text/html\n\n"; my $parser = Spreadsheet::ParseExcel->new(); print "<br>gets here:".__LINE__; my $workbook = $parser->parse('test.xls'); print "<br>never gets here:".__LINE__; ...
I have an XML Spreadsheet that is automatically generated. There is a varying amount of Columns and Rows depending on the report. When printing I would like for it to Fit to Width (Right now if there are too many columns it will not fit on a page... even when landscape). I was initially using FitToPage but for reports with hundreds of ...
I need to generate excel documents with ruby (from rails) on a Linux Machine. I know of Spreadsheet::Excel, but it doesn't support formulas, and uses a pretty old format.. Is there any other option, not necessarely free or opensource, that is a bit more powerful? thanks ...
I have list of STD Codes. If I paste a STD Code as 04562 , it automatically truncates the leading zero and store it as 4562. But I want it to to store it as 04562 Plz Give me a solution. Any Help will be highly appreciated ...
As an online storage, two of them can be a choice, with officially supported API. Both of them have its advantage and weakness. Google SpreadSheet supports RSS feed, but has limited no. of rows. GAE Bigtable is more scalable, but harder to be remotely accessed by external party. Any other comparison? and what's your favorite? ...
Is there any Javascript (or other NON-java ) CLIENT SIDE calculation library that will allow a complex excel spreadsheet to be posted online as a web page, and then can calculate directly on the web page when the user changes the values. Like a slimmed down web based excel. I've seen JavaScript grid controls that offer simple calculati...
Hi everyone, I have a spreadsheet with multiple pages in it.When I click on a button I need to open this spreadsheet and write all the data(dataset/datatable) returned from the database into one of the pages in the spreadsheet.I saw so many articles for exporting dataset to a new excel sheet.how do i open an existing spreadsheet and writ...
When I write a whole table into an excel worksheet, I know to work with a whole Range at once instead of writing to individual cells. However, is there a way to specify format as I'm populating the array I'm going to export to Excel? Here's what I do now: object MissingValue = System.Reflection.Missing.Value; Excel.Application excel =...
Any idea how to go about formatting the data so I can export from my app data in excel format or even a simple table would be okay, how are people getting stuff out of the phone? This particular app is about keeping track of money, so i can pretty much turn everything into nsstrings but how do I: A. format the strings so the fields ar...