using importXML Xpath query, in Google Spreadsheet
html,xpath,spreadsheet
I'm using Xpath in Google docs to get the text inside <div>. I want to save the text inside <div id="job_description"> in one cell of Google doc spreadsheet, but it shows each <div> in separate cell. <div id="job_description"> <div> <strong> Basic Purpose: </strong> <br></br> </div> <div> Work closely with developers,...
excel,vba,spreadsheet
AlexP provided the following code to a question about copying columns. It works great for me except that in ws1, the columns have equations that get copied over to ws2. I just want to copy over the values, not the equations. Sub CopyHeaders() Dim header As Range, headers As Range...
google-spreadsheet,spreadsheet,worksheet-function
I have an invoice, where there are two columns: Rate (Column H) and Quantity (Column I). And there is Amount (Column J). I need a formula so that it would automatically multiply Rate and Quantity and show it in Amount. The number of rows would be changing (added or deleted),...
analytics,spreadsheet,google-analytics-api,dashboard
Im working on a custom google spreadsheet analytics dashboard. Here's the situation, I'm trying to get specific info: Sessions, users, pageviews pageviews/sessions, avg session duration, bouncerate and % new sessions. The thing is I almost have all the right information except for AVG Session duration and Pageviews/sessions. Here's a screenshot...
google-spreadsheet,spreadsheet,google-spreadsheet-api
I have a google form that my students fill out daily. All form responses feed into one workbook. From the workbook, I have a spreadsheet for "Clean" data. Which is just the information from the responses sheet needed to graph progress. The formula I am using in A2 is: ='Form...
function,google-apps-script,google-spreadsheet,spreadsheet
I'd like to implement a script to implement range protections on the different tabs of the spreadsheet when someone create a new spreadsheet by copying my template. The issue I encounter is when the script run through the protection implementation. My code seems to be fine as per the debug...
google-spreadsheet,range,spreadsheet
I'm trying to compute the average of values in a range, but not including the lowest value. What I'd like to do is something like: =AVERAGE(SUBRANGE(SORT(A1:A10,1,FALSE), 1, 9)) Essentially, this would sort descending, then take the subrange consisting of all but the last element in the now-sorted range, and average...
data,spreadsheet,rdbms,flat-file
Could anyone help me answer this question: How do RDBM’s make working with data more effective than flat files and spreadsheets. ...
join,google-spreadsheet,spreadsheet
I have found many useful answers before, but this is my first question on this forum. Feel free to give me feedback about my question as well as an answer. Below is a link to a Google Spreadsheet in which students signed up for workshops for our career fair. I'm...
google-spreadsheet,spreadsheet
So I am working on the same spreadsheet I have been working on for a bit now and it mostly works aside from one small quirk. If any of the queries in an array formula do not have actual data to query in the range they are hitting they return...
excel,powerpoint,spreadsheet
I use PowerPoint as a graphics template to type up football player names and there squad numbers. It can be a long procedure and so far following YouTube tutorials i have managed to create a form in Excel which can update the text boxes in PowerPoint at the click of...
python,spreadsheet,gspread
I have a data list (extracted from CSV) and I'm trying to use Python / GSpread to update a range of cells on a Google Doc. Here is my code sample: import gspread def write_spreadsheet(spreadsheet_name, sheet_id, data, start_row): gc = gspread.login('
[email protected]', 'password') wks = gc.open(spreadsheet_name).get_worksheet(sheet_index) start_letter = 'A' end_letter =...
html,css,character,spreadsheet
Backstory So I am doing a webchat as a side-project, and one of the issues I am encountering is making the UX of copying and pasting messages friendly. Right now all of the elements are organized within their own tags, spaced out and separated with CSS rules, in a way...
excel,google-spreadsheet,spreadsheet
I want to do a formula that multiplies 2 values on each row with the same ID (another value) of the row where the formula is. Like a sumproduct selecting only certain rows (by ID) in the range. I shared the doc here so that you can understand what I...
java,hashtable,spreadsheet
Can we link another hash table for each key, in a hash table? My target is to have a very fast 2-d data structure to store cells in a spreadsheet. I'll store "all columns within a row" in a hash table. Then do this to all 'r' number of rows....
vb.net,devexpress,spreadsheet
DevExpress website is unable to tell me. How can I influence the line color, thickness, etc. of created graphs? Dim chart As Chart = myworb.Worksheets(1).Charts.Add(Charts.ChartType.ScatterLine) chart.TopLeftCell = myworb.Worksheets(1).Cells("A83") chart.BottomRightCell = myworb.Worksheets(1).Cells("F112") chart.PlotArea.Fill.SetNoFill() chart.Series.Add(myworb.Worksheets(1)("A1:A71"), myworb.Worksheets(1)("B1:B71")) chart.Series.Add(myworb.Worksheets(1)("D1:D81"), myworb.Worksheets(1)("E1:E81"))...
excel,if-statement,spreadsheet,calc
I would appreciate some help writing a statement in a spreadsheet (Libreoffice). IF E4 contains "bought" then do the sum of I4-F4 ELSE / ELSEIF E4 contains "sold" do the sum of F4-I4. I have it partially working: if E4 contains "bought" the correct sum is displayed, but if E4...
google-apps-script,google-spreadsheet,spreadsheet
How can I get keyboard events in Google Spreadsheets? I want to use this events in my script to format non-adjacent cells.
google-apps-script,spreadsheet
Okay, first of all, what I'm trying to do is updating Google sheet and calendar simultaneously. So, let say if there's an update to your spreadsheet there will also be an update to the calendar. However, here's all the things that I failed to do. If there's changes in the...
google-apps-script,spreadsheet
I have a sheet which I need to copy to hundreds of spreadsheets in a given folder in Google Drive. I am just beginning with script and I do not know how to proceed because the script below just gives me an error. Thanks. function myFunction() { var source =...
excel,perl,spreadsheet
I have a .xlsx file (only one sheet) with 15 columns. I want to read some specific columns, let's say columns 3, 5, 11, 14 and write it to a new Excel sheet. In this case some cells of input files are empty means don't have any value. Here what...
ruby,excel,spreadsheet
I'm trying to take an excel file and put it into Postgres. I can access the file and read rows from it. require 'spreadsheet' Spreadsheet.client_encoding = 'UTF-8' book = Spreadsheet.open 'C:\test\RubyTestFile.xls' sheet1 = book.worksheet 0 $test_array = [] sheet1.each do |row| $test_array += row end print $test_array My problem is...
extjs,spreadsheet,wijmo
I have written a script which creates an Excel-like spreadsheet using Wijmo library (spreadJS). I try to integrate this spreadsheet inside an ExtJS panel but I get an error: Uncaught TypeError: undefined is not a function I have two files. The first is the index.html where I have all the...
excel,google-spreadsheet,excel-formula,spreadsheet,openoffice-calc
I'd like to calculate the sum of multiple values for a range of overlapping dates. It should return the sum for a specific year and split the values that fall into more than one year proportionally. Example: ╔══════════╦════════════╦════════════╗ ║ Value ║ From ║ To ║ ╠══════════╬════════════╬════════════╣ ║ 100,00 € ║...
google-spreadsheet,spreadsheet
I have a formula that queries two sheets in the document and pulls data to a third sheet. If I add new data to the first sheet after the query has completed and then go back to the third sheet (with the query results) the new data is not at...
excel,google-spreadsheet,spreadsheet
Trying to convert or recreate this Google Sheets formula in Excel. What I have is a list of users that may or may not repeat and I am trying to find the number of purchaes, lowest purchase amount, the total price of purchases and the average price of purchases. Here...
python,arrays,for-loop,spreadsheet,xlwt
For every 4 values in this array, I want it to write to a new row in the spreadsheet while disregarding the first column. This is because I'm going to be putting different values from a separate array there. For example, I have five columns: A B C D E...
google-spreadsheet,spreadsheet,pivot-table
I am trying to build graphic indicators from a (potentially) large set of data using google-spreadsheet. So far, I've used a pivot table to extract the information from the raw data, and I want to build intermediate tables to calculate the different values I need for my indicators. So far,...
excel,google-spreadsheet,spreadsheet
please help me to create a simple Google spreadsheet. 1st function If value/text in cells C3, D3 & E3 ="passed"- change F3's value to "passed" else show "failed" 2nd function If value/text in any of the cell is "passed"- change F3's value to "passed" else show "failed"...