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
21
votes
2 answers

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 every employee will be on this worksheet on any given day. In a 2nd worksheet I have a list of all employees' numbers and names. I want a…
Nicole Smith
  • 219
  • 1
  • 2
  • 3
21
votes
4 answers

How to export the Subversion log to spreadsheet

Is there a way to export the Subversion log messages to a spreadsheet(excel, csv, etc.) format? When copying from the Log Messages window in TortoiseSVN, it pastes text in the following format: Revision: 174 Author:…
lamcro
  • 6,069
  • 18
  • 57
  • 70
20
votes
1 answer

Sumif value is in year

I have list of dates and values: 01.01.2016 100 01.02.2017 200 01.03.2017 300 What i want is now if the the year is 2017 count the value. Result: 200 + 300 = 500 This is a formula i tried: =SUMIF($F5:$F,"<="&$A2,AF5:AF) The issue is that…
Taaut
  • 437
  • 4
  • 15
20
votes
3 answers

How to get value by column name in php spreadsheet-parser library?

I'm using akeneo-labs spreadsheet-parser library to extract data from xlsx file. use Akeneo\Component\SpreadsheetParser\SpreadsheetParser; $workbook = SpreadsheetParser::open('myfile.xlsx'); $myWorksheetIndex =…
Zeta
  • 663
  • 1
  • 12
  • 27
20
votes
4 answers

How to convert PDF files to spreadsheets

I have been trying the whole day to convert several. pdf files which contain traffic flow for São Paulo to spreadsheets like MS Office Excel, or LibreOffice Calc in Ubuntu. When I open the .pdf file with LibreOffice Calc it opens LibreOffice Draw,…
Sergio
  • 714
  • 1
  • 8
  • 24
19
votes
3 answers

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 overlap each other. So what I try to do is: Set the info in every cell to be centered since it makes better for printing to PDF/etc. Make the cells…
stAMy
  • 471
  • 2
  • 6
  • 14
19
votes
4 answers

Use arrow keys to navigate an HTML table

I've created a very basic spreadsheet using an HTML table. It works perfectly, except the user must use the mouse to click on every in order to edit it. I'm capturing the click event with jQuery and displaying a dialog to edit it. I would…
Lane
  • 2,669
  • 3
  • 25
  • 38
16
votes
1 answer

Saving a PhpSpreadSheet through button click

I'm trying to get my Laravel app to download an excel file with phpSpreadSheet a continuation of PhpExcel. But so far I'm not having any luck with it. I first tried to make an Axios call through an onClick but that didn't work since JS is not…
Ferdi van der Woerd
  • 366
  • 1
  • 4
  • 22
15
votes
5 answers

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 stuck and can't figure out what I'm missing. I'm just trying to have my Android app fill out a form on a website and submit it. I don't need the…
doeiqts
  • 663
  • 1
  • 6
  • 14
15
votes
3 answers

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 domain and I have the formula to remove www. but now I realize it does not strip subdomain prefixes like 'mysite'.site.com; where mysite is not stripped…
snh_nl
  • 2,877
  • 6
  • 32
  • 62
15
votes
4 answers

Spreadsheets that use a functional-programming language

I'd like to know if there exists a spreadsheet application which uses an existing functional-programming language to define functions. I've already heard about Resolver One which uses python, but I'm more interested in anything which uses a purely…
Viral Shah
  • 2,888
  • 2
  • 22
  • 25
15
votes
3 answers

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

In VBA for Excel, what is the difference between Sheets.Select and Sheets.Activate ?
Mehper C. Palavuzlar
  • 10,089
  • 23
  • 56
  • 69
15
votes
8 answers

A more advanced table/spreadsheet SWT implementation

I'm developing an application based on Eclipse's Rich Client Platform that relies heavily on the use of tables for showing and editing data. I'm currently using the SWT implementations of Table and TableViewer. My users are forever complaining that…
Tirno
  • 1,568
  • 2
  • 16
  • 21
14
votes
3 answers

How do I read the content of an Excel spreadsheet using Ruby?

I am trying to read an Excel spreadsheet file with Ruby, but it is not reading the content of the file. This is my script book = Spreadsheet.open 'myexcel.xls'; sheet1 = book.worksheet 0 sheet1.each do |row| puts row.inspect ; puts row.format…
Pavunkumar
  • 5,147
  • 14
  • 43
  • 69
13
votes
5 answers

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+ columns, 900+ rows of data. I need to reformat about 10 of those columns and stick them in a new workbook. How do I programmatically select every…
Tyler Rash
  • 1,165
  • 1
  • 8
  • 19
1
2
3
…
99 100