similar to: Spreadsheet in Rails

Hi, I want to have a page in my Ruby on Rails application that is like a dynamic / updateable data grid. Like a matrix or spreadsheet segment (x rows, y columns) which one can click in any of the cells and make an update, which triggers some AJAX code to fire off the update, and then the responses come back and update whatever else needs updating based on this change. Is there a prototype

I wonder why ruby core method ''take_while'' does not work as expected in the below Rails console example: irb(main):003:0> arr = [] => [] irb(main):004:0> arr << Date.today - 15.days => [Sun, 27 Jan 2013] irb(main):005:0> arr << Date.today - 25.days => [Sun, 27 Jan 2013, Thu, 17 Jan 2013] irb(main):006:0> arr << Date.today => [Sun, 27

Dear all, For the export to excel functionality i have used Spreadsheet::Excel gem it works fine. i would like to design the excel sheet with html ,css.(i want to give color and height and width to each cell of the excel sheet...) I have goggled for this but nothing saved me... please u people suggest me any sample code or links that i can try with... Thank you for your time to view my query

Hi everybody I''am working on a Rails app (using utf-8) in which I use the Spreadsheet gem to generate Excel files (.xls in my case). I ran into some issues when trying to write foreign characters to the generated Excel-File. The solution I found so far is to use Iconv like this: Iconv.conv(''ISO-8859-9'', ''utf-8'', some_string) This works fine with for

I have searched the archives and I did not find the answer to my question. Is there a way to read in a .odf spreadsheet without modification to a .csv file. I am analyzing my classes scores on their first exam, and would like to read the grade book in without converting it to .csv. thanks -- Stephen Sefick Let's not spend our time and resources thinking about things that are so little or

Hi colleages! I want to import data from ms-excel and other spreadsheet formats (lotus, etc). Does exist any way to do it within R? The main problem is that many spreadsheet data use comma as decimal separator and not the point as needed in R (and many software for Linux), so importing data first as a tab separated values does not solve this problem. Thanks, Tom?s Revilla

I am thinking about writing a new open source spreadsheet application since I think the spreadsheet applications out there (Microsoft Excel, LibreOffice Calc, etc.) do not have some features that I would really like to use. I would like the spreadsheet to recalculate very fast and wondered if it would make sense to use LLVM to calculate the cell values quickly. Each cell of a spreadsheet

Hello everybody, I dont found the new feature about kernel 3.0 and Xen DOM0. Where Kernel 3.0 has native support in dom0? how would I enable this option. In my currently kernel (gentoo source 3.0 and vanilla kernel 3.0) don''t found Xen device drivers, need i enable anything? thanks! -- ------------------- Pablo J. Villarruel / pablo@libo.com.ar

Hello, After I use the lm() function to perform a multiple linear regression, and then use the step function to eliminate variables that predict the weakest, I need to export the final equation to a spreadsheet or a text file. Below is some sample code. In the end I want to export the coefficients to a spreadsheet. Will you please direct me to the appropriate syntax? Thanks for your time, --Eric

Hello I am trying to import an *.xls spreadsheet into R. I am doing this as follows: > read.table(file("A5_DL.xls")) But obtain the error: Error in type.convert(data[[i]], as.is = as.is[i], dec = dec, na.strings = character(0)) : invalid multibyte string at '?????' So I copied it all over to a text document and tried to import that, thus: >

Mats, Thanks for your feedback. I guess I should elaborate on one of the features I would like to implement. In today's spreadsheets if you want to crunch a lot of data, you usually put the data in rows and put expressions in cells to the right of the data and repeat those cells for every row of the data. I would like to create a spreadsheet system that can process the same quantity of

What is your best solution to table display/edit/sort using ajax ? I''ve bumped into these: dhtmlxGrid: http://www.dhtmlx.com/docs/products/dhtmlxGrid/index.shtml tablekit: http://www.millstream.com.au/view/code/tablekit/ Better: MIT/Ruby licence, prototype based Do you any other tools to display/sort/edit tables in place ? Thanks for your answers, Gaspard ------- project: zena

Hello I am trying to work through a problem, but feel like I've gone down a rabbit hole. I'd very much appreciate any help. The task: I have several directories of multiple (some directories, up to 2,500+) *.docx files (newspaper articles downloaded from Lexis+) that I want to iterate through to append to a spreadsheet only those articles that satisfy a condition (i.e., a specific

Hello, I experimented the Metafor and Meta packages in the scope of replacing Excel for meta-analysis. I performed the first working example provided in Michael Borenstein's book "Introduction to Meta-Analysis" with Excel, Metafor and Meta. The numbers given by my spreadsheet, which I validated from Borenstein's book, conrespond quite closely to those given by Meta, but

I would also look at https://pandoc.org perhaps which can export a number of formats... And for spreadsheets https://github.com/jqnatividad/qsv is my goto weapon. Can also read and write XLSX and others. A sample document or two would always be helpful... el On 29/12/2023 21:01, CALUM POLWART wrote: > It sounded like he looked at officeR but I would agree > > content <-

There's a new page on the Burns Statistics website http://www.burns-stat.com/pages/Tutor/spreadsheet_addiction.html that looks at spreadsheets from a quality assurance perspective. It presents R as a suitable alternative to spreadsheets. Also there are several specific problems with Excel that are highlighted, including the status of statistical functionality in Excel. Patrick Burns Burns

http://www.loligo.com/asterisk/misc/Presentations/Asterisk-features-20040106.xls I had been asked a while ago to put together a short Excel spreadsheet listing many of the "common" features of Asterisk as compared to a typical PBX. Many PBX vendors supply an exhaustive list of their features, and I figured I'd take as many of the unique features as others had offered, and put

It sounded like he looked at officeR but I would agree content <- officer::docx_summary("filename.docx") Would get the text content into an object called content. That object is a data.frame so you can then manipulate it. To be more specific, we might need an example of the DF You can loop this easily with a for statement although there are people who prefer a non-for approach to

checkout the 'officer' package Thanks Jim Holtman *Data Munger Guru* *What is the problem that you are trying to solve?Tell me what you want to do, not how you want to do it.* On Fri, Dec 29, 2023 at 10:14?AM Andy <phaedrusv at gmail.com> wrote: > Hello > > I am trying to work through a problem, but feel like I've gone down a > rabbit hole. I'd very much

Hi Andy: I don?t have an answer but I do have what I hope is some friendly advice. Generally the more information you can provide, the more likely you will get help that is useful. In your case you say that you tried several packages and they didn?t do what you wanted. Providing that code, as well as why they didn?t do what you wanted (be specific) would greatly facilitate things. Happy