Top "Spreadsheet" questions

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

Excel - find cell with same value in another worksheet and enter the value to the left of it

I have a report that is generated in Excel which contains an employee's number, but not his/her name. Not …

excel excel-formula spreadsheet vlookup
How can I quickly and easily convert spreadsheet data to JSON?

I want to convert spreadsheet data (such as from Excel/*.xls files or Open Office, etc.) to JSON files. What …

json spreadsheet xls file-conversion
Importing Excel spreadsheet data into another Excel spreadsheet containing VBA

We need to write an Excel spreadsheet with VBA code in it; the code reads and performs operations on the …

excel vba import spreadsheet
Selecting non-blank cells in Excel with VBA

I'm just beginning to dive into VBA and I've hit a bit of a roadblock. I have a sheet with 50+ …

vba excel spreadsheet
How to generate an Excel document with multiple worksheets from PHP?

I want to generate an MS Excel file from PHP. I know one can do something like this: header ( "Content-type: …

php spreadsheet
What is the difference between Sheets.Select and Sheets.Activate?

In VBA for Excel, what is the difference between Sheets.Select and Sheets.Activate ?

excel spreadsheet vba
How to get excel to display a certain number of significant figures?

I am using excel and i want to display a value to a certain number of significant figures. I tried …

excel spreadsheet rounding significant-digits
Google Spreadheets Scripts: check if cell is empty

I want to input a variable in a cell only if the cell is empty. The if statement, however, does …

google-apps-script google-sheets cell spreadsheet
How to generate an .xlsx using php

I need to generate an Excel file with extension .xlsx. Here is my simple code: $file = "test.xlsx"; header('Content-Type: …

php excel export spreadsheet xlsx
Retrieve rows from spreadsheet data using google app script

I am using Google app script to write form data to spreadsheet. Now I would like to fetch the values …

google-apps-script spreadsheet google-spreadsheet-api