Top "Spreadsheet" questions

Use this tag for questions about spreadsheet apps, plug-ins, libraries, etc.

Using Android to submit to a Google Spreadsheet Form

First time asking a question here. Usually I can find my answer without having to ask, but this time I'm …

android post spreadsheet google-forms
Writing to excel files in ruby using roo gem

I am parsing Excel and Excelx file using Roo gem. But I am not sure how to write in those …

ruby ruby-on-rails-3 excel spreadsheet
Center all text in PHPSpreadsheet and make the cells expand to fill up with context

I struggle a bit to make all the cells set the context to center and to autoexpand so it doesnt …

php spreadsheet styling phpspreadsheet
Extracting rootdomains from URL string in Google Sheets

Hi I am trying to extract the rootdomain from URL string in Google Sheets. I know how to get the …

web google-sheets spreadsheet
Need more examples on how to use Spreadsheet::ParseExcel

I have been using the Spreadsheet::ParseExcel to list the contents of spreadsheet. I've seen several examples on how to …

perl excel csv spreadsheet cpan
How to extract sheet from *.xlsm and save it as *.csv in Python?

I have a *.xlsm file which has 20 sheets in it. I want to save few sheets as *.csv (formatting loss …

python excel csv spreadsheet xlsm
Open Office Spreadsheet (Calc) - Concatenate text cells with delimiters

I am using Open Office's spreadsheet program and am trying to concatenate several text cells together with delimeters. For example, …

openoffice.org spreadsheet concatenation
Using a Variable in Excel for COUNTIF

First time question and I hope it's easier than I'm making this. Can I use a variable inside a COUNTIF …

excel variables spreadsheet formula countif
What difference does it make if one runs a VBA code in "Sheets", in "ThisWorkbook", and in "Modules"?

What difference does it make if one runs a VBA code in "Sheets" ("Sheet1", "Sheet2", etc.), in "ThisWorkbook", and in "…

excel spreadsheet vba
I got this message (CANNOT_GROUP_WITHOUT_AGG) from a simple query

I how to fix this error message? Unable to parse query string for Function QUERY parameter 2: CANNOT_GROUP_WITHOUT_AGG …

google-sheets spreadsheet google-query-language