Stack Overflow
Stack Overflow

Questions tagged [spreadsheet]

Use this tag for questions about spreadsheet apps, plug-ins, libraries, etc., where no more specific tag exists. A spreadsheet presents tabular data sets arranged in rows and columns, typically with tools for capturing, analyzing, and collaborating on that data. Each cell may contain alphanumeric text, numeric values, or formulas.

Note: The tag should only be used if a more specific tag does not apply to the question.

A spreadsheet presents tabular data sets arranged in rows and columns, typically with tools for capturing, analyzing, and collaborating on that data. Each cell may contain alphanumeric text, numeric values, or formulas.

Related Tags:

Don't tag your question with if a more specific spreadsheet tag is appropriate. Common spreadsheet software and their more specific tags include:

If there is no more specific tag than for your question, use one or more of the following related tags to enlarge the audience for your question:

References

4421 questions
133
votes
1 answer

What is the easiest way to convert an Excel spreadsheet with tabular data to JSON?

I want to convert spreadsheet data from Excel or Open Office saved as *.xls to *.json Data is not sensitive File is not very large
B. Clay Shannon-B. Crow Raven
  • 8,547
  • 144
  • 472
  • 862
51
votes
8 answers

PHPExcel very slow - ways to improve?

I am generating reports in .xlsx using PHPExcel. It was okay in the initial testing stages with small data sets (tens of rows, 3 sheets), but now when using it on a real production data with over 500 rows in each sheet, it becomes incredibly slow.…
SaltyNuts
  • 5,068
  • 8
  • 48
  • 80
43
votes
3 answers

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 not work. Any advice? var ss=SpreadsheetApp.getActiveSpreadsheet(); var r=ss.getRange("'odpovědi'!A2:J"); var rws=r.getNumRows(); ax=r.getCell(rws-1,…
orobinec
  • 445
  • 1
  • 4
  • 5
36
votes
5 answers

External API call in Google Spreedsheet is possible?

I have created a Google Spreadsheet with five columns; Once the user filled the values in the first three columns, It has to call a 3rd party API and fill the value(response) in the forth and fifth columns. Is it possible to write a code in Google…
It's me
  • 1,065
  • 6
  • 15
  • 30
35
votes
3 answers

is it possible to change sheet name with apache poi MS excel java android

is there any way to update existing sheet name of MS Excel file knowing that I am using apache poi in my android app I can create a sheet with my custom name HSSFSheet sheet = workbook.createSheet("my custom name"); but when I want to copy…
funfordevelopping
  • 383
  • 1
  • 3
  • 7
32
votes
3 answers

Are there any spreadsheet widgets for Android?

I have an Excel file that I want to use in my application. Using jexcel I read and write an Excel file in the application, but I don't know how to set up the view for that file in my application. Are there any spreadsheet widgets available for…
Sreedev
  • 6,563
  • 5
  • 43
  • 66
32
votes
4 answers

Spreadsheets get unique names but ignore blank cells

I would like to use spreadsheets to get all unique names from Column A in a table but in the same time I would like blank cells to be ignored. So far I've got this formula that returns all of the unique names from column A but I don't know how to go…
DIzZy
  • 323
  • 1
  • 3
  • 4
31
votes
7 answers

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: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet'); header('Content-Disposition: attachment;…
angel enanod
  • 431
  • 1
  • 5
  • 12
30
votes
4 answers

Import Excel into Rails app

I am creating a small rails app for personal use and would like to be able to upload excel files to later be validated and added to the database. I had this working previously with csv files, but this has since become impractical. Does anyone know…
Jack
  • 3,878
  • 15
  • 42
  • 72
29
votes
4 answers

In Google sheets, how does one either return a blank cell or perform a function based on another cells lack of content?

This is what I have thus far: =if(ISBLANK(A:A), (A:A+TIME(2, 0, 0)), "") I'd like the script to add 2 hours to A:A or just remain blank if there is no data inside A:A Any ideas would be greatly appreciated. Thank you :)
Chips147
  • 595
  • 3
  • 6
  • 12
29
votes
4 answers

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: application/vnd.ms-excel" ); header ( "Content-Disposition: attachment; filename=foo_bar.xls" ); But it will generate a file with just one…
Cristian
  • 198,401
  • 62
  • 356
  • 264
29
votes
2 answers

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 from Excel which matches conditions (eg., filtered by date, username) and display them with app script. My spreadsheet has…
palaniraja
  • 10,432
  • 5
  • 43
  • 76
27
votes
4 answers

Paste Excel data into html table

Using Javascript, how do I create an HTML table that can "accept" numeric matrix data from excel (or google spreadsheet), via "copy" in the spreadsheet and then "paste" into the table in the browser.
perrinmeyer
  • 333
  • 1
  • 3
  • 6
25
votes
1 answer

Excel VLOOKUP where the key is not in the first column

"The range where the lookup value is located. Remember that the lookup value should always be in the first column in the range for VLOOKUP to work correctly. For example, if your lookup value is in cell C2 then your range should start with C." But…
BrianFreud
  • 7,094
  • 6
  • 33
  • 50
24
votes
4 answers

Create in-cell dropdown with filtered range

I'm using Google Spreadsheet. To illustrate my problem, I use the range A2:A8 for the data validation of D2 and E2. But because in cell D2, you are supposed to select an animal only, I'd like to filter the range with B2:B8. What I've tried, is…
rayfranco
  • 3,630
  • 3
  • 26
  • 38
1
2 3
…
99 100