Tag Info

New answers tagged

2

Currently there is no any Add-on which offer this functionality, so you have to create or import custom functions by Script Editor available in Tools menu (for Spreadsheet). Then re-paste the ImportJSON code available at fastfedora GitHub and save it. From now on, you can use ImportJSON function, in example: ...


1

As stated in my comment, doing this with =importXML and XPath seems tricky. But doing it programmatically, using the XmlService of Google Apps Script, looks easier. I have written the following: function parseTvRageXml(url) { var result = []; var xml = UrlFetchApp.fetch(url).getContentText(); var document = XmlService.parse(xml); var root = ...


0

I need to keep the link with the source table because I need to add or remove records. So, Paste values only will not help. My source table is very bi, so I need in fact to extract some records and add neew data on them. It is not really nationality, I just gave an exemple, but multiple columns. I mean that from one very big database I need to extract only ...


0

I think you have two choices that would not suit you: 1) Put French into wherever you are importing from. 2) Once the range is imported, break the link (Copy, Paste special, Paste values only) so that deleting Ana in the source no longer causes her to disappear from the imported data. Both the above can be avoided with a lookup table but to do so ...



Top 50 recent answers are included