similar to: Edit & Email an Excel Spreadsheet in Rails 2.0

Hi, Does anyone know if there is a way to generate Excel spreadsheets with landscape orientation with the Spreadsheet gem? -- You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk-/JYPxA39Uh5TLH3MbocFF+G/Ez6ZCGd0@public.gmane.org To unsubscribe from this group, send email to

DeaR all, I'd like to know how to create an Excel file with multiple spreadsheets from R. I searched the help files and found [1] but it is not what I want to do. Let's say I have a data frame called DF as in the following code # Some data set.seed(123) ID<-sample(5,100,replace=TRUE) X<-rnorm(100) Y<-rpois(100,10) Z<-X*Y DF<-data.frame(ID,X,Y,Z) str(DF) I'd like to

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

We have some Excel spreadsheets stored on our Samba 2.2.8 fileserver. The permissions are set such that some users can write to these and some cannot, but they can all read them (the world-readable bit is set). When a user with read/write access tries to open the spreadsheet, there is no problem. The user is happy and productive and outside the sun is shining. Excellent! Have a biscuit! When a

Hi David Thanks you for reply, are you sure about this? Windows and Samba SMB byte range locking feature doesn't allow this by locking regions of a single file ? From: "David Bear" <dwbear75 at gmail.com> To: "Dante F. B. Colò" <dante.colo at stwbrasil.com> Cc: "samba" <samba at lists.samba.org> Sent: Friday, April 7, 2017 1:59:56 PM

I have copied the R FAQ pertaining to available packages into an EXCEL file. They take the following form - Design Regression modeling, testing, estimation, validation, graphics, prediction, and typesetting by storing enhanced model design attributes in the fit. Design is a etc. Devore5 Data sets and sample analyses from "Probability and Statistics for Engineering and the Sciences (5th

Hello everyone I 'm trying to find what it happens on my Samba AD servers especially with shared spreadsheets, my personal opinion this feature on Excel is crap and unreliable but many people use it, how does Samba currently behave with this ? Is someone experienced any problem with this ? Frequently happens changes made by other user are lost the spreadsheet opens as read only , the

Hello everyone I trying find what it happens on my Samba AD servers especially with shared spreadsheets, my personal opinion this feature on Excel is crap and unreliable but many people use it, how does Samba currently behave with this ? Is someone experienced any problem with this ? Frequently happens changes made by other user are lost the spreadsheet opens as read only , the shares are all

Hi All, Created xls file using spreadsheet Excel is not read on linux. I am creating an xls file are as follows workbook = Spreadsheet::Excel.new("Filepath") worksheet = workbook.add_worksheet("Sheet1") | | | workbook.close but when i am trying to download this it not get download. -- Posted via http://www.ruby-forum.com/.

Even on pure Windows file servers you cannot effectively have simultaneous read/write for multiple users. I may have had 2 simultaneous users work one time for a few minutes. But it is not stable. So not even a microsoft server can do it. On Thu, Apr 6, 2017 at 8:58 AM, Dante F. B. Colò via samba < samba at lists.samba.org> wrote: > Hello everyone > > I trying find what it happens

Hi folks, Win 7 64bit R 2.12.0 32bit Problem in reading Excel spreadsheets (the text file, research_databaseI.xls, was download on Internet) > data=odbcConnectExcel(file.choose()) > sqlTables(data) TABLE_CAT TABLE_SCHEM 1 C:\\Users\\satimiswin764\\Documents\\research_databaseI <NA> 2

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

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 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: >

Under Windows, I have used RODBC to connect to Excel spreadsheets as per the example below: library(RODBC); connect = odbcConnectExcel("testdata.xls"); query = "SELECT [data$.ethn], [data$.sex], [data$.age], [data$.height], [data$.weight], [label$.label] FROM [data$], [label$] WHERE [data$.ethn] = [label$.ethn];" data =

I reproduce from memory my exhaustive look into this issue. RODBC uses the Microsoft ODBC DLL's developed by Microsoft. These DLL's perform an automatic determination of column type based on the contents of the first N rows of cells in each column, where N [0,16]. N may be set in the Windows system registry, and there are a few other things that may be set in the system registry which

Is there a gem that will present things in a spreadsheet-like style? I tried searching via both Google and rubygems.org and found mainly things to import and export .xls[x] and Google Spreadsheets. There was also the Exercise gem, which had zero documentation about what it *does*, which doesn''t make me confident in using it. Why do I ask? I''ve made a little app

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

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 <-

Hello, I've been using odbcConnectExcel to connect to a spreadsheet database containing a single worksheet. Unfortunately when I try to access the data R cannot see the table. When I run sqlTables it shows the worksheet as a SYSTEM TABLE instead of as a TABLE that I can access. I am fairly certain that I am do all of the same things I've done in the past when it worked just fine.