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
6
votes
4 answers

How to compare strings in google apps script

I am trying to compare string values that I have obtained from my google spreadsheet. My Months appear in this format " Jun13", "Aug13" etc. and my script has trouble comparing the values when they are in such formats var data =…
user3429475
  • 61
  • 1
  • 2
  • 4
6
votes
3 answers

Named ranges in google spreadsheet charts?

Edit: This question relates to the "old" google spreadsheets that were current in 2013. Is it possible to use named ranges in google spreadsheet charts? I need to dynamically update the dimension (starting position and size) of a range and be able…
ellockie
  • 3,730
  • 6
  • 42
  • 44
6
votes
2 answers

Inserting an Online Picture to Excel with VBA

I'm currently working on a project and need to fill in cells with pictures via URLs. All URLs are in one column, and I'd like to load the images in an adjacent column. I'm no VBA expert, but I found some code that worked, but for some reason I get…
Richard Oppenheimer
  • 63
  • 1
  • 1
  • 3
6
votes
4 answers

Write in an existing Excel .xls file which contains macros

I want to insert datas an existing Excel (.xls) file with Ruby under Linux. This file has already data, it has some format properties and it contains macros. I tried to insert data into the file with the spreadsheet gem but when I save…
Jerem
  • 191
  • 1
  • 9
6
votes
1 answer

How do spreadsheets update cells correctly / know what to update?

Spreadsheets are so beautiful! Cells can be linked on top of each other and if any formula / value / whatever changes in one of the cells everything updates correctly! Does anyone know the general concept on how spreadsheets do this? What I'm…
user1594138
  • 1,003
  • 3
  • 11
  • 20
6
votes
8 answers

What are good methods to perform spreadsheet-like calculations in a programming language?

What's the best way to do spreadsheet-like calculations in a programming language? Example: A multi-user application needs to be available over the web that crunches columns and cells of numbers like a spread-sheet based on user submission. What…
Kdigital
  • 3,795
  • 3
  • 28
  • 24
6
votes
1 answer

Merging cells with Ruby Gem Spreadsheet

How do I merge cells using the Ruby Spreadsheet gem. I would like to merge the first 6 cells on the first row of a worksheet. When I try the following it does not work: merge_format = Spreadsheet::Format.new :align => :merge 6.times do |j| …
John
  • 13,125
  • 14
  • 52
  • 73
6
votes
1 answer

Style an HTML table to look like a Spreadsheet like Google Docs

I am trying to create a simple spreadsheet (with a REST/JSON back end) that looks like the Google Docs spreadsheet (or Excel). I have a working model which uses HTML input boxes and Select boxes. Is there a way to style this so that it looks like a…
Tawani
  • 11,067
  • 20
  • 82
  • 106
5
votes
2 answers

How to close files in the ruby gem "Spreadsheet?"

The code below works as it should the FIRST time I run it: require 'rubygems' require 'spreadsheet' book = Spreadsheet.open '/Users/me/myruby/Mywks.xls' sheet = book.worksheet 0 row = sheet.row(1) puts row[1] book.write…
Roy
  • 57
  • 1
  • 6
5
votes
2 answers

How to use default org-mode spreadsheet auto-sum behavior ?

In this example: | | num | |---+-----| | | 5 | | | 6 | | | 4 | |---+-----| | # | 15 | | ^ | sum | #+TBLFM: $sum=vsum(@2..@-1); Every time you press "tab" in the sum area or C-c C-c in the table formula area below the table it…
Mauvis Ledford
  • 40,827
  • 17
  • 81
  • 86
5
votes
3 answers

Java Spreadsheet API - Read Write Modify

I need to create spreadsheet in various file format: .xls, .xlsx, .ods, csv. I want to know how can I achieve this in Java and about available open source API. I found some API for .xls, .xlsx but not .ods. Any information will be very…
Tapas Bose
  • 28,796
  • 74
  • 215
  • 331
5
votes
1 answer

How to preload spreadsheet data to Core Data in Swift 5?

I have a 8000 by 10 spreadsheet in Excel that I am building an iOS app around. I want to be able to access the data in each cell, be able to search for data in cells, and get access to related data by row. However, I am having trouble preloading…
Yonghwa Park
  • 51
  • 2
5
votes
1 answer

Generate a spreadsheet file on iOS that is readable both by Excel and Numbers

I need to generate a spreadsheet file on iOS that is readable both by Excel and Numbers. CSV file is not sufficient as it does not allow multiple sheets and/or formatting. Which format would work the best? And is there a library/framework that I…
Yurie
  • 899
  • 1
  • 6
  • 10
5
votes
1 answer

Sum vertically until empty cell on Google Sheets

This is the scenario. I need to get the sum of the values until it reaches a blank cell. After that it should start again calculating the sum after the blank cell. I need to add the fat and carbs of every ingredient of each dish individually. This…
eera5607
  • 305
  • 2
  • 8
5
votes
0 answers

Writing excel file very slow using PhpSpreadSheet

I am using PhpSpreahSheet to read multiple Excel file and merge them in one file. I read my files with this code : $readerData = new \PhpOffice\PhpSpreadsheet\Reader\Xlsx(); $spreadData = $readerData->load("File/file1.xlsx"); $readerData = new…
Toto D
  • 109
  • 2
  • 12
1 2 3
…
99 100