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
7
votes
1 answer

Importing a CSV with different row widths into Incanter?

I'm trying to import a CSV file with rows of many different lengths into Incanter using the read-dataset function. Unfortunately, it appears to truncate the rows down to the length of the first row. Short of reordering the dataset, or searching for…
Michael Curry
  • 79
  • 1
7
votes
3 answers

Difficulty with send_data in Ruby on Rails in conjunction with Spreadsheet plug-in

I have a function in a controller that takes in some specifications and generates a report on them. This function user_report is called in a view: < %= submit_to_remote 'submit-button', "Export Report to Excel", :url => { :controller => :reports,…
Chris K
  • 71
  • 1
  • 2
7
votes
1 answer

How to I add a hyperlink to a cell in axlsx?

With the spreadsheet gem, you can run Spreadsheet::Link.new('http://hyperlinkhere.com', 'Some words') to make a spreadsheet with a cell containing the string "Some words" with a hyperlink leading to "http://hyperlinkhere.com." What's the axlsx…
Username
  • 3,463
  • 11
  • 68
  • 111
7
votes
5 answers

Equivalent of “ScreenUpdating” in Google Apps Script (equivalent VBA-GAS )

I'm looking for the equivalent VBA-GAS of: Application.ScreenUpdating = False I'm running a very long macro in one of my Google Spreadsheets and it takes at least 30 seconds to finish it every time. It would be helpful if the macro didn't refresh…
Frank Montemorano
  • 321
  • 4
  • 6
  • 12
7
votes
1 answer

Spreadsheet-like input in html?

I'm writing a webpage (PHP/html/css) and I would like to let my users enter a lot of data, always consisting of the same information: day, hour, title, details, class. For this, I'd need a with fields, but with the additional feature…
user1111929
  • 6,050
  • 9
  • 43
  • 73
7
votes
3 answers

Open XML SDK: get "Unreadable content" error when trying to populate more than 25 columns

I have created a spreadsheet using Open XML SDK in C#, and successfully populated two worksheets. When trying to populate a third, I get an "Unreadable content" error when opening the completed document, and it appears to occur when I attempt to…
Rick Burgess
  • 73
  • 1
  • 3
7
votes
2 answers

Org mode spreadsheet programmatic remote references

I keep my budget in org-mode and have been pleased with how simple it is. The simplicity fails, however, as I am performing formulas on many cells; for instance, my year summary table that performs the same grab-and-calculate formulas for each …
WorldsEndless
  • 1,493
  • 1
  • 15
  • 27
7
votes
1 answer

how to add images in HSSFCell in apache POI?

How to add Image in different different HSSFCell object in poi ? I have written some code which is adding image but problem is, the cell were I added last image, That cell only showing image other than that no other cells are showing images…
Garudadwajan
  • 689
  • 4
  • 11
  • 24
7
votes
5 answers

How do I search Google Spreadsheets?

I am doing a few exhaustive searches and need to determine if a new domain (URL) is already in a Spreadsheet. However, none of the Spreadsheet objects have search functions, namely findText() found in most Document objects. I feel like I am missing…
MXMLLN
  • 1,387
  • 2
  • 12
  • 12
6
votes
1 answer

ruby excel reader, spreadsheet gem

i am trying to read an excel file in ruby and then take the data and insert it into a mysql database. I am using the spreadsheet::excel and mysql gems. for some reason i cannot seem to be able to use the spreadsheet gem to open the file for…
Crobos
  • 63
  • 1
  • 7
6
votes
3 answers

How to export data from model to excel file on rubyonrails

I'm trying to export data from my models to an excel spreadsheet. I have seen 3 ways Using the spreadsheet gem which I didn't understand how to use it, the examples I saw was writing to a local file but I'm looking to generate a file every time…
Luis D Urraca
  • 2,024
  • 4
  • 24
  • 46
6
votes
0 answers

Valid-by-construction table UI component data structure with merged cells

TL;DR: I’m looking for a data structure for a set of non-overlapping axis-aligned integer rectangles. I’m making a terminal user interface† that involves rendering tables. They’re akin to HTML tables or spreadsheet cells, in that adjacent cells may…
Jon Purdy
  • 53,300
  • 8
  • 96
  • 166
6
votes
3 answers

Algorithm for finding circular references in a spreadsheet

I have a spreadsheet application with formulas. I am looking for the best algorithm for detecting circular references among the formulas. The current approach I have is slow and uses too much memory when long chains of calculations are in place with…
Mike Dour
  • 3,616
  • 2
  • 22
  • 24
6
votes
8 answers

Alternative to MS-Access/Excel for Spreadsheet Manipulation

I have an MS-Access application that formats the data in two large spreadsheets (20,000+ rows), imports this data into tables, runs a few queries comparing the data and outputs the results as excel files. The problem is that as the application (and…
Breandán
  • 1,855
  • 22
  • 34
6
votes
2 answers

Flutter: How to read data from simple spreadsheet?

I am new to flutter and a have question that shouldn't be to hard to answer for a pro. I have a simple spreadsheet with 5 columns and 10 rows. Now I have two variables, representing column and row index. I want to simply read the corresponding value…
tmaihoff
  • 2,867
  • 1
  • 18
  • 40
1 2 3
…
99 100