Use this tag for questions about spreadsheet apps, plug-ins, libraries, etc.
I want to export data from database tables into different sheets of an excel spreadsheet. For example, employee data from …
spreadsheet export-to-excel pentaho kettleBasically, I would like Sheet 1 to pull data FROM Sheet 2, renamed to 'Loot'. However, the data that is pulled from …
filter spreadsheet google-docs containsI am trying to iterate a COUNTIF formula that counts the number of cells in each row containing numbers greater …
google-sheets spreadsheet countif array-formulasI didn't find this information anywhere on the internet so thought I would post here as I found the answer …
.net border spreadsheet xls npoiI'm looking for the equivalent VBA-GAS of: Application.ScreenUpdating = False I'm running a very long macro in one of my …
vba google-apps-script refresh spreadsheet updatingIs there a way to return the cell from which VLOOKUP() gets its value? For instance: ________A_____|__B__| 1 | Mouse | 1 | 2 | Keyboard | 2 | 3 | …
google-drive-api google-sheets spreadsheet gs-vlookupI am trying to create a simple spreadsheet (with a REST/JSON back end) that looks like the Google Docs …
html css spreadsheet contenteditableI have a function in a controller that takes in some specifications and generates a report on them. This function …
ruby-on-rails excel spreadsheet xml-spreadsheetI have scoured the internet, and although I am fairly sure this just isn't possible yet due to the design …
forms csv google-sheets spreadsheet google-formsI am trying to parse an excel spreadsheet using "spreadsheet". How could I get the background color of each row?
ruby spreadsheet