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,function,math,excel-formula,spreadsheet
I am trying to do the following: "Put a formula in D13 that will either Add Number 1, Number 2 and Number 3 or multiply them depending on what you put in D12. You should put in some sort of error message too if the user puts in something incorrect."...
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...
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...
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...
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 =...
google-spreadsheet,spreadsheet,google-docs
I would like to perform a multi criteria search of data in a column- contains data of check boxes(more than one option chosen). For a clearer picture of what I am trying to do, screenshot below is a question in a form Data from the form are saved in sheets...
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...
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...
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...
function,google-spreadsheet,spreadsheet,google-spreadsheet-api,sheet
I'm trying to make a budget sheet for a trip. I got 2 spreadsheets. 1 contains the steps of the trip. The other contains a dashboard with the sum for each of these 5 groups of steps : "food", "activities", "shopping", "hotels" and "vehicle". My first sheet is like that...
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.
button,google-spreadsheet,spreadsheet
I've been searching for similar solutions out there but am coming up short so far. Here is what I want to accomplish: I need to come up with a basic solution to sync inventory quantities at the end of each day. We take physical counts of inventory sold throughout the...
google-apps-script,append,spreadsheet,value
I've got a Google Spreadsheet which looks like this: ID | winkelName | 26/05/2015 | 1 | Foo | | 2 | Bar | | 3 | Foo2 | | 4 | Bar2 | | I'm trying to read and write an array of objects with the following structure: history[i].storeName...
ruby,excel,postgresql,gem,spreadsheet
I have a method that runs through an excel spreadsheet and puts those values into an array then into PostgreSQL. Everything runs fine but the cell values that hold dates are being returned as doubles. How can I get the date values? Also what if I don't know when a...
function,google-spreadsheet,spreadsheet,google-docs
I've read several similar questions but I couldn't find the answer. I've certain number values that the MATCH() function, with the search_type option set as 1, can't retrieve. The best way to explain it, is to share the spreadsheet (here) where you can see in details on which columns the...
forms,url,unique,spreadsheet
I want to send my clients in my database an e-mail with a request to fill in a Google form to research their needs for our service in the future. Every client has an unique ID already (for example EX0258, EA1405, EZ2815). I need a way how I can add...
excel,google-spreadsheet,excel-formula,spreadsheet
I want to scale the value of column A and write it in column C based on it's corresponding value in column B and scaling values are given in column F. ...
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 € ║...
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...
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...
python,macros,spreadsheet,libreoffice,uno
The premise: I am working in libreoffice calc and need to send an instruction to another program that I know to be listening on a TCP port, via a python macro. I am expecting a list of invoice line data from the listening program and want to insert the lines...
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,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),...
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...
count,google-spreadsheet,spreadsheet,conditional-statements
I currently have a table in a layout similar to this: Quality | Fruit1 | Fruit2 | Fruit3 ---------------------------------- Sweet | Apple | Orange | Pear Firm | Pear | Apple | Watermelon Sweet | Orange | Pear | Melon Soft | Banana | Orange | Strawberry Firm | Apple...
regex,google-spreadsheet,spreadsheet
I am having in a google spreadsheet multiple cells the following text(only the Language changes): Lorem ipsum dolor. sit.com<br><br>Languages: English to Dutch<br/><br/> I would only like to display English to Dutch in a separate cell. I tried this: =REGEXEXTRACT(D2,"<br>(.*?)</br>") However, I do not come very far with this solution, because...
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"...
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
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...
google-spreadsheet,spreadsheet,google-spreadsheet-api
Using Google Spreadsheets, I need to enter data structured like the example below. There will be multiple "quadrants" Each "quadrant" can contain one or many "days", Each "day" can contain one or many "times". This data will ultimately be imported in some backend db (e.g. Access DB, SQL, MySQL)....
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...